APPS.INV_VALIDATE dependencies on MTL_SUBINVENTORIES_VAL_V

Line 871: FROM MTL_SUBINVENTORIES_VAL_V

867: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
868: else
869: SELECT 'VALID'
870: INTO l_dummy
871: FROM MTL_SUBINVENTORIES_VAL_V
872: WHERE ORGANIZATION_ID = p_org.organization_id
873: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
874: end if;
875: end if;

Line 919: FROM MTL_SUBINVENTORIES_VAL_V

915: return T;
916: elsif p_from_sub.asset_inventory = 1 then
917: SELECT 'VALID'
918: INTO l_dummy
919: FROM MTL_SUBINVENTORIES_VAL_V
920: WHERE ORGANIZATION_ID = p_org.organization_id
921: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
922: else
923: BEGIN

Line 939: FROM MTL_SUBINVENTORIES_VAL_V

935: end if;
936: else
937: SELECT 'VALID'
938: INTO l_dummy
939: FROM MTL_SUBINVENTORIES_VAL_V
940: WHERE ORGANIZATION_ID = p_org.organization_id
941: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
942: end if;
943: end if;