DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on MTL_SUPPLY

Line 1950: FROM mtl_supply ms

1946: WHERE rsh.shipment_num IS NOT NULL
1947: AND rsh.shipment_header_id = rsl.shipment_header_id
1948: AND rsh.receipt_source_code = 'INVENTORY'
1949: AND EXISTS (SELECT 'Available Supply'
1950: FROM mtl_supply ms
1951: WHERE ms.to_organization_id = l_organization_id
1952: AND ms.shipment_header_id = rsh.shipment_header_id)
1953: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED')
1954: AND rsl.to_organization_id = l_organization_id