View: FA_ASSET_HRCHY_DETAILS_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.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