WL_TDISTR_VW

index back

Template distribution groups

View used to display field descriptions for template distribution groups.
SELECT G.PNLGRPNAME , G.MARKET , G.SEQNO , G.LABEL_ID , L.LONGNAME FROM PS_WL_DISTR_GRP G , PSDBFLDLABL L WHERE G.LABEL_ID = L.LABEL_ID

  • Related language record: WL_DISTR_LN_VW
  • PeopleSoft Field Name Field Type Column Type Description
    PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
    SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19