View: FA_CHILD_ASSETS_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_CHILD_ASSETS_V

View Text

SELECT LPAD(' '
, 2*(LEVEL-1))||NAME ALIAS
, NAME
, ASSET_HIERARCHY_PURPOSE_ID
, ASSET_HIERARCHY_ID
, DESCRIPTION
, PARENT_HIERARCHY_ID
, ASSET_ID
FROM FA_ASSET_HIERARCHY START WITH PARENT_HIERARCHY_ID IS NULL CONNECT BY PRIOR ASSET_HIERARCHY_ID = PARENT_HIERARCHY_ID

Columns