GM_AWDPRJAC_LVW

(SQL View)
Index Back

Award Project Activity Lng Vw

Award Project Activity Langauge View

SELECT DISTINCT DTL.CONTRACT_NUM , DTL.BUSINESS_UNIT_PC , DTL.PROJECT_ID , DTL.ACTIVITY_ID , LG.LANGUAGE_CD , PROJ.DESCR FROM PS_CA_DETAIL_PROJ DTL , PS_PROJ_ACTIVITY PROJ ,PS_PROJ_ACTIVTY_LG LG WHERE DTL.BUSINESS_UNIT_PC = PROJ.BUSINESS_UNIT AND DTL.PROJECT_ID = PROJ.PROJECT_ID AND DTL.ACTIVITY_ID = PROJ.ACTIVITY_ID AND LG.BUSINESS_UNIT = PROJ.BUSINESS_UNIT AND LG.PROJECT_ID = PROJ.PROJECT_ID AND LG.ACTIVITY_ID = PROJ.ACTIVITY_ID

  • Related Language Record for GM_AWD_PRJAC_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Award ID
    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 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description