SPF_PROJ_D_LVW

(SQL View)
 Index Back

DeliverableBased Proj Lang Vw


SELECT A.BUSINESS_UNIT ,A.PROJECT_ID , D.LANGUAGE_CD ,D.DESCR FROM PS_PROJECT A , PS_SPA_TIME_TMPL B , PS_SPA_DEF_TE_TMPL C , PS_PROJECT_LANG D , PS_SET_CNTRL_GROUP SC WHERE A.BUSINESS_UNIT = SC.SETCNTRLVALUE AND SC.REC_GROUP_ID = 'SP_12' AND B.SETID = SC.SETID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PROJECT_ID = C.PROJECT_ID AND B.TE_TEMPLATE_ID = C.TE_TEMPLATE_ID AND A.EFF_STATUS = 'A' AND C.TE_TEMPLATE_ID IN ( SELECT D.TE_TEMPLATE_ID FROM PS_SPA_TIME_TMPL D WHERE D.SPA_TEMPLATE_TYPE = 'D') AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PROJECT_ID = D.PROJECT_ID

  • Related Language Record for SPF_PROJ_D_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

    Prompt Table: BUS_UNIT_TBL_PC

    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: PROJECT

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description