APPS.INV_VALIDATE dependencies on MTL_SUBINVENTORIES_TRK_VAL_V

Line 469: FROM MTL_SUBINVENTORIES_TRK_VAL_V

465: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
466: else
467: SELECT 'VALID'
468: INTO l_dummy
469: FROM MTL_SUBINVENTORIES_TRK_VAL_V
470: WHERE ORGANIZATION_ID = p_org.organization_id
471: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
472: end if;
473: else

Line 485: FROM MTL_SUBINVENTORIES_TRK_VAL_V

481: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
482: else
483: SELECT 'VALID'
484: INTO l_dummy
485: FROM MTL_SUBINVENTORIES_TRK_VAL_V
486: WHERE ORGANIZATION_ID = p_org.organization_id
487: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
488: end if;
489: end if;

Line 504: FROM MTL_SUBINVENTORIES_TRK_VAL_V

500: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
501: else
502: SELECT 'VALID'
503: INTO l_dummy
504: FROM MTL_SUBINVENTORIES_TRK_VAL_V
505: WHERE ORGANIZATION_ID = p_org.organization_id
506: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
507: end if;
508: else

Line 520: FROM MTL_SUBINVENTORIES_TRK_VAL_V

516: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
517: else
518: SELECT 'VALID'
519: INTO l_dummy
520: FROM MTL_SUBINVENTORIES_TRK_VAL_V
521: WHERE ORGANIZATION_ID = p_org.organization_id
522: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
523: end if;
524: end if;