View: FA_ASSET_HIERARCHY_VALUES_V

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

View Text

SELECT HV.ROWID
, HV.ASSET_HIERARCHY_ID
, HV.BOOK_TYPE_CODE
, HV.ASSET_CATEGORY_ID
, HV.LEASE_ID
, FL.LEASE_NUMBER
, HV.ASSET_KEY_CCID
, HV.SERIAL_NUMBER
, HV.LIFE_END_DATE
, HV.DIST_SET_ID
, HV.CREATED_BY
, HV.CREATION_DATE
, HV.LAST_UPDATED_BY
, HV.LAST_UPDATE_DATE
, HV.LAST_UPDATE_LOGIN
FROM FA_ASSET_HIERARCHY_VALUES HV
, FA_ASSET_HIERARCHY AH
, FA_LEASES FL
WHERE AH.ASSET_HIERARCHY_ID = HV.ASSET_HIERARCHY_ID
AND AH.ASSET_ID IS NULL
AND FA_CUA_HIERARCHY_PKG.GET_GLOBAL_LEVEL_NUMBER <> 0
AND HV.LEASE_ID = FL.LEASE_ID(+) UNION ALL SELECT AH.ROWID
, AH.ASSET_HIERARCHY_ID
, FB.BOOK_TYPE_CODE
, FA.ASSET_CATEGORY_ID
, FA.LEASE_ID
, FL.LEASE_NUMBER
, FA.ASSET_KEY_CCID
, FA.SERIAL_NUMBER
, TO_DATE(NULL)
, -1
, AH.CREATED_BY
, AH.CREATION_DATE
, AH.LAST_UPDATED_BY
, AH.LAST_UPDATE_DATE
, AH.LAST_UPDATE_LOGIN
FROM FA_ASSET_HIERARCHY AH
, FA_ADDITIONS FA
, FA_LEASES FL
, FA_BOOKS FB
WHERE AH.ASSET_ID IS NOT NULL
AND FA_CUA_HIERARCHY_PKG.GET_GLOBAL_LEVEL_NUMBER = 0
AND AH.ASSET_ID = FA.ASSET_ID
AND FA.LEASE_ID = FL.LEASE_ID(+)
AND AH.ASSET_ID = FB.ASSET_ID
AND FB.DATE_INEFFECTIVE IS NULL

Columns