RBW_ASTCAT3_VW(SQL View) |
Index Back |
|---|---|
View to display Asset Type3This view is used for displaying all asset type3 |
| SELECT ASSET_CAT_TYPE ,ASSET_CAT_DESCR FROM PS_RBW_CAT_DEF_TBL WHERE AST_CAT_LEVEL = '3' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(4) | VARCHAR2(4) NOT NULL | Asset category Type definition | |
| 2 | ASSET_CAT_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Asset category Type description |