DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_ITEM_SUB_INVENTORIES

Line 1776: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1772: RETURN 'Y';
1773: ELSE
1774: SELECT count(*)
1775: INTO l_temp
1776: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1777: WHERE a.organization_id = p_org_id
1778: AND b.inventory_item_id = p_inventory_item_id
1779: AND a.organization_id = b.organization_id
1780: AND a.secondary_inventory_name = b.secondary_inventory