DBA Data[Home] [Help]

APPS.INV_RCV_COMMON_APIS dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2936: FROM mtl_item_sub_inventories mis

2932: INTO l_dummy
2933: FROM DUAL
2934: WHERE EXISTS(
2935: SELECT 1
2936: FROM mtl_item_sub_inventories mis
2937: WHERE mis.organization_id = p_organization_id
2938: AND mis.inventory_item_id = p_item_id
2939: AND mis.secondary_inventory = l_sub
2940: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, l_transaction_type, NULL, NULL, p_organization_id