Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

Scratch Pad Viewer

( #108949=superdoc: print w/ replies, xml ) Need Help??
Username:


--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) ;
Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (14)
As of 2015-07-07 19:45 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (93 votes), past polls