DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on MTL_SECONDARY_INVENTORIES

Line 1692: FROM mtl_secondary_inventories msub,

1688: from mtl_reservations mr
1689: where mr.supply_source_type_id = 18 --todo, need to check source type id
1690: and mr.supply_source_header_id = ms.shipment_header_id
1691: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty
1692: FROM mtl_secondary_inventories msub,
1693: mtl_supply ms
1694: WHERE ms.item_id = p_inv_item_id
1695: AND ms.to_organization_id = p_org_id
1696: AND ms.supply_type_code = 'RECEIVING'