Anyone can simplify this query?
SELECT
A.PROD_GROUP AS REVENUE_TYPE
,A.AGENT_ID
,TO_CHAR(A.CYCLE_DATE,'MM/DD/YYYY') AS CYCLE_DATE ,'B' AS MARKET_SEG
,B.AGENT_NAME ,A.PAY_LEVEL1_ATTUID AS ATTUID1 ,A.REVENUE_PAID +
A.REVENUE_RECOUP AS REVENUE
,A.SMART_ID
,A.PAY_LEVEL1_ATTUID
,A.PAY_LEVEL2_ATTUID
,A.PAY_LEVEL3_ATTUID
FROM CNT700_ACES_AGENT_COMP A,
CNT120_AGENT B
WHERE
A.AGENT_ID = B.AGENT_ID
AND A.CYCLE_DATE >= '01-JUN-08'
AND A.CYCLE_DATE <= '30-JUN-08'
AND A.SUBSID_CD = 'EAST'
AND A.PAY_LEVEL1_ATTUID IS NOT NULL
AND A.PAY_LEVEL1_ATTUID <> 'DUMMY'
UNION ALL
SELECT
A.PROD_GROUP AS REVENUE_TYPE
,A.AGENT_ID
,TO_CHAR(A.CYCLE_DATE,'MM/DD/YYYY') AS CYCLE_DATE
,'B' AS MARKET_SEG
,B.AGENT_NAME
,A.PAY_LEVEL2_ATTUID AS ATTUID1
,A.REVENUE_PAID + A.REVENUE_RECOUP AS REVENUE
,A.SMART_ID
,A.PAY_LEVEL1_ATTUID
,A.PAY_LEVEL2_ATTUID
,A.PAY_LEVEL3_ATTUID
FROM CNT700_ACES_AGENT_COMP A,
CNT120_AGENT B
WHERE
A.AGENT_ID = B.AGENT_ID
AND A.CYCLE_DATE >= '01-JUN-08'
AND A.CYCLE_DATE <= '30-JUN-08'
AND A.SUBSID_CD = 'EAST'
AND A.PAY_LEVEL2_ATTUID IS NOT NULL
AND A.PAY_LEVEL2_ATTUID <> 'DUMMY'
UNION ALL
SELECT
A.PROD_GROUP AS REVENUE_TYPE
,A.AGENT_ID
,TO_CHAR(A.CYCLE_DATE,'MM/DD/YYYY') AS CYCLE_DATE
,'B' AS MARKET_SEG
,B.AGENT_NAME
,A.PAY_LEVEL3_ATTUID AS ATTUID1
,A.REVENUE_PAID + A.REVENUE_RECOUP AS REVENUE
,A.SMART_ID
,A.PAY_LEVEL1_ATTUID
,A.PAY_LEVEL2_ATTUID
,A.PAY_LEVEL3_ATTUID
FROM CNT700_ACES_AGENT_COMP A,
CNT120_AGENT B
WHERE
A.AGENT_ID = B.AGENT_ID
AND A.CYCLE_DATE >= '01-JUN-08'
AND A.CYCLE_DATE <= '30-JUN-08'
AND A.SUBSID_CD = 'EAST'
AND A.PAY_LEVEL3_ATTUID IS NOT NULL
AND A.PAY_LEVEL3_ATTUID <> 'DUMMY'
ORDER BY
3,
9,
2,
8,
1,
6,
10,
11{code}
Thanks in advance