APPS.INV_VALIDATE dependencies on MTL_ITEM_SUB_VAL_V

Line 497: FROM MTL_ITEM_SUB_VAL_V

493: if p_item.restrict_subinventories_code = 1
494: then
495: SELECT 'VALID'
496: INTO l_dummy
497: FROM MTL_ITEM_SUB_VAL_V
498: WHERE ORGANIZATION_ID = p_org.organization_id
499: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
500: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
501: else

Line 864: FROM MTL_ITEM_SUB_VAL_V

860: if p_item.restrict_subinventories_code = 1
861: then
862: SELECT 'VALID'
863: INTO l_dummy
864: FROM MTL_ITEM_SUB_VAL_V
865: WHERE ORGANIZATION_ID = p_org.organization_id
866: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
867: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
868: else

Line 885: FROM MTL_ITEM_SUB_VAL_V

881: return T;
882: elsif p_from_sub.asset_inventory = 1 then
883: SELECT 'VALID'
884: INTO l_dummy
885: FROM MTL_ITEM_SUB_VAL_V
886: WHERE ORGANIZATION_ID = p_org.organization_id
887: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
888: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
889: else

Line 907: FROM MTL_ITEM_SUB_VAL_V

903: end if;
904: else
905: SELECT 'VALID'
906: INTO l_dummy
907: FROM MTL_ITEM_SUB_VAL_V
908: WHERE ORGANIZATION_ID = p_org.organization_id
909: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
910: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
911: end if;