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 Name Field Type Column Type Description
PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).

Prompt Table: PSADSPROJECT_VW

PTADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name (see PSADSDEFN).

Prompt Table: PTADSDEFN_DVW

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