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 NameField TypeColumn TypeDescription
    PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
    PROJECTDESCRCharacter(30)VARCHAR2(30) NOT NULLProject Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19