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 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19