INSERT INTO FBC_RPT
SELECT
DECODE(DIST,'AT','AT','AN','AT','LA','LA','NC','NC','NV','NC','SD','SD','IV','SD') MARKET,
CYDATE,
BILL_CYCLE,
DECODE(RMR_IND,'H','HOME AIRTIME','C','PASS THROUGH ROAMING','R','SWITCH ROAMING','F','SWITCH ROAMING') CALL_CATEGORY,
'01) NUMBER OF ACCOUNTS' HEADING_NAME,
SUBSTR('N/A',1,3) RE_TIER1,
SUBSTR('N/A',1,3) RE_TIER2,
SUBSTR('N/A',1,3) RE_TIER3,
SUM(DECODE(ATYPE,'RE',ACCT_CNT,0)) RE_TOTAL,
SUBSTR('N/A',1,3) WH_TIER1,
SUBSTR('N/A',1,3) WH_TIER2,
SUBSTR('N/A',1,3) WH_TIER3,
SUM(DECODE(ATYPE,'WH',ACCT_CNT,0)) WH_TOTAL,
'HM' SUM_TYPE,
' ' SUM_LEVEL
FROM FBC1
WHERE RMR_IND = 'H'
AND CYDATE = '&&2'
GROUP BY
DECODE(DIST,'AT','AT','AN','AT','LA','LA','NC','NC','NV','NC','SD','SD','IV','SD'),
CYDATE,
BILL_CYCLE,
DECODE(RMR_IND,'H','HOME AIRTIME','C','PASS THROUGH ROAMING','R','SWITCH ROAMING','F','SWITCH ROAMING')
UNION
SELECT
DECODE(DIST,'AT','AT','AN','AT','LA','LA','NC','NC','NV','NC','SD','SD','IV','SD') MARKET,
CYDATE,
BILL_CYCLE,
DECODE(RMR_IND,'H','HOME AIRTIME','C','PASS THROUGH ROAMING','R','SWITCH ROAMING','F','SWITCH ROAMING') CALL_CATEGORY,
'02) NUMBER OF PHONES' HEADING_NAME,
SUBSTR('N/A',1,3) RE_TIER1,
SUBSTR('N/A',1,3) RE_TIER2,
SUBSTR('N/A',1,3) RE_TIER3,
SUM(DECODE(ATYPE,'RE',SVC_CNT,0)) RE_TOTAL,
SUBSTR('N/A',1,3) WH_TIER1,
SUBSTR('N/A',1,3) WH_TIER2,
SUBSTR('N/A',1,3) WH_TIER3,
SUM(DECODE(ATYPE,'WH',SVC_CNT,0)) WH_TOTAL,
'HM' SUM_TYPE,
' ' SUM_LEVEL
FROM FBC1
WHERE RMR_IND = 'H'
AND CYDATE = '&&2'
GROUP BY
DECODE(DIST,'AT','AT','AN','AT','LA','LA','NC','NC','NV','NC','SD','SD','IV','SD'),
CYDATE,
BILL_CYCLE,
DECODE(RMR_IND,'H','HOME AIRTIME','C','PASS THROUGH ROAMING','R','SWITCH ROAMING','F','SWITCH ROAMING')
UNION
SELECT
DECODE(DIST,'AT','AT','AN','AT','LA','LA','NC','NC','NV','NC','SD','SD','IV','SD') MARKET,
CYDATE,
BILL_CYCLE,
DECODE(RMR_IND,'H','HOME AIRTIME','C','PASS THROUGH ROAMING','R','SWITCH ROAMING','F','SWITCH ROAMING') CALL_CATEGORY,
'03) UNBUNDLED RECORDS' HEADING_NAME,
SUBSTR('N/A',1,3) RE_TIER1,
SUBSTR('N/A',1,3) RE_TIER2,
SUBSTR('N/A',1,3) RE_TIER3,
SUM(DECODE(ATYPE,'RE',REC_CNT,0)) RE_TOTAL,
SUBSTR('N/A',1,3) WH_TIER1,
SUBSTR('N/A',1,3) WH_TIER2,
SUBSTR('N/A',1,3) WH_TIER3,
SUM(DECODE(ATYPE,'WH',REC_CNT,0)) WH_TOTAL,
'HM' SUM_TYPE,
'S1' SUM_LEVEL
FROM FBC1
WHERE RMR_IND = 'H'
AND CYDATE = '&&2'
AND BUNDLE_IND = 'UNBUNDLED'
GROUP BY
...<snip>...
and so forth for 1,556 lines!!!