(SELECT "A20"."INVENTORY_ITEM_ID" "INVENTORY_ITEM_ID","A20"."ORGANIZATION_ID" "ORGANIZATION_ID","A20"."SR_INSTANCE_ID" "SR_INSTANCE_ID","A22"."DEMAND_CLASS" "DEMAND_CLASS","A19"."ALLOCATION_RULE_NAME" "ALLOCATION_RULE_NAME","A19"."ASSIGNMENT_TYPE" "ASSIGNMENT_TYPE","A22"."ALLOCATION_PERCENT" "ALLOCATION_PERCENT","A21"."EFFECTIVE_DATE" "EFFECTIVE_DATE","A21"."DISABLE_DATE" "DISABLE_DATE","A22"."PRIORITY" "PRIORITY","A22"."SERVICE_LEVEL" "SERVICE_LEVEL","A21"."TIME_PHASE_ID" "TIME_PHASE_ID","A22"."CLASS" "CLASS","A22"."PARTNER_ID" "PARTNER_ID","A22"."PARTNER_SITE_ID" "PARTNER_SITE_ID","A22"."LEVEL_ID" "LEVEL_ID","A22"."LEVEL_ALLOC_PERCENT" "LEVEL_ALLOC_PERCENT","A22"."LEVEL_PRIORITY" "LEVEL_PRIORITY","A22"."MIN_LEVEL_ALLOC_PERCENT" "MIN_LEVEL_ALLOC_PERCENT","A22"."MIN_ALLOCATION_PERCENT" "MIN_ALLOCATION_PERCENT" FROM "MSC"."MSC_ALLOCATIONS" "A22","MSC"."MSC_ALLOC_RULE_TIME_PHASES" "A21","MSC"."MSC_SYSTEM_ITEMS" "A20","MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A19" WHERE "A19"."ASSIGNMENT_TYPE"=7 AND "A19"."INVENTORY_ITEM_ID"="A20"."INVENTORY_ITEM_ID" AND "A19"."ORGANIZATION_ID"="A20"."ORGANIZATION_ID" AND "A19"."SR_INSTANCE_ID"="A20"."SR_INSTANCE_ID" AND "A19"."ALLOCATION_RULE_NAME"="A21"."ALLOCATION_RULE_NAME" AND "A21"."TIME_PHASE_ID"="A22"."TIME_PHASE_ID" AND "A20"."PLAN_ID"=(-1)) UNION ALL (SELECT "A16"."INVENTORY_ITEM_ID" "INVENTORY_ITEM_ID","A16"."ORGANIZATION_ID" "ORGANIZATION_ID","A16"."SR_INSTANCE_ID" "SR_INSTANCE_ID","A18"."DEMAND_CLASS" "DEMAND_CLASS","A15"."ALLOCATION_RULE_NAME" "ALLOCATION_RULE_NAME","A15"."ASSIGNMENT_TYPE" "ASSIGNMENT_TYPE","A18"."ALLOCATION_PERCENT" "ALLOCATION_PERCENT","A17"."EFFECTIVE_DATE" "EFFECTIVE_DATE","A17"."DISABLE_DATE" "DISABLE_DATE","A18"."PRIORITY" "PRIORITY","A18"."SERVICE_LEVEL" "SERVICE_LEVEL","A17"."TIME_PHASE_ID" "TIME_PHASE_ID","A18"."CLASS" "CLASS","A18"."PARTNER_ID" "PARTNER_ID","A18"."PARTNER_SITE_ID" "PARTNER_SITE_ID","A18"."LEVEL_ID" "LEVEL_ID","A18"."LEVEL_ALLOC_PERCENT" "LEVEL_ALLOC_PERCENT","A18"."LEVEL_PRIORITY" "LEVEL_PRIORITY","A18"."MIN_LEVEL_ALLOC_PERCENT" "MIN_LEVEL_ALLOC_PERCENT","A18"."MIN_ALLOCATION_PERCENT" "MIN_ALLOCATION_PERCENT" FROM "MSC"."MSC_ALLOCATIONS" "A18","MSC"."MSC_ALLOC_RULE_TIME_PHASES" "A17","MSC"."MSC_SYSTEM_ITEMS" "A16","MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A15" WHERE "A15"."ASSIGNMENT_TYPE"=3 AND "A15"."INVENTORY_ITEM_ID"="A16"."INVENTORY_ITEM_ID" AND "A15"."ALLOCATION_RULE_NAME"="A17"."ALLOCATION_RULE_NAME" AND "A17"."TIME_PHASE_ID"="A18"."TIME_PHASE_ID" AND "A16"."PLAN_ID"=(-1) AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A23" WHERE "A23"."INVENTORY_ITEM_ID"="A16"."INVENTORY_ITEM_ID" AND "A23"."ORGANIZATION_ID"="A16"."ORGANIZATION_ID" AND "A23"."SR_INSTANCE_ID"="A16"."SR_INSTANCE_ID" AND "A23"."ASSIGNMENT_TYPE"=7)) UNION ALL (SELECT "A11"."INVENTORY_ITEM_ID" "INVENTORY_ITEM_ID","A11"."ORGANIZATION_ID" "ORGANIZATION_ID","A11"."SR_INSTANCE_ID" "SR_INSTANCE_ID","A14"."DEMAND_CLASS" "DEMAND_CLASS","A12"."ALLOCATION_RULE_NAME" "ALLOCATION_RULE_NAME","A12"."ASSIGNMENT_TYPE" "ASSIGNMENT_TYPE","A14"."ALLOCATION_PERCENT" "ALLOCATION_PERCENT","A13"."EFFECTIVE_DATE" "EFFECTIVE_DATE","A13"."DISABLE_DATE" "DISABLE_DATE","A14"."PRIORITY" "PRIORITY","A14"."SERVICE_LEVEL" "SERVICE_LEVEL","A13"."TIME_PHASE_ID" "TIME_PHASE_ID","A14"."CLASS" "CLASS","A14"."PARTNER_ID" "PARTNER_ID","A14"."PARTNER_SITE_ID" "PARTNER_SITE_ID","A14"."LEVEL_ID" "LEVEL_ID","A14"."LEVEL_ALLOC_PERCENT" "LEVEL_ALLOC_PERCENT","A14"."LEVEL_PRIORITY" "LEVEL_PRIORITY","A14"."MIN_LEVEL_ALLOC_PERCENT" "MIN_LEVEL_ALLOC_PERCENT","A14"."MIN_ALLOCATION_PERCENT" "MIN_ALLOCATION_PERCENT" FROM "MSC"."MSC_ALLOCATIONS" "A14","MSC"."MSC_ALLOC_RULE_TIME_PHASES" "A13","MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A12","MSC"."MSC_SYSTEM_ITEMS" "A11","MSC"."MSC_ITEM_CATEGORIES" "A10" WHERE "A12"."ASSIGNMENT_TYPE"=2 AND "A12"."CATEGORY_SET_ID"="A10"."CATEGORY_SET_ID" AND "A12"."CATEGORY_NAME"="A10"."CATEGORY_NAME" AND "A12"."ALLOCATION_RULE_NAME"="A13"."ALLOCATION_RULE_NAME" AND "A13"."TIME_PHASE_ID"="A14"."TIME_PHASE_ID" AND "A10"."INVENTORY_ITEM_ID"="A11"."INVENTORY_ITEM_ID" AND "A10"."ORGANIZATION_ID"="A11"."ORGANIZATION_ID" AND "A10"."SR_INSTANCE_ID"="A11"."SR_INSTANCE_ID" AND "A11"."PLAN_ID"=(-1) AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A25" WHERE "A25"."INVENTORY_ITEM_ID"="A11"."INVENTORY_ITEM_ID" AND "A25"."ASSIGNMENT_TYPE"=3) AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A24" WHERE "A24"."INVENTORY_ITEM_ID"="A11"."INVENTORY_ITEM_ID" AND "A24"."ORGANIZATION_ID"="A11"."ORGANIZATION_ID" AND "A24"."SR_INSTANCE_ID"="A11"."SR_INSTANCE_ID" AND "A24"."ASSIGNMENT_TYPE"=7)) UNION ALL (SELECT "A6"."INVENTORY_ITEM_ID" "INVENTORY_ITEM_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_SYSTEM_ITEMS" "A6" WHERE "A7"."ASSIGNMENT_TYPE"=6 AND "A7"."ALLOCATION_RULE_NAME"="A8"."ALLOCATION_RULE_NAME" AND "A8"."TIME_PHASE_ID"="A9"."TIME_PHASE_ID" AND "A6"."ORGANIZATION_ID"="A7"."ORGANIZATION_ID" AND "A6"."SR_INSTANCE_ID"="A7"."SR_INSTANCE_ID" AND "A6"."PLAN_ID"=(-1) AND NOT EXISTS (SELECT /*+ LEADING ("A29") */ 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A29","MSC"."MSC_ITEM_CATEGORIES" "A28" WHERE "A29"."CATEGORY_SET_ID"="A28"."CATEGORY_SET_ID" AND "A29"."CATEGORY_NAME"="A28"."CATEGORY_NAME" AND "A6"."INVENTORY_ITEM_ID"="A28"."INVENTORY_ITEM_ID" AND "A6"."ORGANIZATION_ID"="A28"."ORGANIZATION_ID" AND "A6"."SR_INSTANCE_ID"="A28"."SR_INSTANCE_ID" AND "A29"."ASSIGNMENT_TYPE"=2) AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A27" WHERE "A27"."INVENTORY_ITEM_ID"="A6"."INVENTORY_ITEM_ID" AND "A27"."ASSIGNMENT_TYPE"=3) AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A26" WHERE "A26"."INVENTORY_ITEM_ID"="A6"."INVENTORY_ITEM_ID" AND "A26"."ORGANIZATION_ID"="A6"."ORGANIZATION_ID" AND "A26"."SR_INSTANCE_ID"="A6"."SR_INSTANCE_ID" AND "A26"."ASSIGNMENT_TYPE"=7)) UNION ALL (SELECT "A4"."INVENTORY_ITEM_ID" "INVENTORY_ITEM_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_SYSTEM_ITEMS" "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 NOT EXISTS (SELECT /*+ LEADING ("A34") */ 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A34","MSC"."MSC_ITEM_CATEGORIES" "A33" WHERE "A34"."CATEGORY_SET_ID"="A33"."CATEGORY_SET_ID" AND "A34"."CATEGORY_NAME"="A33"."CATEGORY_NAME" AND "A4"."INVENTORY_ITEM_ID"="A33"."INVENTORY_ITEM_ID" AND "A4"."ORGANIZATION_ID"="A33"."ORGANIZATION_ID" AND "A4"."SR_INSTANCE_ID"="A33"."SR_INSTANCE_ID" AND "A34"."ASSIGNMENT_TYPE"=2) AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A32" WHERE "A32"."INVENTORY_ITEM_ID"="A4"."INVENTORY_ITEM_ID" AND "A32"."ASSIGNMENT_TYPE"=3) AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A31" WHERE "A31"."ORGANIZATION_ID"="A4"."ORGANIZATION_ID" AND "A31"."SR_INSTANCE_ID"="A4"."SR_INSTANCE_ID" AND "A31"."ASSIGNMENT_TYPE"=6) AND NOT EXISTS (SELECT 0 FROM "MSC"."MSC_ALLOCATION_ASSIGNMENTS" "A30" WHERE "A30"."INVENTORY_ITEM_ID"="A4"."INVENTORY_ITEM_ID" AND "A30"."ORGANIZATION_ID"="A4"."ORGANIZATION_ID" AND "A30"."SR_INSTANCE_ID"="A4"."SR_INSTANCE_ID" AND "A30"."ASSIGNMENT_TYPE"=7))
[Home] [Help]