RBW_ASTCAT1_V_L

(SQL View)
 Index Back

Related for Level 1 types

This is the related language record for asset category type 1 view

SELECT TYP.ASSET_CAT_TYPE ,LANGUAGE_CD ,TYPL.ASSET_CAT_DESCR FROM PS_RBW_CAT_DEF_TBL TYP , PS_RBW_CATDEF_LNG TYPL WHERE TYP.ASSET_CAT_TYPE = TYPL.ASSET_CAT_TYPE AND AST_CAT_LEVEL = '1'

  • Related Language Record for RBW_ASTCAT1_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 ASSET_CAT_DESCR Character(40) VARCHAR2(40) NOT NULL Asset category Type description