APPS.INV_VALIDATE dependencies on MTL_ITEM_SUB_VAL_V

Line 491: FROM MTL_ITEM_SUB_VAL_V

487: if p_item.restrict_subinventories_code = 1
488: then
489: SELECT 'VALID'
490: INTO l_dummy
491: FROM MTL_ITEM_SUB_VAL_V
492: WHERE ORGANIZATION_ID = p_org.organization_id
493: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
494: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
495: else

Line 858: FROM MTL_ITEM_SUB_VAL_V

854: if p_item.restrict_subinventories_code = 1
855: then
856: SELECT 'VALID'
857: INTO l_dummy
858: FROM MTL_ITEM_SUB_VAL_V
859: WHERE ORGANIZATION_ID = p_org.organization_id
860: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
861: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
862: else

Line 879: FROM MTL_ITEM_SUB_VAL_V

875: return T;
876: elsif p_from_sub.asset_inventory = 1 then
877: SELECT 'VALID'
878: INTO l_dummy
879: FROM MTL_ITEM_SUB_VAL_V
880: WHERE ORGANIZATION_ID = p_org.organization_id
881: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
882: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
883: else

Line 901: FROM MTL_ITEM_SUB_VAL_V

897: end if;
898: else
899: SELECT 'VALID'
900: INTO l_dummy
901: FROM MTL_ITEM_SUB_VAL_V
902: WHERE ORGANIZATION_ID = p_org.organization_id
903: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
904: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
905: end if;