PTPP_CPPRJ_NMVW

 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: PTPP_CPPRJ_LVW

    • PeopleSoft Field Name Field Type Column Type Description
    PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
    PROJECTDESCR Character(30) VARCHAR2(30) NOT NULL Project Description
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20