EXECUTE IMMEDIATE
'INSERT INTO TEMP_TABLE_1_ACTUALS
SELECT A.ACTIVITY_ID,
A.ACCOUNTING_DT,
SUM(DECODE(A.ANALYSIS_TYPE, ''COM'', A.RESOURCE_AMOUNT, 0)) ENC_AMOUNT,
SUM(DECODE(A.ANALYSIS_TYPE, ''EST'', A.RESOURCE_AMOUNT, 0)) EST_AMOUNT,
SUM(CASE
WHEN
A.ANALYSIS_TYPE IN(''ACT'',''BIL'',''MBL'')
THEN
A.RESOURCE_AMOUNT
ELSE
0
END
) EXP_AMOUNT,
SUM(DECODE(A.ANALYSIS_TYPE, ''BUD'', A.RESOURCE_AMOUNT, ''TRF'',
A.RESOURCE_AMOUNT, ''RVN'', A.RESOURCE_AMOUNT, ''CFS'',
A.RESOURCE_AMOUNT, ''CFE'', A.RESOURCE_AMOUNT,0)) REV_AMOUNT
FROM TS_PROJ_RESOURCE@TEMP_LINK A
WHERE A.BUSINESS_UNIT = ''KOC''
AND (A.PROJECT_ID LIKE ''C%''
OR A.ACTIVITY_ID LIKE ''NS%'' OR A.ACTIVITY_ID LIKE ''NN%'')
AND (A.ACCOUNT > ''699999'' or A.ACCOUNT = ''141200'' or A.ACCOUNT = ''141300'' )
AND A.ACCOUNT NOT IN (''710511'',''975900'',''710599'',''849100'',''988990'','' '')
AND A.ANALYSIS_TYPE IN (''ACT'',''COM'',''BIL'',''MBL'',''EST'',''BUD'',''TRF'',''RVN'',''CFS'',''CFE'')
GROUP BY A.ACTIVITY_ID, A.ACCOUNTING_DT';

- Chris