PTPP_CPPRJ_LVW

(SQL View)
Index Back

Project view

Retrieves the project to be used during the EOPP_CPPROJ AE process.

SELECT A.PROJECTNAME ,B.LANGUAGE_CD , B.PROJECTDESCR FROM PSPROJECTDEFN A , PSPROJDEFNLANG B WHERE A.PROJECTNAME = B.PROJECTNAME AND A.PROJECTNAME IN ( SELECT PROJECTNAME FROM PSPROJECTITEM WHERE OBJECTTYPE = 54 OR OBJECTTYPE = 55)

  • Related Language Record for PTPP_CPPRJ_NMVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 PROJECTDESCR Character(30) VARCHAR2(30) NOT NULL Project Description