VIEW: APPS.FA_ASSET_HIERARCHY_VALUES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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