DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on PO_HEADERS_ALL

Line 649: po_headers_all pha,

645: substr(aia.invoice_num,instr(aia.invoice_num,'/',1,1)+1,instr(aia.invoice_num,'/',1,2)-instr(aia.invoice_num,'/',1,1)-1) rcp_no,
646: pha.segment1 po_num,
647: aia.invoice_date
648: from
649: po_headers_all pha,
650: rcv_transactions rt,
651: rcv_shipment_headers rsh,
652: ap_invoices_all aia
653: where

Line 1439: from po_headers_all poh

1435: ,poh.vendor_id party_id
1436: -- ,fsp.inventory_organization_id organization_id /* Commented by vkantamn for Bug#6083978 */
1437: ,hl.inventory_organization_id organization_id /* Added by vkantamn for Bug#6083978 */
1438: ,poll.ship_to_location_id location_id
1439: from po_headers_all poh
1440: , po_lines_all pol
1441: , po_line_locations_all poll /*6841116*/
1442: , mtl_system_items msi
1443: , po_vendors pov