RBW_AST_TYP3_LN (SQL View)	Index Back
View to display Asset Type2 This view is used for displaying all asset type2

RBW_AST_TYP3_LN

(SQL View)

View to display Asset Type2

This view is used for displaying all asset type2

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

Related Language Record for RBW_AST_TYP3_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 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 ASSET_CAT_DESCR Character(40) VARCHAR2(40) NOT NULL Asset category Type description

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