APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2164: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

2160: RETURN 'Y';
2161: ELSE
2162: SELECT count(*)
2163: INTO l_temp
2164: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
2165: WHERE a.organization_id = p_org_id
2166: AND b.inventory_item_id = p_inventory_item_id
2167: AND a.organization_id = b.organization_id
2168: AND a.secondary_inventory_name = b.secondary_inventory

Line 4255: FROM mtl_item_sub_inventories b

4251: sub_valid := TRUE ;
4252: ELSE
4253: SELECT count(*)
4254: INTO l_temp
4255: FROM mtl_item_sub_inventories b
4256: WHERE b.organization_id = p_org_id
4257: AND b.inventory_item_id = p_inventory_item_id
4258: AND b.secondary_inventory = p_sub_code;
4259: