(SELECT "A15"."RESOURCE_ID" "RESOURCE_ID","A14"."DEPARTMENT_ID" "DEPARTMENT_ID","A14"."ORGANIZATION_ID" "ORGANIZATION_ID","A14"."SR_INSTANCE_ID" "SR_INSTANCE_ID","A17"."DEMAND_CLASS" "DEMAND_CLASS","A15"."ALLOCATION_RULE_NAME" "ALLOCATION_RULE_NAME","A15"."ASSIGNMENT_TYPE" "ASSIGNMENT_TYPE","A17"."ALLOCATION_PERCENT" "ALLOCATION_PERCENT","A16"."EFFECTIVE_DATE" "EFFECTIVE_DATE","A16"."DISABLE_DATE" "DISABLE_DATE","A17"."PRIORITY" "PRIORITY","A17"."SERVICE_LEVEL" "SERVICE_LEVEL","A16"."TIME_PHASE_ID" "TIME_PHASE_ID","A17"."CLASS" "CLASS","A17"."PARTNER_ID" "PARTNER_ID","A17"."PARTNER_SITE_ID" "PARTNER_SITE_ID","A17"."LEVEL_ID" "LEVEL_ID","A17"."LEVEL_ALLOC_PERCENT" "LEVEL_ALLOC_PERCENT","A17"."LEVEL_PRIORITY" "LEVEL_PRIORITY","A17"."MIN_LEVEL_ALLOC_PERCENT" "MIN_LEVEL_ALLOC_PERCENT","A17"."MIN_ALLOCATION_PERCENT" "MIN_ALLOCATION_PERCENT" FROM "MSC"."MSC_ALLOCATIONS" "A17","MSC"."MSC_ALLOC_RULE_TIME_PHASES" "A16","MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A15","MSC"."MSC_DEPARTMENT_RESOURCES" "A14" WHERE "A15"."ASSIGNMENT_TYPE"=4 AND "A15"."ALLOCATION_RULE_NAME"="A16"."ALLOCATION_RULE_NAME" AND "A16"."TIME_PHASE_ID"="A17"."TIME_PHASE_ID" AND "A15"."RESOURCE_ID"="A14"."RESOURCE_ID" AND "A15"."DEPARTMENT_ID"="A14"."DEPARTMENT_ID" AND "A15"."ORGANIZATION_ID"="A14"."ORGANIZATION_ID" AND "A15"."SR_INSTANCE_ID"="A14"."SR_INSTANCE_ID" AND "A15"."RESOURCE_GROUP" IS NULL AND "A14"."PLAN_ID"=(-1)) UNION ALL (SELECT "A10"."RESOURCE_ID" "RESOURCE_ID","A10"."DEPARTMENT_ID" "DEPARTMENT_ID","A10"."ORGANIZATION_ID" "ORGANIZATION_ID","A10"."SR_INSTANCE_ID" "SR_INSTANCE_ID","A13"."DEMAND_CLASS" "DEMAND_CLASS","A11"."ALLOCATION_RULE_NAME" "ALLOCATION_RULE_NAME","A11"."ASSIGNMENT_TYPE" "ASSIGNMENT_TYPE","A13"."ALLOCATION_PERCENT" "ALLOCATION_PERCENT","A12"."EFFECTIVE_DATE" "EFFECTIVE_DATE","A12"."DISABLE_DATE" "DISABLE_DATE","A13"."PRIORITY" "PRIORITY","A13"."SERVICE_LEVEL" "SERVICE_LEVEL","A12"."TIME_PHASE_ID" "TIME_PHASE_ID","A13"."CLASS" "CLASS","A13"."PARTNER_ID" "PARTNER_ID","A13"."PARTNER_SITE_ID" "PARTNER_SITE_ID","A13"."LEVEL_ID" "LEVEL_ID","A13"."LEVEL_ALLOC_PERCENT" "LEVEL_ALLOC_PERCENT","A13"."LEVEL_PRIORITY" "LEVEL_PRIORITY","A13"."MIN_LEVEL_ALLOC_PERCENT" "MIN_LEVEL_ALLOC_PERCENT","A13"."MIN_ALLOCATION_PERCENT" "MIN_ALLOCATION_PERCENT" FROM "MSC"."MSC_ALLOCATIONS" "A13","MSC"."MSC_ALLOC_RULE_TIME_PHASES" "A12","MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A11","MSC"."MSC_DEPARTMENT_RESOURCES" "A10" WHERE "A11"."ASSIGNMENT_TYPE"=5 AND "A11"."SR_INSTANCE_ID"="A10"."SR_INSTANCE_ID" AND "A11"."RESOURCE_GROUP"="A10"."RESOURCE_GROUP_NAME" AND "A11"."ALLOCATION_RULE_NAME"="A12"."ALLOCATION_RULE_NAME" AND "A12"."TIME_PHASE_ID"="A13"."TIME_PHASE_ID" AND "A10"."PLAN_ID"=(-1) AND "A11"."RESOURCE_GROUP" IS NOT NULL AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A18" WHERE "A18"."RESOURCE_ID"="A10"."RESOURCE_ID" AND "A18"."ORGANIZATION_ID"="A10"."ORGANIZATION_ID" AND "A18"."SR_INSTANCE_ID"="A10"."SR_INSTANCE_ID" AND "A18"."DEPARTMENT_ID"="A10"."DEPARTMENT_ID" AND "A18"."ASSIGNMENT_TYPE"=4)) UNION ALL (SELECT "A6"."RESOURCE_ID" "RESOURCE_ID","A6"."DEPARTMENT_ID" "DEPARTMENT_ID","A6"."ORGANIZATION_ID" "ORGANIZATION_ID","A6"."SR_INSTANCE_ID" "SR_INSTANCE_ID","A9"."DEMAND_CLASS" "DEMAND_CLASS","A7"."ALLOCATION_RULE_NAME" "ALLOCATION_RULE_NAME","A7"."ASSIGNMENT_TYPE" "ASSIGNMENT_TYPE","A9"."ALLOCATION_PERCENT" "ALLOCATION_PERCENT","A8"."EFFECTIVE_DATE" "EFFECTIVE_DATE","A8"."DISABLE_DATE" "DISABLE_DATE","A9"."PRIORITY" "PRIORITY","A9"."SERVICE_LEVEL" "SERVICE_LEVEL","A8"."TIME_PHASE_ID" "TIME_PHASE_ID","A9"."CLASS" "CLASS","A9"."PARTNER_ID" "PARTNER_ID","A9"."PARTNER_SITE_ID" "PARTNER_SITE_ID","A9"."LEVEL_ID" "LEVEL_ID","A9"."LEVEL_ALLOC_PERCENT" "LEVEL_ALLOC_PERCENT","A9"."LEVEL_PRIORITY" "LEVEL_PRIORITY","A9"."MIN_LEVEL_ALLOC_PERCENT" "MIN_LEVEL_ALLOC_PERCENT","A9"."MIN_ALLOCATION_PERCENT" "MIN_ALLOCATION_PERCENT" FROM "MSC"."MSC_ALLOCATIONS" "A9","MSC"."MSC_ALLOC_RULE_TIME_PHASES" "A8","MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A7","MSC"."MSC_DEPARTMENT_RESOURCES" "A6" WHERE "A7"."ASSIGNMENT_TYPE"=6 AND "A7"."SR_INSTANCE_ID"="A6"."SR_INSTANCE_ID" AND "A7"."ORGANIZATION_ID"="A6"."ORGANIZATION_ID" AND "A7"."ALLOCATION_RULE_NAME"="A8"."ALLOCATION_RULE_NAME" AND "A8"."TIME_PHASE_ID"="A9"."TIME_PHASE_ID" AND "A6"."PLAN_ID"=(-1) AND "A7"."RESOURCE_GROUP" IS NULL AND "A7"."RESOURCE_ID" IS NULL AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A20" WHERE "A20"."RESOURCE_ID"="A6"."RESOURCE_ID" AND "A20"."ORGANIZATION_ID"="A6"."ORGANIZATION_ID" AND "A20"."SR_INSTANCE_ID"="A6"."SR_INSTANCE_ID" AND "A20"."DEPARTMENT_ID"="A6"."DEPARTMENT_ID" AND "A20"."ASSIGNMENT_TYPE"=4) AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A19" WHERE "A19"."RESOURCE_GROUP"="A6"."RESOURCE_GROUP_NAME" AND "A19"."SR_INSTANCE_ID"="A6"."SR_INSTANCE_ID" AND "A19"."ASSIGNMENT_TYPE"=5)) UNION ALL (SELECT "A4"."RESOURCE_ID" "RESOURCE_ID","A4"."DEPARTMENT_ID" "DEPARTMENT_ID","A4"."ORGANIZATION_ID" "ORGANIZATION_ID","A4"."SR_INSTANCE_ID" "SR_INSTANCE_ID","A5"."DEMAND_CLASS" "DEMAND_CLASS","A2"."ALLOCATION_RULE_NAME" "ALLOCATION_RULE_NAME","A2"."ASSIGNMENT_TYPE" "ASSIGNMENT_TYPE","A5"."ALLOCATION_PERCENT" "ALLOCATION_PERCENT","A3"."EFFECTIVE_DATE" "EFFECTIVE_DATE","A3"."DISABLE_DATE" "DISABLE_DATE","A5"."PRIORITY" "PRIORITY","A5"."SERVICE_LEVEL" "SERVICE_LEVEL","A3"."TIME_PHASE_ID" "TIME_PHASE_ID","A5"."CLASS" "CLASS","A5"."PARTNER_ID" "PARTNER_ID","A5"."PARTNER_SITE_ID" "PARTNER_SITE_ID","A5"."LEVEL_ID" "LEVEL_ID","A5"."LEVEL_ALLOC_PERCENT" "LEVEL_ALLOC_PERCENT","A5"."LEVEL_PRIORITY" "LEVEL_PRIORITY","A5"."MIN_LEVEL_ALLOC_PERCENT" "MIN_LEVEL_ALLOC_PERCENT","A5"."MIN_ALLOCATION_PERCENT" "MIN_ALLOCATION_PERCENT" FROM "MSC"."MSC_ALLOCATIONS" "A5","MSC"."MSC_DEPARTMENT_RESOURCES" "A4","MSC"."MSC_ALLOC_RULE_TIME_PHASES" "A3","MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A2" WHERE "A2"."ASSIGNMENT_TYPE"=1 AND "A2"."ALLOCATION_RULE_NAME"="A3"."ALLOCATION_RULE_NAME" AND "A3"."TIME_PHASE_ID"="A5"."TIME_PHASE_ID" AND "A4"."PLAN_ID"=(-1) AND "A2"."RESOURCE_ID" IS NULL AND "A2"."RESOURCE_GROUP" IS NULL AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A23" WHERE "A23"."RESOURCE_ID"="A4"."RESOURCE_ID" AND "A23"."DEPARTMENT_ID"="A4"."DEPARTMENT_ID" AND "A23"."ORGANIZATION_ID"="A4"."ORGANIZATION_ID" AND "A23"."SR_INSTANCE_ID"="A4"."SR_INSTANCE_ID" AND "A23"."ASSIGNMENT_TYPE"=4) AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A22" WHERE "A22"."RESOURCE_GROUP"="A4"."RESOURCE_GROUP_NAME" AND "A22"."SR_INSTANCE_ID"="A4"."SR_INSTANCE_ID" AND "A22"."ASSIGNMENT_TYPE"=5) AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A21" WHERE "A21"."ORGANIZATION_ID"="A4"."ORGANIZATION_ID" AND "A21"."SR_INSTANCE_ID"="A4"."SR_INSTANCE_ID" AND "A21"."ASSIGNMENT_TYPE"=6))
[Home] [Help]