P2P TABLES & LINKES

 select * from po_requisition_headers_all where segment1='14591'



 select * from po_requisition_lines_all where REQUISITION_HEADER_ID=182250



 select * from po_req_distributions_all where requisition_line_id=209478



 select * from gl_code_combinations where code_combination_id=13401



 select * from ap_suppliers where vendor_id=600



 select * from ap_supplier_sites_all where vendor_site_id=1414



 select * from po_headers_all where segment1='6296'



 select * from po_lines_all where po_header_id=111446



 select * from po_line_locations_all where po_line_id=174375





 select * from rcv_shipment_headers rsh,rcv_shipment_lines rsl

  where receipt_num='8596'

  and rsh.shipment_header_id = rsl.shipment_header_id

  and rsl.po_line_id = 174375



 select * from rcv_shipment_lines where shipment_header_id=4861907



 select * from rcv_transactions where shipment_header_id=4861907 and shipment_line_id=4853468





 select * from ap_invoices_all where invoice_num='ERS-8596-164853'



 select * from ap_invoice_lines_all where invoice_id=212520



 select * from ap_invoice_distributions_all



 select * from xla_ae_headers where entity_id=3270251



 select * from xla_ae_lines where ae_header_id=5003976



 select * from xla_events where entity_id=3270251



 select * from gl_je_headers where description='Journal Import 5812022:'and name='Mar-11 Purchase Invoices USD'



 select * from gl_je_lines where JE_HEADER_ID=4731155



 select * from gl_je_batches where JE_BATCH_ID=2978184