P2P Cloud Fusion

Oracle Fusion Cloud R13 Tables and Views – Procure to Pay table flow

Oracle Fusion Cloud R13 Inventory Table

SELECT * FROM EGP_SYSTEM_ITEMS_B  WHERE DESCRIPTION LIKE  ‘  ‘

Oracle Fusion Cloud R13 Interface  Table

SELECT * FROM  POR_REQ_DISTS_INTERFACE_ALL

Oracle Fusion Cloud R13 Requisition  Table

SELECT * FROM POR_REQUISITION_LINES_ALL

SELECT * POR_REQUISITION_HEADERS_ALL 

Oracle Fusion Cloud R13 Quotation  Table

SELECT * FROM HR_OPERATING_UNITS WHERE NAME LIKE 'VISION OPERATIONS'

SELECT * FROM PO_HEADERS_ALL WHERE FROM_HEADER_ID = '121306'  AND ORG_ID = '204'

SELECT * FROM PO_LINES_ALL WHERE PO_HEADER_ID = '121307'

SELECT * FROM PO_LINE_LOCATIONS_ALL WHERE PO_LINE_ID = '184236'

Oracle Fusion Cloud R13 Purchase Order (PO) Table

SELECT * FROM PO_HEADERS_ALL WHERE SEGMENT1 = '6042'  AND ORG_ID = '204'

SELECT * FROM PO_LINES_ALL WHERE PO_HEADER_ID = '121309'

SELECT * FROM PO_LINE_LOCATIONS_ALL WHERE PO_LINE_ID = '184238'

SELECT * FROM PO_DISTRIBUTIONS_ALL WHERE LINE_LOCATION_ID = '285384'

Receipt = 12229

Oracle Fusion Cloud R13 Receipt Table 

SELECT * FROM RCV_SHIPMENT_HEADERS WHERE RECEIPT_NUM ='12229' --AND SHIP_TO_ORG_ID = '204'

SELECT * FROM RCV_SHIPMENT_LINES WHERE SHIPMENT_HEADER_ID = '4812907'

SELECT * FROM RCV_TRANSACTIONS WHERE SHIPMENT_HEADER_ID = '4812907'

INVOICE NUM = VISIONIT\P2P INV 01   PAYMENT DOCUMENT NO=  1010

Oracle Fusion Cloud R13  Payable Invoice (AP) Table

SELECT * FROM AP_INVOICES_ALL WHERE INVOICE_NUM = 'VISIONIT\P2P INV 01'

SELECT * FROM AP_INVOICE_LINES_ALL WHERE INVOICE_ID = '227301'

SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL WHERE INVOICE_ID = '227301'

SELECT   ACCOUNTING_EVENT_ID   FROM AP_INVOICE_DISTRIBUTIONS_ALL WHERE INVOICE_ID = '227301'  --3336712

Oracle Fusion Cloud R13  XLA Accounting  Table

SELECT * FROM XLA_EVENTS  WHERE EVENT_ID = '3336712'

SELECT * FROM XLA_AE_HEADERS WHERE EVENT_ID = '3336712'

SELECT * FROM XLA_AE_LINES WHERE AE_HEADER_ID = '4958976'

Oracle Fusion Cloud R13  General Ledger (GL) Table

SELECT * FROM GL_INTERFACE WHERE REFERENCE26 = '3336712'

SELECT * FROM GL_IMPORT_REFERENCES WHERE REFERENCE_6 = '3336712'

SELECT * FROM GL_JE_BATCHES WHERE JE_BATCH_ID = '2943184'

SELECT * FROM GL_JE_HEADERS WHERE JE_BATCH_ID = '2943184'

SELECT * FROM GL_JE_LINES WHERE JE_HEADER_ID = '4695155'

SELECT * FROM GL_BALANCES WHERE LEDGER_ID = '1'

Oracle Fusion Cloud R13 Payables (AP) Table

SELECT * FROM AP_INVOICE_PAYMENTS_ALL WHERE INVOICE_ID = '227301'

SELECT ACCOUNTING_EVENT_ID  FROM AP_INVOICE_PAYMENTS_ALL WHERE INVOICE_ID = '227301'

SELECT CHECK_ID  FROM AP_INVOICE_PAYMENTS_ALL WHERE INVOICE_ID = '227301'

SELECT *  FROM AP_PAYMENT_SCHEDULES_ALL  WHERE INVOICE_ID = '227301'

SELECT * FROM AP_CHECKS_ALL WHERE CHECK_ID = '85530'

SELECT PAYMENT_ID FROM AP_CHECKS_ALL WHERE CHECK_ID = '85530'

SELECT * FROM IBY_PAYMENTS_ALL WHERE PAYMENT_ID = '26665'