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 639: FROM rcv_headers_interface rhi, rcv_shipment_headers rsh

635: , rhi.receipt_source_code
636: , rhi.asn_type rhi_asn_type
637: , rsh.asn_type rsh_asn_type
638: , rhi.creation_date
639: FROM rcv_headers_interface rhi, rcv_shipment_headers rsh
640: WHERE rhi.header_interface_id = p_header_interface_id
641: AND rsh.shipment_header_id = rhi.receipt_header_id
642: AND rhi.processing_status_code IN('RUNNING', 'PENDING')
643: AND rhi.receipt_source_code in ('VENDOR','CUSTOMER')

Line 659: FROM rcv_shipment_headers rsh

655: FROM rcv_shipment_lines rsl, rcv_transactions_interface rti
656: WHERE rti.interface_transaction_id = p_interface_transaction_id
657: AND rti.shipment_line_id = rsl.shipment_line_id
658: AND NOT EXISTS(SELECT 1
659: FROM rcv_shipment_headers rsh
660: WHERE rsh.shipment_header_id = rsl.shipment_header_id);
661:
662: --As per Maneesh's suggestion, commenting this check from DCP
663: /* CURSOR c3 IS

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

668: , rti.item_id
669: , rti.to_organization_id
670: , rti.from_organization_id
671: , rti.transaction_type
672: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl, rcv_transactions_interface rti
673: WHERE rti.interface_transaction_id = p_interface_transaction_id
674: AND rti.shipment_line_id = rsl.shipment_line_id
675: AND rsh.shipment_header_id = rsl.shipment_header_id
676: AND rsh.receipt_source_code IN('INTERNAL ORDER', 'INVENTORY')