RBW_AST_TYP3_VW

(SQL View)
 Index Back

View to display Asset Type1

This view is used for displaying all asset type1

SELECT DISTINCT ASSET_TYPE1 ,ASSET_TYPE2 ,ASSET_TYPE3 ,ASSET_CAT_DESCR FROM PS_RBW_ASSET_CATEG ASTCAT , PS_RBW_CAT_DEF_TBL CATDEF WHERE ASTCAT.ASSET_TYPE3 = CATDEF.ASSET_CAT_TYPE

  • Related Language Record: RBW_AST_TYP3_LN

    • # 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 ASSET_TYPE2 Character(4) VARCHAR2(4) NOT NULL This is the asset type2 of the asset category table.
    3 ASSET_TYPE3 Character(4) VARCHAR2(4) NOT NULL This is the asset type3 of the asset category table.
    4 ASSET_CAT_DESCR Character(40) VARCHAR2(40) NOT NULL Asset category Type description