BU_GRP_ASSET_VW

(SQL View)
 Index Back

Group Asset at Book Lvl


SELECT b.business_unit , b.book , b.asset_id , b.depr_status FROM PS_ASSET A , ps_book B , ps_bu_book_tbl C WHERE a.business_unit = b.business_unit AND a.asset_id = b.asset_id AND a.group_asset_flag = 'G' AND b.business_unit = c.business_unit AND b.book = c.book AND c.group_proc_sw = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name
3 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID
4 DEPR_STATUS Character(1) VARCHAR2(1) NOT NULL Depreciation Status
D=Depreciable
N=Non Depreciable