DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on MTL_SECONDARY_INVENTORIES

Line 1621: FROM mtl_secondary_inventories msub,

1617: from mtl_reservations mr
1618: where mr.supply_source_type_id = 18 --todo, need to check source type id
1619: and mr.supply_source_header_id = ms.shipment_header_id
1620: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty
1621: FROM mtl_secondary_inventories msub,
1622: mtl_supply ms
1623: WHERE ms.item_id = p_inv_item_id
1624: AND ms.to_organization_id = p_org_id
1625: AND ms.supply_type_code = 'RECEIVING'