DBA Data[Home] [Help]

APPS.WMS_XDOCK_PEGGING_PUB dependencies on MTL_SUPPLY

Line 1975: FROM mtl_supply ms

1971: WHERE rsh.shipment_num IS NOT NULL
1972: AND rsh.shipment_header_id = rsl.shipment_header_id
1973: AND rsh.receipt_source_code = 'INVENTORY'
1974: AND EXISTS (SELECT 'Available Supply'
1975: FROM mtl_supply ms
1976: WHERE ms.to_organization_id = l_organization_id
1977: AND ms.shipment_header_id = rsh.shipment_header_id)
1978: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED')
1979: AND rsl.to_organization_id = l_organization_id