VIEW: APPS.FA_CHILD_ASSETS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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