DBA Data[Home] [Help]

APPS.RCV_ROI_HEADER dependencies on PO_HEADERS_ALL

Line 1904: * po_headers_all table

1900: -- transaction processor will not look at it.
1901:
1902: /*
1903: * Populate the org_id column in rcv_transactions_interface with org_id from
1904: * po_headers_all table
1905: */
1906:
1907: INSERT INTO rcv_transactions_interface
1908: (interface_transaction_id,

Line 1977: po_headers_all poh

1973: rsl.destination_type_code,
1974: p_header_record.header_record.processing_request_id,
1975: poh.org_id
1976: FROM rcv_shipment_lines rsl,
1977: po_headers_all poh
1978: WHERE rsl.shipment_header_id = p_header_record.header_record.receipt_header_id
1979: AND rsl.shipment_line_status_code <> 'CANCELLED'
1980: AND rsl.po_header_id = poh.po_header_id
1981: AND NOT EXISTS(SELECT 'x'