PSTREEDEFDTLVW

 index back

Tree Defn Prompt - No Branches


SELECT DISTINCT DEFN.TREE_NAME ,STRCT.DTL_RECNAME FROM PSTREEDEFN DEFN ,PSTREESTRCT STRCT WHERE DEFN.TREE_STRCT_ID <> 'ACCESS_GROUP' AND DEFN.TREE_STRCT_ID = STRCT.TREE_STRCT_ID AND STRCT.SETCNTRL_IND IN ('S','N') AND STRCT.TREE_STRCT_TYPE = 'D'

PeopleSoft Field Name Field Type Column Type Description
TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
DTL_RECNAME Character(15) VARCHAR2(15) NOT NULL Tree Structure Detail Record name

Prompt Table: PSTREESTRCTDTVW

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20