APPS.INV_VALIDATE dependencies on MTL_SUBINVENTORIES_TRK_VAL_V

Line 463: FROM MTL_SUBINVENTORIES_TRK_VAL_V

459: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
460: else
461: SELECT 'VALID'
462: INTO l_dummy
463: FROM MTL_SUBINVENTORIES_TRK_VAL_V
464: WHERE ORGANIZATION_ID = p_org.organization_id
465: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
466: end if;
467: else

Line 479: FROM MTL_SUBINVENTORIES_TRK_VAL_V

475: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
476: else
477: SELECT 'VALID'
478: INTO l_dummy
479: FROM MTL_SUBINVENTORIES_TRK_VAL_V
480: WHERE ORGANIZATION_ID = p_org.organization_id
481: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
482: end if;
483: end if;

Line 498: FROM MTL_SUBINVENTORIES_TRK_VAL_V

494: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
495: else
496: SELECT 'VALID'
497: INTO l_dummy
498: FROM MTL_SUBINVENTORIES_TRK_VAL_V
499: WHERE ORGANIZATION_ID = p_org.organization_id
500: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
501: end if;
502: else

Line 514: FROM MTL_SUBINVENTORIES_TRK_VAL_V

510: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
511: else
512: SELECT 'VALID'
513: INTO l_dummy
514: FROM MTL_SUBINVENTORIES_TRK_VAL_V
515: WHERE ORGANIZATION_ID = p_org.organization_id
516: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
517: end if;
518: end if;