APPS.INV_VALIDATE dependencies on MTL_ITEM_SUB_TRK_VAL_V

Line 462: FROM MTL_ITEM_SUB_TRK_VAL_V

458: if p_item.restrict_subinventories_code = 1
459: then
460: SELECT 'VALID'
461: INTO l_dummy
462: FROM MTL_ITEM_SUB_TRK_VAL_V
463: WHERE ORGANIZATION_ID = p_org.organization_id
464: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
465: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
466: else

Line 478: FROM MTL_ITEM_SUB_TRK_VAL_V

474: if p_item.restrict_subinventories_code = 1
475: then
476: SELECT 'VALID'
477: INTO l_dummy
478: FROM MTL_ITEM_SUB_TRK_VAL_V
479: WHERE ORGANIZATION_ID = p_org.organization_id
480: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
481: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
482: else

Line 513: FROM MTL_ITEM_SUB_TRK_VAL_V

509: if p_item.restrict_subinventories_code = 1
510: then
511: SELECT 'VALID'
512: INTO l_dummy
513: FROM MTL_ITEM_SUB_TRK_VAL_V
514: WHERE ORGANIZATION_ID = p_org.organization_id
515: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
516: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
517: else