eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_DCP_PVT dependencies on RCV_SHIPMENT_HEADERS

Line 667: FROM rcv_headers_interface rhi, rcv_shipment_headers rsh

663: , rhi.receipt_source_code
664: , rhi.asn_type rhi_asn_type
665: , rsh.asn_type rsh_asn_type
666: , rhi.creation_date
667: FROM rcv_headers_interface rhi, rcv_shipment_headers rsh
668: WHERE rhi.header_interface_id = p_header_interface_id
669: AND rsh.shipment_header_id = rhi.receipt_header_id
670: AND rhi.processing_status_code IN('RUNNING', 'PENDING')
671: AND rhi.receipt_source_code in ('VENDOR','CUSTOMER')

Line 687: FROM rcv_shipment_headers rsh

683: FROM rcv_shipment_lines rsl, rcv_transactions_interface rti
684: WHERE rti.interface_transaction_id = p_interface_transaction_id
685: AND rti.shipment_line_id = rsl.shipment_line_id
686: AND NOT EXISTS(SELECT 1
687: FROM rcv_shipment_headers rsh
688: WHERE rsh.shipment_header_id = rsl.shipment_header_id);
689:
690: --As per Maneesh's suggestion, commenting this check from DCP
691: /* CURSOR c3 IS

Line 700: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl, rcv_transactions_interface rti

696: , rti.item_id
697: , rti.to_organization_id
698: , rti.from_organization_id
699: , rti.transaction_type
700: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl, rcv_transactions_interface rti
701: WHERE rti.interface_transaction_id = p_interface_transaction_id
702: AND rti.shipment_line_id = rsl.shipment_line_id
703: AND rsh.shipment_header_id = rsl.shipment_header_id
704: AND rsh.receipt_source_code IN('INTERNAL ORDER', 'INVENTORY')