RBW_AST_TYP1_LN

(SQL View)
 Index Back

View to display Asset Type1

This view is used for displaying all asset type1

SELECT a.ASSET_CAT_TYPE , LANGUAGE_CD ,b.ASSET_CAT_DESCR FROM PS_RBW_CAT_DEF_TBL a , PS_RBW_CATDEF_LNG b WHERE a.ASSET_CAT_TYPE = b.ASSET_CAT_TYPE AND AST_CAT_LEVEL = '1'

  • Related Language Record for RBW_AST_TYP1_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ASSET_TYPE1 Character(4) VARCHAR2(4) NOT NULL This is the asset type1 of the asset category table.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 ASSET_CAT_DESCR Character(40) VARCHAR2(40) NOT NULL Asset category Type description