RBW_ASTCAT1_VW(SQL View) |
Index Back |
---|---|
View to display Asset Type1This 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' |
# | 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 |