DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 651: rcv_shipment_headers rsh,

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
654: rsh.receipt_num=substr(aia.invoice_num,instr(aia.invoice_num,'/',1,1)+1,instr(aia.invoice_num,'/',1,2)-instr(aia.invoice_num,'/',1,1)-1) AND
655: rsh.shipment_header_id=rt.shipment_header_id AND

Line 1479: , rcv_shipment_headers rsh

1475: ,rsh.vendor_id party_id
1476: ,hl.inventory_organization_id organization_id
1477: ,rsl.ship_to_location_id location_id
1478: from rcv_transactions rta
1479: , rcv_shipment_headers rsh
1480: , rcv_shipment_lines rsl
1481: , po_lines_all pla
1482: , mtl_system_items msi
1483: , po_vendors pov