EOPP_CPPRJ_NMVW

(SQL View)
 Index Back

Project view

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

SELECT PROJECTNAME , PROJECTDESCR FROM PSPROJECTDEFN WHERE PROJECTNAME IN ( SELECT PROJECTNAME FROM PSPROJECTITEM WHERE OBJECTTYPE = 54 OR OBJECTTYPE = 55)

  • Related Language Record: EOPP_CPPRJ_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
    2 PROJECTDESCR Character(30) VARCHAR2(30) NOT NULL Project Description