VIEW: APPS.FA_ASSET_HRCHY_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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