APPS.INV_VALIDATE dependencies on MTL_ITEM_SUB_TRK_VAL_V

Line 456: FROM MTL_ITEM_SUB_TRK_VAL_V

452: if p_item.restrict_subinventories_code = 1
453: then
454: SELECT 'VALID'
455: INTO l_dummy
456: FROM MTL_ITEM_SUB_TRK_VAL_V
457: WHERE ORGANIZATION_ID = p_org.organization_id
458: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
459: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
460: else

Line 472: FROM MTL_ITEM_SUB_TRK_VAL_V

468: if p_item.restrict_subinventories_code = 1
469: then
470: SELECT 'VALID'
471: INTO l_dummy
472: FROM MTL_ITEM_SUB_TRK_VAL_V
473: WHERE ORGANIZATION_ID = p_org.organization_id
474: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
475: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
476: else

Line 507: FROM MTL_ITEM_SUB_TRK_VAL_V

503: if p_item.restrict_subinventories_code = 1
504: then
505: SELECT 'VALID'
506: INTO l_dummy
507: FROM MTL_ITEM_SUB_TRK_VAL_V
508: WHERE ORGANIZATION_ID = p_org.organization_id
509: AND INVENTORY_ITEM_ID = p_item.inventory_item_id
510: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
511: else