Infolinks

Tuesday, 15 May 2012

TABLES OF INV,PO,OM WITH LINKS

-------------------INVENTORY-----------------

SELECT * FROM ORG_ORGANIZATION_DEFINITIONS OOD

SELECT * FROM MTL_SECONDARY_INVENTORIES MSI

SELECT * FROM MTL_ITEM_LOCATIONS MIL

SELECT * FROM MTL_SYSTEM_ITEMS_B MSIB

SELECT * FROM MTL_ONHAND_QUANTITIES MOQ

SELECT * FROM MTL_MATERIAL_TRANSACTIONS  MMT

SELECT * FROM  MTL_ITEM_CATEGORIES MIC

SELECT * FROM MTL_ITEM_TEMPLATES MIT

SELECT * FROM MTL_PARAMETERS MP

OOD.ORGANIZATION_ID=MSI.ORGANIZATION_ID

MSI.ORGANIZATION_ID=MIL.ORGANIZATION_ID

OOD.ORGANIZATION_ID=MSIB.ORGANIZATION_ID

MSIB.INVENTORY_ITEM_ID=MOQ.INVENTORY_ITEM_ID

MSIB.INVENTORY_ITEM_ID=PLA.ITEM_ID

OOLA.INVENTORY_ITEM_ID=MSIB.INVENTORY_ITEM_ID

OOLA.SHIP_FROM_ORG_ID=MSIB.ORGANIZATION_ID

------------------------------PURCHASE ORDER-------------

SELECT * FROM USER_OBJECTS WHERE OBJECT_NAME LIKE 'MTL_%'

SELECT * FROM USER_TABLES WHERE TABLE_NAME LIKE 'MTL_M%'

SELECT * FROM PO_REQUISITION_HEADERS_ALL PRHA

SELECT * FROM PO_REQUISITION_LINES_ALL PRLA

SELECT * FROM PO_REQ_DISTRIBUTIONS PRD

SELECT * FROM PO_HEADERS_ALL PHA

SELECT * FROM PO_LINES_ALL  PLA

SELECT * FROM PO_LINE_LOCATIONS PLL

SELECT * FROM PO_DISTRIBUTIONS_ALL PDA

SELECT * FROM RCV_SHIPMENT_HEADERS RSH

SELECT * FROM RCV_SHIPMENT_LINES RSL

SELECT * FROM RCV_TRANSACTIONS RT

PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID

PRLA.REQUISITION_LINE_ID=PRD.REQUISITION_LINE_ID

PRD.DISTRIBUTION_ID=PDA.REQ_DISTRIBUTION_ID

PDA.PO_HEADER_ID=PHA.PO_HEADER_ID

PLA.PO_LINE_ID=PLLA.PO_LINE_ID

PLLA.LINE_LOCATION_ID=PDA.LINE_LOCATION_ID

PHA.PO_HEADER_ID=PLA.PO_HEADER_ID

PLA.PO_LINE_ID=PLLA.PO_LINE_ID

PLA.PO_LINE_ID=PDA.PO_LINE_ID

PHA.PO_HEADER_ID=PDA.PO_HEADER_ID

PHA.PO_HEADER_ID=RT.PO_HEADER_ID

RSH.SHIPMENT_HEADER_ID=RSL.SHIPMENT_HEADER_ID

RSL.SHIPMENT_LINE_ID=RT.SHIPMENT_LINE_ID

RSH.SHIPMENT_HEADER_ID=RT.SHIPMENT_HEADER_ID

PLLA.LINE_LOCATION_ID=PDA.LINE_LOCATION_ID

PLA.ITEM_ID=MSIB.INVENTORY_ITEM_ID

PLA.SHIP_TO_ORG_ID=MSIB.ORGANIZATION_ID

AC.CUSTOMER_ID=PHA.VENDOR_ID

AP.VENDOR_ID=PHA.VENDOR_ID

ASS.VENDOR_SITE_ID=PHA.VENDOR_SITE_ID

ASC.VENDOR_CONTACT_ID=PHA.VENDOR_CONTACT_ID

PAPF.PERSON_ID=PHA.AGENT_ID

MSIB.INVENTORY_ITEM_ID=PLA.ITEM_ID



------------------------------------------SUPPLIERS AND CUSTOMERS AND BUYERS-------------

--------------------------------------COMPLETE TABLES AND LINKS OF INC,OM,PO WITH CUSTOMERS AND SUPPLIERS------------------

SELECT * FROM AP_SUPPLIERS AP

SELECT * FROM AP_SUPPLIER_SITES_ALL ASS

SELECT * FROM AP_SUPPLIER_CONTACTS ADC

SELECT * FROM MTL_SYSTEM_ITEMS_B MSIB

SELECT * FROM AR_CUSTOMERS AC

SELECT * FROM RA_SALESREPS_ALL RSA

SELECT * FROM QP_LIST_HEADERS QLH

SELECT * FROM PER_ALL_PEOPLE_F PAPF

SELECT * FROM OE_TRANSACTION_TYPES OTT

SELECT * FROM OE_ORDER_HEADERS_ALL OOHA

SELECT * FROM OE_ORDER_LINES OOLA

SELECT * FROM WSH_DELIVERY_DETAILS WDD

SELECT * FROM WSH_DELIVERY_ASSIGNMENTS WDA

SELECT * FROM WSH_NEW_DELIVERIES WND

OOHA.HEADER_ID=OOLA.HEADER_ID

OOLA.LINE_ID=WDD.SOURCE_LINE_ID

WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID

WDA.DELIVERY_ID=WND.DELIVERY_ID

OOHA.ORDER_TYPE_ID=OTT.TRANSACTION_TYPE_ID

OOHA.PRICE_LIST_ID=QLH.LIST_HEADER_ID

OOHA.SALESREP_ID=RS.SALESREP_ID

OOHA.SOLD_TO_ORG_ID=AC.CUSTOMER_ID

OOLA.INVENTORY_ITEM_ID=MSIB.INVENTORY_ITEM_ID

OOLA.SHIP_FROM_ORG_ID=MSIB.ORGANIZATION_ID

--------------------------------------COMPLETE TABLES AND LINKS OF INC,OM,PO WITH CUSTOMERS AND SUPPLIERS------------------

No comments:

Post a Comment