(SELECT DISTINCT "A4"."CATEGORY_SET_ID" "CATEGORY_SET_ID","A4"."SR_CATEGORY_ID" "SR_CATEGORY_ID","A4"."SR_INSTANCE_ID" "SR_INSTANCE_ID","A4"."CATEGORY_NAME" "CATEGORY_NAME","A4"."DESCRIPTION" "DESCRIPTION" FROM "MSC"."MSC_ITEM_CATEGORIES" "A4" WHERE EXISTS (SELECT 0 FROM ( (SELECT "MSC_APCC_CONFIG"."CATEGORY_SET_ID1" "CATEGORY_SET_ID" FROM "MSC"."MSC_APCC_CONFIG" "MSC_APCC_CONFIG" WHERE ROWNUM=1)UNION (SELECT "MSC_APCC_CONFIG"."CATEGORY_SET_ID2" "CATEGORY_SET_ID2" FROM "MSC"."MSC_APCC_CONFIG" "MSC_APCC_CONFIG" WHERE ROWNUM=1)UNION (SELECT "MSC_APCC_CONFIG"."CATEGORY_SET_ID3" "CATEGORY_SET_ID3" FROM "MSC"."MSC_APCC_CONFIG" "MSC_APCC_CONFIG" WHERE ROWNUM=1)UNION (SELECT "MSC_APCC_CONFIG"."PG_CATEGORY_SET_ID" "PG_CATEGORY_SET_ID" FROM "MSC"."MSC_APCC_CONFIG" "MSC_APCC_CONFIG" WHERE ROWNUM=1)) "A5" WHERE "A4"."CATEGORY_SET_ID"="A5"."CATEGORY_SET_ID" AND "A5"."CATEGORY_SET_ID" IS NOT NULL)) UNION ALL (SELECT DISTINCT "A3"."CATEGORY_SET_ID" "CATEGORY_SET_ID",TO_NUMBER((-23453)) "SR_CATEGORY_ID","A2"."SR_INSTANCE_ID" "SR_INSTANCE_ID",TO_CHAR(NULL) "CATEGORY_NAME",TO_CHAR(NULL) "DESCRIPTION" FROM (SELECT "A6"."CATEGORY_SET_ID" "CATEGORY_SET_ID" FROM ( (SELECT "MSC_APCC_CONFIG"."CATEGORY_SET_ID1" "CATEGORY_SET_ID" FROM "MSC"."MSC_APCC_CONFIG" "MSC_APCC_CONFIG" WHERE ROWNUM=1)UNION (SELECT "MSC_APCC_CONFIG"."CATEGORY_SET_ID2" "CATEGORY_SET_ID2" FROM "MSC"."MSC_APCC_CONFIG" "MSC_APCC_CONFIG" WHERE ROWNUM=1)UNION (SELECT "MSC_APCC_CONFIG"."CATEGORY_SET_ID3" "CATEGORY_SET_ID3" FROM "MSC"."MSC_APCC_CONFIG" "MSC_APCC_CONFIG" WHERE ROWNUM=1)UNION (SELECT "MSC_APCC_CONFIG"."PG_CATEGORY_SET_ID" "PG_CATEGORY_SET_ID" FROM "MSC"."MSC_APCC_CONFIG" "MSC_APCC_CONFIG" WHERE ROWNUM=1)) "A6" WHERE "A6"."CATEGORY_SET_ID" IS NOT NULL) "A3", ( (SELECT DISTINCT "A9"."INSTANCE_ID" "SR_INSTANCE_ID" FROM "MSC"."MSC_APPS_INSTANCES" "A9") UNION ALL (SELECT TO_NUMBER((-23453)) "TO_NUMBER(-23453)" FROM "SYS"."DUAL" "A8")) "A2")
[Home] [Help]