--sql_act is:
SELECT B.PROJECT_ID, B.NC_EFF_STATUS, B.DESCR,
( SELECT SUM(A.POSTED_TOTAL_AMT)
FROM PS_NC_LEDGER A
WHERE A.BUSINESS_UNIT = 'NCSU1'
AND A.LEDGER = 'ACTUALS'
AND A.CURRENCY_CD = 'USD'
AND A.FISCAL_YEAR=TO_NUMBER(TO_CHAR(ADD_MONTHS(TO_DATE('June 30, 2
+010','Month DD, YYYY'),6),'YYYY'))
AND (A.ACCOUNTING_PERIOD <= TO_NUMBER(SUBSTR('07080910111201020304
+0506',
((TO_CHAR(TO_DATE('June 30, 2010', 'Month DD, YYYY')
+,'MM')*2)-1),2))
OR A.ACCOUNTING_PERIOD = 998)
AND (A.ACCOUNT BETWEEN '50000' AND '59999')
AND (A.NC_PROJECT_PROJREF = '059021')
AND B.PROJECT_ID = A.PROJECT_ID
AND B.NC_PROJECT_PROJREF = A.NC_PROJECT_PROJREF
)
FROM PS_NC_PROJ_ATTR_VW B
WHERE (B.NC_PROJECT_PROJREF = '059021')
AND B.NC_EFFDT = (SELECT MAX(B2.NC_EFFDT) FROM PS_NC_PROJ_ATTR_VW B2
WHERE B2.PROJECT_ID = B.PROJECT_ID)
;
--sql_bud is:
SELECT B.PROJECT_ID, B.NC_EFF_STATUS, B.DESCR,
( SELECT SUM(A.POSTED_TOTAL_AMT)
FROM PS_NC_LEDGER_BUDG A
WHERE A.BUSINESS_UNIT = 'NCSU1'
AND A.LEDGER = 'BD_ACTUALS'
AND A.FISCAL_YEAR=TO_NUMBER(TO_CHAR(ADD_MONTHS(TO_DATE('June 30, 2
+010','Month DD, YYYY'),6),'YYYY'))
AND A.CURRENCY_CD = 'USD'
AND A.SCENARIO IN ('CGLOAD','CG20','CG21','CI21','CN24','CN26','CY
+21','CY23','FN21')
AND (A.ACCOUNTING_PERIOD <= TO_NUMBER(SUBSTR('07080910111201020304
+0506',
((TO_CHAR(TO_DATE('June 30, 2010', 'Month DD, YYYY'),
+'MM')*2)-1),2)))
AND (A.ACCOUNT BETWEEN '50000' AND '59999')
AND (A.NC_PROJECT_PROJREF = '059021')
AND B.PROJECT_ID = A.PROJECT_ID
AND B.NC_PROJECT_PROJREF = A.NC_PROJECT_PROJREF
)
FROM PS_NC_PROJ_ATTR_VW B
WHERE (B.NC_PROJECT_PROJREF = '059021')
AND B.NC_EFFDT=(SELECT MAX(B2.NC_EFFDT) FROM PS_NC_PROJ_ATTR_VW B2
WHERE B2.PROJECT_ID= B.PROJECT_ID)
;
--sql_enc is:
SELECT B.PROJECT_ID, B.NC_EFF_STATUS, B.DESCR,
( SELECT SUM(A.POSTED_TOTAL_AMT)
FROM PS_NC_LEDGER_COM A
WHERE A.BUSINESS_UNIT = 'NCSU1'
AND (A.LEDGER = 'CC_ENC' OR A.LEDGER = 'CC_PREENC' OR A.LEDGER = '
+ACTUALS')
AND A.CURRENCY_CD = 'USD'
AND A.FISCAL_YEAR=TO_NUMBER(TO_CHAR(ADD_MONTHS(TO_DATE('June 30, 2
+010','Month DD, YYYY'),6),'YYYY'))
AND (A.ACCOUNTING_PERIOD <= TO_NUMBER(SUBSTR('07080910111201020304
+0506',
((TO_CHAR(TO_DATE('June 30, 2010', 'Month DD, YYYY')
+,'MM')*2)-1),2))
OR A.ACCOUNTING_PERIOD = 998)
AND (A.ACCOUNT BETWEEN '50000' AND '59999')
AND (A.NC_PROJECT_PROJREF = '059021')
AND B.NC_PROJECT_PROJREF = A.NC_PROJECT_PROJREF
AND B.PROJECT_ID = A.PROJECT_ID
)
FROM PS_NC_PROJ_ATTR_VW B
WHERE (B.NC_PROJECT_PROJREF = '059021')
AND B.NC_EFFDT=(SELECT MAX(B2.NC_EFFDT) FROM PS_NC_PROJ_ATTR_VW B2
WHERE B2.PROJECT_ID = B.PROJECT_ID)
;
|