GM_PT_PRJ_LVW

(SQL View)
 Index Back

Lang Rec for GM_PT_PRJ_VW


SELECT C.OPRID , A.BUSINESS_UNIT_PC , A.PROJECT_ID , LNG.LANGUAGE_CD , LNG.DESCR FROM PS_GM_PT_PROJECT A , PS_GM_PT_ACC_LVL3 B , PSOPRDEFN C , PS_PROJECT_LANG LNG WHERE C.EMPLID = B.EMPLID AND A.PROJECT_ID = B.PROJECT_ID AND A.BUSINESS_UNIT_PC = B.BUSINESS_UNIT_PC AND B.PROJECT_FLG = 'Y' AND (B.END_DT >= %CurrentDateIn OR B.END_DT IS NULL) AND A.BUSINESS_UNIT_PC = LNG.BUSINESS_UNIT AND A.PROJECT_ID = LNG.PROJECT_ID

  • Related Language Record for GM_PT_PRJ_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 PROJDESCR Character(30) VARCHAR2(30) NOT NULL Project Name