RBW_ASTCAT2_VW

(SQL View)
 Index Back

View to display Asset Type2

This view is used for displaying all asset type2

SELECT ASSET_CAT_TYPE ,ASSET_CAT_DESCR FROM PS_RBW_CAT_DEF_TBL WHERE AST_CAT_LEVEL = '2'

  • Related Language Record: RBW_ASTCAT2_V_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ASSET_CAT_TYPE Character(4) VARCHAR2(4) NOT NULL Asset category Type definition
    2 ASSET_CAT_DESCR Character(40) VARCHAR2(40) NOT NULL Asset category Type description