PSADSPROJADS_VW

index back

ADS Project ADS view

Lists distinct ADS names in a project
SELECT DISTINCT B.PROJECTNAME , B.PTADSNAME FROM PSPROJADSBIND B , PSPROJECTITEM I WHERE I.PROJECTNAME = B.PROJECTNAME AND I.OBJECTTYPE = 106 AND I.OBJECTID1 = 173 AND CAST(I.OBJECTVALUE1 AS INTEGER ) = B.PTADSCONTENTID

PeopleSoft Field NameField TypeColumn TypeDescription
PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).

Prompt Table: PSADSPROJECT_VW

PTADSNAMECharacter(30)VARCHAR2(30) NOT NULLData Set Name (see PSADSDEFN).

Prompt Table: PTADSDEFN_DVW

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19