DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on PO_HEADERS_ALL

Line 235: po_headers_all pha,

231: 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,
232: pha.segment1 po_num,
233: aia.invoice_date
234: from
235: po_headers_all pha,
236: rcv_transactions rt,
237: rcv_shipment_headers rsh,
238: ap_invoices_all aia
239: where

Line 783: from po_headers_all poh

779: ,poh.vendor_id party_id
780: -- ,fsp.inventory_organization_id organization_id /* Commented by vkantamn for Bug#6083978 */
781: ,hl.inventory_organization_id organization_id /* Added by vkantamn for Bug#6083978 */
782: ,poll.ship_to_location_id location_id
783: from po_headers_all poh
784: , po_lines_all pol
785: , po_line_locations_all poll /*6843479*/
786: , mtl_system_items msi
787: , po_vendors pov