Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Lori713's scratchpad

by Lori713 (Pilgrim)
on Oct 25, 2004 at 14:25 UTC ( [id://402226]=scratchpad: print w/replies, xml ) Need Help??

--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
Domain Nodelet?
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2024-03-19 05:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found