VIEW: APPS.FA_ASSET_HIERARCHY_V

Source

View Text - Preformatted

SELECT AH.rowid , AH.ASSET_HIERARCHY_PURPOSE_ID , AH.ASSET_HIERARCHY_ID , AH.NAME , AH.LEVEL_NUMBER , AH.HIERARCHY_RULE_SET_ID , RS.NAME , AH.CREATED_BY , AH.CREATION_DATE , AH.LAST_UPDATED_BY , AH.LAST_UPDATE_DATE , AH.LAST_UPDATE_LOGIN , AH.DESCRIPTION , AH.PARENT_HIERARCHY_ID , AH1.NAME , AH.LOWEST_LEVEL_FLAG , AH.DEPRECIATION_START_DATE , AH.ASSET_ID , 'N' , AH.ATTRIBUTE_CATEGORY , AH.ATTRIBUTE1 , AH.ATTRIBUTE2 , AH.ATTRIBUTE3 , AH.ATTRIBUTE4 , AH.ATTRIBUTE5 , AH.ATTRIBUTE6 , AH.ATTRIBUTE7 , AH.ATTRIBUTE8 , AH.ATTRIBUTE9 , AH.ATTRIBUTE10 , AH.ATTRIBUTE11 , AH.ATTRIBUTE12 , AH.ATTRIBUTE13 , AH.ATTRIBUTE14 , AH.ATTRIBUTE15 from FA_ASSET_HIERARCHY AH, FA_ASSET_HIERARCHY AH1, FA_HIERARCHY_RULE_SET RS WHERE AH.HIERARCHY_RULE_SET_ID = RS.HIERARCHY_RULE_SET_ID(+) and AH1.asset_hierarchy_id(+) = AH.parent_hierarchy_id and AH.ASSET_ID is null UNION ALL SELECT AH.rowid , AH.ASSET_HIERARCHY_PURPOSE_ID , AH.ASSET_HIERARCHY_ID , AH.NAME , AH.LEVEL_NUMBER , AH.HIERARCHY_RULE_SET_ID , null /* RS.NAME */ , AH.CREATED_BY , AH.CREATION_DATE , AH.LAST_UPDATED_BY , AH.LAST_UPDATE_DATE , AH.LAST_UPDATE_LOGIN , FA.DESCRIPTION , AH.PARENT_HIERARCHY_ID , AH1.NAME , AH.LOWEST_LEVEL_FLAG , FB.DATE_PLACED_IN_SERVICE , AH.ASSET_ID , 'Y' , AH.ATTRIBUTE_CATEGORY , AH.ATTRIBUTE1 , AH.ATTRIBUTE2 , AH.ATTRIBUTE3 , AH.ATTRIBUTE4 , AH.ATTRIBUTE5 , AH.ATTRIBUTE6 , AH.ATTRIBUTE7 , AH.ATTRIBUTE8 , AH.ATTRIBUTE9 , AH.ATTRIBUTE10 , AH.ATTRIBUTE11 , AH.ATTRIBUTE12 , AH.ATTRIBUTE13 , AH.ATTRIBUTE14 , AH.ATTRIBUTE15 from FA_ASSET_HIERARCHY AH, FA_ASSET_HIERARCHY AH1, FA_ADDITIONS FA, FA_BOOKS FB, FA_ASSET_HIERARCHY_PURPOSE AHP where AH1.asset_hierarchy_id(+) = AH.parent_hierarchy_id and FA.ASSET_ID(+) = AH.ASSET_ID and AH.ASSET_ID is not null and AHP.ASSET_HIERARCHY_PURPOSE_ID = AH.ASSET_HIERARCHY_PURPOSE_ID and AHP.BOOK_TYPE_CODE = FB.BOOK_TYPE_CODE and AH.ASSET_ID = FB.ASSET_ID and fb.date_ineffective is null

View Text - HTML Formatted

SELECT AH.ROWID
, AH.ASSET_HIERARCHY_PURPOSE_ID
, AH.ASSET_HIERARCHY_ID
, AH.NAME
, AH.LEVEL_NUMBER
, AH.HIERARCHY_RULE_SET_ID
, RS.NAME
, AH.CREATED_BY
, AH.CREATION_DATE
, AH.LAST_UPDATED_BY
, AH.LAST_UPDATE_DATE
, AH.LAST_UPDATE_LOGIN
, AH.DESCRIPTION
, AH.PARENT_HIERARCHY_ID
, AH1.NAME
, AH.LOWEST_LEVEL_FLAG
, AH.DEPRECIATION_START_DATE
, AH.ASSET_ID
, 'N'
, AH.ATTRIBUTE_CATEGORY
, AH.ATTRIBUTE1
, AH.ATTRIBUTE2
, AH.ATTRIBUTE3
, AH.ATTRIBUTE4
, AH.ATTRIBUTE5
, AH.ATTRIBUTE6
, AH.ATTRIBUTE7
, AH.ATTRIBUTE8
, AH.ATTRIBUTE9
, AH.ATTRIBUTE10
, AH.ATTRIBUTE11
, AH.ATTRIBUTE12
, AH.ATTRIBUTE13
, AH.ATTRIBUTE14
, AH.ATTRIBUTE15
FROM FA_ASSET_HIERARCHY AH
, FA_ASSET_HIERARCHY AH1
, FA_HIERARCHY_RULE_SET RS
WHERE AH.HIERARCHY_RULE_SET_ID = RS.HIERARCHY_RULE_SET_ID(+)
AND AH1.ASSET_HIERARCHY_ID(+) = AH.PARENT_HIERARCHY_ID
AND AH.ASSET_ID IS NULL UNION ALL SELECT AH.ROWID
, AH.ASSET_HIERARCHY_PURPOSE_ID
, AH.ASSET_HIERARCHY_ID
, AH.NAME
, AH.LEVEL_NUMBER
, AH.HIERARCHY_RULE_SET_ID
, NULL /* RS.NAME */
, AH.CREATED_BY
, AH.CREATION_DATE
, AH.LAST_UPDATED_BY
, AH.LAST_UPDATE_DATE
, AH.LAST_UPDATE_LOGIN
, FA.DESCRIPTION
, AH.PARENT_HIERARCHY_ID
, AH1.NAME
, AH.LOWEST_LEVEL_FLAG
, FB.DATE_PLACED_IN_SERVICE
, AH.ASSET_ID
, 'Y'
, AH.ATTRIBUTE_CATEGORY
, AH.ATTRIBUTE1
, AH.ATTRIBUTE2
, AH.ATTRIBUTE3
, AH.ATTRIBUTE4
, AH.ATTRIBUTE5
, AH.ATTRIBUTE6
, AH.ATTRIBUTE7
, AH.ATTRIBUTE8
, AH.ATTRIBUTE9
, AH.ATTRIBUTE10
, AH.ATTRIBUTE11
, AH.ATTRIBUTE12
, AH.ATTRIBUTE13
, AH.ATTRIBUTE14
, AH.ATTRIBUTE15
FROM FA_ASSET_HIERARCHY AH
, FA_ASSET_HIERARCHY AH1
, FA_ADDITIONS FA
, FA_BOOKS FB
, FA_ASSET_HIERARCHY_PURPOSE AHP
WHERE AH1.ASSET_HIERARCHY_ID(+) = AH.PARENT_HIERARCHY_ID
AND FA.ASSET_ID(+) = AH.ASSET_ID
AND AH.ASSET_ID IS NOT NULL
AND AHP.ASSET_HIERARCHY_PURPOSE_ID = AH.ASSET_HIERARCHY_PURPOSE_ID
AND AHP.BOOK_TYPE_CODE = FB.BOOK_TYPE_CODE
AND AH.ASSET_ID = FB.ASSET_ID
AND FB.DATE_INEFFECTIVE IS NULL