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