DBA Data[Home] [Help]

APPS.INVIDIT3 dependencies on RCV_SHIPMENT_HEADERS

Line 835: from rcv_shipment_headers rsh, rcv_shipment_lines rsl

831: IF (X_open_shipment_lot IS NOT NULL or X_open_shipment_serial IS NOT NULL ) THEN
832:
833: select count(1)
834: into open_shipment_org_count
835: from rcv_shipment_headers rsh, rcv_shipment_lines rsl
836: where rsh.shipment_header_id = rsl.shipment_header_id
837: and rsh.receipt_source_code IN ('INTERNAL ORDER', 'INVENTORY')
838: and exists (select 1
839: from mtl_supply ms

Line 851: from rcv_shipment_headers rsh, rcv_shipment_lines rsl

847:
848: if (open_shipment_org_count <> 1) then
849: select count(1)
850: into open_shipment_master_count
851: from rcv_shipment_headers rsh, rcv_shipment_lines rsl
852: where rsh.shipment_header_id = rsl.shipment_header_id
853: and rsh.receipt_source_code IN ('INTERNAL ORDER', 'INVENTORY')
854: and exists (select 1
855: from mtl_supply ms