RO_NEST_CAT_VW2

(SQL View)
 Index Back

Nested Catalogs

Record used to retrieve the nested catalog information

SELECT A.SETID , A.CATALOG_ID_NUM , A.NEST_CAT_ID , A.NESTED_CATALOG , A.BEGIN_DT , A.END_DATE , B.DESCR FROM PS_RO_NEST_CAT A , PS_RO_PRD_CATALOG B WHERE A.SETID = B.SETID AND A.NEST_CAT_ID = B.CATALOG_ID_NUM AND B.STATUS = 'A'

  • Related Language Record: RO_NEST_CAT_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
    2 CATALOG_ID_NUM Number(5,0) INTEGER NOT NULL Catalog ID
    3 NEST_CAT_ID Number(5,0) INTEGER NOT NULL Catalog ID

    Prompt Table: RO_PRD_CATALOG

    4 NESTED_CATALOG Number(5,0) INTEGER NOT NULL Catalog Identification Number
    5 BEGIN_DT Date(10) DATE Begin Date

    Default Value: %date

    6 END_DATE Date(10) DATE End date field to store an end date.
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description