DBA Data[Home] [Help]

APPS.RCV_ROI_HEADER dependencies on PO_HEADERS_ALL

Line 1878: * po_headers_all table

1874: -- transaction processor will not look at it.
1875:
1876: /*
1877: * Populate the org_id column in rcv_transactions_interface with org_id from
1878: * po_headers_all table
1879: */
1880:
1881: INSERT INTO rcv_transactions_interface
1882: (interface_transaction_id,

Line 1951: po_headers_all poh

1947: rsl.destination_type_code,
1948: p_header_record.header_record.processing_request_id,
1949: poh.org_id
1950: FROM rcv_shipment_lines rsl,
1951: po_headers_all poh
1952: WHERE rsl.shipment_header_id = p_header_record.header_record.receipt_header_id
1953: AND rsl.shipment_line_status_code <> 'CANCELLED'
1954: AND rsl.po_header_id = poh.po_header_id
1955: AND NOT EXISTS(SELECT 'x'