RBW_ASTCAT1_VW

(SQL View)
Index Back

View to display Asset Type1

This view is used for displaying all asset type1

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

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