RBW_ASTCAT3_VW

(SQL View)
Index Back

View to display Asset Type3

This view is used for displaying all asset type3

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

  • Related Language Record: RBW_ASTCAT3_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