GM_KK_PRJ_DT_VW

(SQL View)
 Index Back

KK Project Start and End Dates


SELECT DISTINCT DTL.CONTRACT_NUM , DTL.BUSINESS_UNIT_PC , DTL.PROJECT_ID , CF1.BEGIN_DT , CF1.END_DT FROM PS_CA_DETAIL_PROJ DTL , PS_KK_CF_VALUE CF1 , PS_KK_BUDGET_TYPE TP , PS_GM_BU_AWD_SETUP BU , PS_GM_AWARD AWD , PS_SET_CNTRL_REC ST1 , PS_PC_INT_TMPLGLVW PCTMPL , PS_SET_CNTRL_REC ST2 , PS_LED_GRP_FLD_TBL LG1 , PS_SET_CNTRL_REC ST3 , PS_SET_CNTRL_REC ST4 WHERE BU.BUSINESS_UNIT = AWD.BUSINESS_UNIT AND ST1.SETCNTRLVALUE = BU.BUSINESS_UNIT_PC AND ST1.RECNAME = 'PC_INT_TMPLGLVW' AND PCTMPL.SETID = ST1.SETID AND PCTMPL.INTEGRATION_TMPL = BU.INTEGRATION_TMPL AND ST2.SETCNTRLVALUE = PCTMPL.BUSINESS_UNIT_GL AND ST2.RECNAME = 'KK_BD_TYPE_VW' AND LG1.LEDGER_GROUP = BU.LEDGER_GROUP AND LG1.CHARTFIELD = 'PROJECT_ID' AND LG1.FIELD_SEQUENCE = ( SELECT MIN(LG2.FIELD_SEQUENCE) FROM PS_LED_GRP_FLD_TBL LG2 WHERE LG1.SETID = LG2.SETID AND LG1.LEDGER_GROUP = LG2.LEDGER_GROUP AND LG1.CHARTFIELD = LG2.CHARTFIELD) AND ST3.SETCNTRLVALUE = PCTMPL.BUSINESS_UNIT_GL AND ST3.RECNAME = 'LED_GRP_FLD_TBL' AND LG1.SETID = ST3.SETID AND ST4.SETCNTRLVALUE = PCTMPL.BUSINESS_UNIT_GL AND ST4.RECNAME = LG1.RECNAME AND AWD.CONTRACT_NUM = DTL.CONTRACT_NUM AND TP.SETID1 = ST2.SETID AND TP.SETID1 = CF1.SETID1 AND TP.LEDGER_GROUP = BU.LEDGER_GROUP AND TP.LEDGER_GROUP = CF1.LEDGER_GROUP AND TP.EFFDT = CF1.EFFDT AND CF1.RANGE_FROM <= DTL.PROJECT_ID AND CF1.RANGE_TO >= DTL.PROJECT_ID AND CF1.SETID = ST4.SETID AND %EffdtCheck(KK_CF_VALUE CF2, CF1, %CurrentDateIn) AND TP.EFF_STATUS = 'A' AND TP.CONTROL_CHARTFIELD = LG1.CHARTFIELD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
3 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
4 BEGIN_DT Date(10) DATE Begin Date
5 END_DT Date(10) DATE End Date