APPS.INV_VALIDATE dependencies on MTL_SUBINVENTORIES_VAL_V

Line 865: FROM MTL_SUBINVENTORIES_VAL_V

861: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
862: else
863: SELECT 'VALID'
864: INTO l_dummy
865: FROM MTL_SUBINVENTORIES_VAL_V
866: WHERE ORGANIZATION_ID = p_org.organization_id
867: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
868: end if;
869: end if;

Line 913: FROM MTL_SUBINVENTORIES_VAL_V

909: return T;
910: elsif p_from_sub.asset_inventory = 1 then
911: SELECT 'VALID'
912: INTO l_dummy
913: FROM MTL_SUBINVENTORIES_VAL_V
914: WHERE ORGANIZATION_ID = p_org.organization_id
915: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
916: else
917: BEGIN

Line 933: FROM MTL_SUBINVENTORIES_VAL_V

929: end if;
930: else
931: SELECT 'VALID'
932: INTO l_dummy
933: FROM MTL_SUBINVENTORIES_VAL_V
934: WHERE ORGANIZATION_ID = p_org.organization_id
935: AND SECONDARY_INVENTORY_NAME = p_sub.secondary_inventory_name;
936: end if;
937: end if;