Oracle Apps EBS R12

Oracle Apps EBS R12 Procure to Pay (P2P) cycle with Table Flow

Oracle Apps EBS R12 Inventory Table

select * from mtl_system_items_b where segment1 like 'VisionIT%'



Oracle Apps EBS R12 Interface Table

select * from po_requisitions_interface_all where item_id = '220955'


Oracle Apps EBS R12 Requisition Table

select * from po_requisition_lines_all where item_id = '220955'

select * from po_requisition_headers_all where REQUISITION_HEADER_ID = '195178'

/* Req No =  14340 */

select * from po_req_distributions_all where REQUISITION_LINE_ID = '221409'

RFQ = 306

Quotation = 500 n 501


Oracle Apps EBS R12 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'





PO Number = 6042



Oracle Apps EBS R12 Purchase Order (PO) Tables



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 Apps EBS R12 Receipt Table



select * from org_organization_definitions   where organization_name  like 'Vision Operations'



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 Apps EBS R12 Payable (AP) Invoice 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 Apps EBS R12 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 Apps EBS R12 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'



Mr. Sandeep M Shinde www.eTutorInfotech.com
eTutorInfotech@gmail.com 8308800428/9930975472

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 Apps EBS R12 (AP)Payables 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'