O2C,P2P

==============================================================================================

O2C CYCLE

==============================================================================================

SELECT OOHA.ORG_ID
FROM
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD,
WSH_NEW_DELIVERIES WND,
WSH_DELIVERY_ASSIGNMENTS WDA,
QP_LIST_HEADERS QLH,
RA_SALESREPS RS,
OE_TRANSACTION_TYPES_TL OTTT,
PER_ALL_PEOPLE_F PAPF,
AR_CUSTOMERS AC,
HR_LOCATIONS HL,
HR_LOCATIONS HL1,
/*WSH_TRIPS WT,
WSH_TRIP_STOPS WTS,
WSH_DELIVERY_LEGS WDL,*/
MTL_TXN_REQUEST_HEADERS MTRH,
MTL_TXN_REQUEST_LINES MTRL,
RA_CUSTOMER_TRX_ALL RCT,
RA_CUSTOMER_TRX_LINES_ALL RCTLA,
RA_CUST_TRX_LINE_GL_DIST_ALL RCTLGDA,
RA_CUST_TRX_TYPES_ALL RCTTA,
RA_INTERFACE_LINES_ALL RILA,     --WND.DELIVERY_ID,RILA.INTERFACE_LINE_ATTRIBUTE1
RA_INTERFACE_DISTRIBUTIONS_ALL RIDA,  --RIDA.INTERFACE_LINE_ID,RILA.INTERFACE_LINE_ID
AR_PAYMENT_SCHEDULES_ALL APSA,
AR_CASH_RECEIPTS_ALL ACRA,
GL_JE_HEADERS GLH,
GL_JE_LINES GLL,
GL_JE_BATCHES GLB,
--GL_SET_OF_BOOKS GSOB,
GL_BALANCES GB,
GL_IMPORT_REFERENCES GLIMP,
XLA_AE_HEADERS XAH,
XLA_AE_LINES XAL,
XLA_DISTRIBUTION_LINKS XDL,
XLA_TRANSACTION_ENTITIES XTE,
XLA_EVENTS XEV,
ORG_ORGANIZATION_DEFINITIONS OOD,
MTL_SYSTEM_ITEMS_B MSIB,
MTL_ONHAND_QUANTITIES MOQ,
MTL_MATERIAL_TRANSACTIONS MMT,
MTL_ITEM_CATEGORIES MIC
WHERE  XAH.APPLICATION_ID=XEV.APPLICATION_ID
AND    XEV.EVENT_ID=XAH.EVENT_ID
AND XAL.APPLICATION_ID=XAH.APPLICATION_ID
AND  XAL.AE_HEADER_ID=XAH.AE_HEADER_ID
AND  XEV.APPLICATION_ID=XDL.APPLICATION_ID
AND XAL.AE_LINE_NUM=XDL.AE_LINE_NUM
AND XAH.AE_HEADER_ID=XDL.AE_HEADER_ID
AND XDL.SOURCE_DISTRIBUTION_TYPE='RCV_RECEVING_SUB_LEDGER'
AND XDL.SOURCE_DISTRIBUTION_ID_NUM_1='3002'
AND GLIMP.JE_HEADER_ID=GLH.JE_HEADER_ID
AND GLIMP.JE_LINE_NUM=GLL.JE_LINE_NUM
AND GLIMP.JE_BATCH_ID=GLB.JE_BATCH_ID
AND GLH.JE_HEADER_ID=GLL.JE_HEADER_ID
AND GLH.JE_BATCH_ID=GLB.JE_BATCH_ID
AND GLIMP.GL_SL_LINK_ID='245133'
AND GLIMP.GL_SL_LINK_TABLE='XLAJEL'
AND OOHA.HEADER_ID=OOLA.HEADER_ID
AND OOLA.LINE_ID=WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID=WND.DELIVERY_ID
AND QLH.LIST_HEADER_ID=OOLA.PRICE_LIST_ID
AND RS.SALESREP_ID=OOLA.SALESREP_ID
AND OTTT.TRANSACTION_TYPE_ID=OOLA.ORDERED_ITEM_ID
AND AC.CUSTOMER_ID=OOHA.SOLD_TO_ORG_ID
AND HL.LOCATION_ID=OOLA.INVOICE_TO_ORG_ID
AND HL1.LOCATION_ID=OOHA.SHIP_FROM_ORG_ID
AND OOD.ORGANIZATION_ID=OOHA.SHIP_FROM_ORG_ID
AND OOD.ORGANIZATION_ID=MSIB.ORGANIZATION_ID
AND MSIB.ORGANIZATION_ID=MMT.ORGANIZATION_ID
AND MSIB.INVENTORY_ITEM_ID=MMT.INVENTORY_ITEM_ID
AND MSIB.ORGANIZATION_ID=MOQ.ORGANIZATION_ID
AND MSIB.INVENTORY_ITEM_ID=MOQ.INVENTORY_ITEM_ID
AND MSIB.ORGANIZATION_ID=MIC.ORGANIZATION_ID
AND MSIB.INVENTORY_ITEM_ID=MIC.INVENTORY_ITEM_ID
AND OOHA.ORDER_NUMBER=RCT.INTERFACE_HEADER_ATTRIBUTE1
AND RCT.CUSTOMER_TRX_ID=RCTLA.INTERFACE_LINE_ATTRIBUTE1
AND RCTLA.CUSTOMER_TRX_LINE_ID=RCTLGDA.CUSTOMER_TRX_LINE_ID
AND RCTLA.CUSTOMER_TRX_ID=APSA.CUSTOMER_TRX_ID
AND XAL.GL_SL_LINK_ID=GLIMP.GL_SL_LINK_ID
AND RCTLA.CUSTOMER_TRX_ID=APSA.CUSTOMER_TRX_ID
AND OOHA.CUST_PO_NUMBER=ACRA.RECEIPT_NUMBER

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE '%XLA_TR%'
===================================================================================

 P2P CYCLE

===================================================================================

SELECT
FROM
PO_REQUISITION_HEADERS_ALL PRHA,
PO_REQUISITION_LINES_ALL PRLA,
PO_REQ_DISTRIBUTIONS_ALL PRDA,
PO_HEADERS_ALL PHA,
PO_LINES_ALL PLA,
PO_LINE_LOCATIONS_ALL PLLA,
PO_DISTRIBUTIONS_ALL PDA,
RCV_SHIPMENT_HEADERS RSH,
RCV_SHIPMENT_LINES RSL,
RCV_TRANSACTIONS RT,
PO_VENDORS PV,
PO_VENDOR_SITES_ALL PVS,
PO_VENDOR_CONTACTS PVC,
HR_LOCATIONS HL,
AP_INVOICES_ALL AIA,
AP_INVOICE_LINES_ALL AILA,
AP_INVOICE_DISTRIBUTIONS_ALL AIDA,
AP_TERMS AT,
AP_PAYMENT_SCHEDULES_ALL APSA,
AP_INVOICE_PAYMENTS_ALL AIPA,
AP_CHECKS_ALL ACA,
AP_ACCOUNTING_EVENTS_ALL AAEA,
AP_AE_HEADERS_ALL AAHA,
AP_AE_LINES_ALL AALA,
AP_BANK_BRANCHES ABB,
GL_JE_HEADERS GLH,
GL_JE_LINES GLL,
GL_JE_BATCHES GLB,
GL_SET_OF_BOOKS GSOB,
GL_BALANCES GB,
GL_IMPORT_REFERENCES GLIMP,
XLA_AE_HEADERS XAH,
XLA_AE_LINES XAL,
XLA_DISTRIBUTION_LINKS XDL,
XLA_TRANSACTION_ENTITIES XTE,
XLA_EVENTS XEV,
ORG_ORGANIZATION_DEFINITIONS OOD,
MTL_SYSTEM_ITEMS_B MSIB,
MTL_ONHAND_QUANTITIES MOQ,
MTL_MATERIAL_TRANSACTIONS MMT,
MTL_ITEM_CATEGORIES MIC
WHERE  PRHA.REQUISITION_HEADER_ID=PRLA.REQUISITION_HEADER_ID
AND    PRLA.REQUISITION_LINE_ID=PRDA.REQUISITION_LINE_ID
AND    PRDA.DISTRIBUTION_ID=PDA.REQ_DISTRIBUTION_ID
AND    PHA.PO_HEADER_ID=PLA.PO_HEADER_ID
AND    PLA.PO_LINE_ID=PLLA.PO_LINE_ID
AND    PLLA.LINE_LOCATION_ID=PDA.LINE_LOCATION_ID
AND    PHA.PO_HEADER_ID=RT.PO_HEADER_ID
AND    RSH.SHIPMENT_HEADER_ID=RSL.SHIPMENT_HEADER_ID
AND    RSL.SHIPMENT_LINE_ID=RT.SHIPMENT_LINE_ID
AND    RSH.SHIPMENT_HEADER_ID=RT.SHIPMENT_HEADER_ID
AND    PDA.REQ_DISTRIBUTION_ID=RSL.REQ_DISTRIBUTION_ID
AND    PV.VENDOR_ID=PHA.VENDOR_ID
AND    PVS.VENDOR_SITE_ID=PHA.VENDOR_SITE_ID
AND    PVC.VENDOR_CONTACT_ID=PHA.VENDOR_CONTACT_ID
AND    PDA.PO_DISTRIBUTION_ID=AIDA.PO_DISTRIBUTION_ID
AND    AIA.INVOICE_ID=AILA.INVOICE_ID
AND    AIA.INVOICE_ID=AIPA.INVOICE_ID
AND    AIPA.CHECK_ID=ACA.CHECK_ID
AND    AIA.INVOICE_ID=APSA.INVOICE_ID
AND    XAH.APPLICATION_ID=XEV.APPLICATION_ID
AND    XEV.EVENT_ID=XAH.EVENT_ID
AND XAL.APPLICATION_ID=XAH.APPLICATION_ID
AND  XAL.AE_HEADER_ID=XAH.AE_HEADER_ID
AND  XEV.APPLICATION_ID=XDL.APPLICATION_ID
AND XAL.AE_LINE_NUM=XDL.AE_LINE_NUM
AND XAH.AE_HEADER_ID=XDL.AE_HEADER_ID
AND XDL.SOURCE_DISTRIBUTION_TYPE='RCV_RECEVING_SUB_LEDGER'
AND XDL.SOURCE_DISTRIBUTION_ID_NUM_1='3002'
AND GLIMP.JE_HEADER_ID=GLH.JE_HEADER_ID
AND GLIMP.JE_LINE_NUM=GLL.JE_LINE_NUM
AND GLIMP.JE_BATCH_ID=GLB.JE_BATCH_ID
AND GLH.JE_HEADER_ID=GLL.JE_HEADER_ID
AND GLH.JE_BATCH_ID=GLB.JE_BATCH_ID
AND GLIMP.GL_SL_LINK_ID='245133'
AND GLIMP.GL_SL_LINK_TABLE='XLAJEL'
AND OOHA.HEADER_ID=OOLA.HEADER_ID
AND OOLA.LINE_ID=WDD.SOURCE_LINE_ID
AND WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
AND WDA.DELIVERY_ID=WND.DELIVERY_ID
AND QLH.LIST_HEADER_ID=OOLA.PRICE_LIST_ID
AND RS.SALESREP_ID=OOLA.SALESREP_ID
AND OTTT.TRANSACTION_TYPE_ID=OOLA.ORDERED_ITEM_ID
AND AC.CUSTOMER_ID=OOHA.SOLD_TO_ORG_ID
AND HL.LOCATION_ID=OOLA.INVOICE_TO_ORG_ID
AND HL1.LOCATION_ID=OOHA.SHIP_FROM_ORG_ID
AND OOD.ORGANIZATION_ID=OOHA.SHIP_FROM_ORG_ID
AND OOD.ORGANIZATION_ID=MSIB.ORGANIZATION_ID
AND MSIB.ORGANIZATION_ID=MMT.ORGANIZATION_ID
AND MSIB.INVENTORY_ITEM_ID=MMT.INVENTORY_ITEM_ID
AND MSIB.ORGANIZATION_ID=MOQ.ORGANIZATION_ID
AND MSIB.INVENTORY_ITEM_ID=MOQ.INVENTORY_ITEM_ID
AND MSIB.ORGANIZATION_ID=MIC.ORGANIZATION_ID
AND MSIB.INVENTORY_ITEM_ID=MIC.INVENTORY_ITEM_ID


=====================================================================================
O2C  FLOW 2ND(ENTER,BOOK,PICK RELEASE,SHIP CONFIRM,AUTO INVOICE,TRANSACTIONS,CASH RECEIPTS,GL)

SELECT OOHA.ORDER_NUMBER,OOLA.ORDERED_QUANTITY,OOHA.FLOW_STATUS_CODE,OOLA.FLOW_STATUS_CODE,
WDD.RELEASED_STATUS,WND.STATUS_CODE
FROM
OE_ORDER_HEADERS_ALL OOHA,
OE_ORDER_LINES_ALL OOLA,
WSH_DELIVERY_DETAILS WDD,
WSH_DELIVERY_ASSIGNMENTS WDA,
WSH_NEW_DELIVERIES WND,
MTL_TXN_REQUEST_HEADERS MTRH,
MTL_TXN_REQUEST_LINES MTRL,
WSH_DELIVERY_LEGS WDL,
WSH_TRIPS WT,
WSH_TRIP_STOPS WTS,
RA_INTERFACE_LINES_ALL RILA,
RA_INTERFACE_DISTRIBUTIONS_ALL RIDA,
RA_CUSTOMER_TRX_ALL RCTA,
RA_CUSTOMER_TRX_LINES_ALL RCTLA,
RA_CUST_TRX_LINE_GL_DIST_ALL RCTLGDA,
AR_PAYMENT_SCHEDULES_ALL APSA,
AR_CASH_RECEIPTS_ALL ACRA,
GL_JE_HEADERS GJH,
GL_JE_LINES GJL,
GL_JE_BATCHES GJB,
GL_BALANCES GB,
GL_IMPORT_REFERENCES GLIMP,
XLA_AE_HEADERS XAH,
XLA_AE_LINES XAL,
XLA_DISTRIBUTION_LINKS XDL,
XLA_TRANSACTION_ENTITIES XTE,
XLA_EVENTS XEV,QP_LIST_HEADERS QLH,
RA_SALESREPS_ALL RS,
OE_TRANSACTION_TYPES_TL OTTT,
PER_ALL_PEOPLE_F PAPF,
AR_CUSTOMERS AC,
HR_LOCATIONS_ALL HL
WHERE OOHA.HEADER_ID=OOLA.HEADER_ID
AND   OOLA.LINE_ID=WDD.SOURCE_LINE_ID
AND   WDD.DELIVERY_DETAIL_ID=WDA.DELIVERY_DETAIL_ID
AND   WDA.DELIVERY_ID=WND.DELIVERY_ID
AND   WND.DELIVERY_ID=RILA.INTERFACE_LINE_ID
AND   RILA.INTERFACE_LINE_ID=RIDA.INTERFACE_LINE_ID
AND   OOHA.ORDER_NUMBER=RCTA.INTERFACE_HEADER_ATTRIBUTE1
AND    XAH.AE_HEADER_ID=XAL.AE_HEADER_ID
AND    XAL.AE_LINE_NUM=XDL.AE_LINE_NUM
AND    XDL.APPLICATION_ID=XTE.APPLICATION_ID
AND    XTE.ENTITY_ID=XEV.APPLICATION_ID
AND    XAH.ENTITY_ID=XDL.AE_HEADER_ID
AND    XDL.EVENT_ID=XEV.ENTITY_ID
AND    XAH.ENTITY_ID=XTE.APPLICATION_ID
AND    XAL.GL_SL_LINK_ID=GLIMP.GL_SL_LINK_ID
AND    GLIMP.JE_HEADER_ID=GJH.JE_HEADER_ID
AND    GJH.JE_HEADER_ID=GJL.JE_HEADER_ID
AND    GLIMP.JE_LINE_NUM=GJL.JE_LINE_NUM
AND    GJH.JE_BATCH_ID=GJB.JE_BATCH_ID
AND QLH.LIST_HEADER_ID=OOLA.PRICE_LIST_ID
AND RS.SALESREP_ID=OOLA.SALESREP_ID
AND OTTT.TRANSACTION_TYPE_ID=OOLA.ORDERED_ITEM_ID
AND AC.CUSTOMER_ID=OOHA.SOLD_TO_ORG_ID
AND HL.LOCATION_ID=OOLA.INVOICE_TO_ORG_ID
AND RCTA.CUSTOMER_TRX_ID=RCTLA.INTERFACE_LINE_ATTRIBUTE1
AND RCTLA.CUSTOMER_TRX_LINE_ID=RCTLGDA.CUSTOMER_TRX_LINE_ID
AND RCTLA.CUSTOMER_TRX_ID=APSA.CUSTOMER_TRX_ID
AND ACRA.RECEIPT_NUMBER=RCTA.CUSTOMER_TRX_ID
AND XAL.GL_SL_LINK_ID=GLIMP.GL_SL_LINK_ID
AND RCTLA.CUSTOMER_TRX_ID=APSA.CUSTOMER_TRX_ID
AND OOHA.CUST_PO_NUMBER=ACRA.RECEIPT_NUMBER
AND XDL.SOURCE_DISTRIBUTION_ID_CHAR_1='RA_CUST_TRX_LINE_GL_DIST_ALL'
AND XDL.SOURCE_DISTRIBUTION_ID_NUM_1='CUST_TRX_LINE_GL_DIST_ID'

AND OOHA.ORDER_NUMBER='66404'

==============================================================

select * from all_tables  where table_name like 'WSH_TRIP_%' AND TABLESPACE_NAME LIKE 'APPS_%';

HR_ITEM_PROPERTIES_B

HR_ITEM_PROPERTIES_TL

HR_LOCATIONS_ALL

HR_LOCATION_EXTRA_INFO

HR_LOCATION_INFO_TYPES

HR_S_PAYMENT_TYPES

HR_S_USER_ENTITIES

HR_TEMPLATE_ITEMS_B

HR_TEMPLATE_TAB_PAGES_B

HR_TEMPLATE_WINDOWS_B

HR_TRANSACTION_SNAPSHOT

HR_WORKFLOWS_TEMP

HR_WORKING_PERSON_LISTS

HR_ASSIGNMENT_SETS

HR_OWNER_DEFINITIONS

HR_WORKFLOWS

HR_LOCATIONS_ALL_TL

HR_ALL_ORGANIZATION_UNITS_TL