[Home] [Help]
View: FA_ASSET_HRCHY_DETAILS_V
View Text
SELECT AH.ASSET_HIERARCHY_ID
, AH.NAME
, DECODE(NVL(AH.ASSET_ID
, 0)
, 0
, AH.DESCRIPTION
, FA.DESCRIPTION)
, AH.PARENT_HIERARCHY_ID
, AH.LOWEST_LEVEL_FLAG
, AH.DEPRECIATION_START_DATE
, AH.ASSET_ID
FROM FA_ASSET_HIERARCHY AH
, FA_ADDITIONS FA
WHERE FA.ASSET_ID(+) = AH.ASSET_ID
Columns
| Name |
| ASSET_HIERARCHY_ID |
| NAME |
| DESCRIPTION |
| PARENT_HIERARCHY_ID |
| LOWEST_LEVEL_FLAG |
| DEPRECIATION_START_DATE |
| ASSET_ID |
APPS.FA_ASSET_HRCHY_DETAILS_V