View: FA_ASSET_HIST_WEB_V

Product:	OFA - Assets
Description:	Asset history information
Implementation/DBA Data:	APPS.FA_ASSET_HIST_WEB_V

View Text

SELECT AH.TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN
, AH.TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT
, AH.TRANSACTION_HEADER_ID_IN KEY
, AH.ASSET_ID
, AD.ASSET_NUMBER||' - '||AD.DESCRIPTION ASSET_NUMBER
, LO.MEANING TRANSACTION_TYPE
, AH.UNITS
, LU.MEANING ASSET_TYPE
, CK.CONCATENATED_SEGMENTS CATEGORY
, AH.CATEGORY_ID
, TH.TRANSACTION_NAME COMMENTS
FROM FA_ADDITIONS AD
, FA_LOOKUPS LO
, FA_LOOKUPS LU
, FA_ASSET_HISTORY AH
, FA_CATEGORIES_B_KFV CK
, FA_TRANSACTION_HEADERS TH
WHERE TH.TRANSACTION_HEADER_ID = AH.TRANSACTION_HEADER_ID_IN
AND AD.ASSET_ID = AH.ASSET_ID
AND (LO.LOOKUP_TYPE = 'FAXOLTRX'
AND LO.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE)
AND (LU.LOOKUP_TYPE = 'ASSET TYPE'
AND LU.LOOKUP_CODE = AH.ASSET_TYPE)
AND AD.ASSET_CATEGORY_ID = CK.CATEGORY_ID UNION SELECT AH.TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN
, AH.TRANSACTION_HEADER_ID_OUT TRANSACTION_HEADER_ID_OUT
, AH.TRANSACTION_HEADER_ID_OUT KEY
, AH.ASSET_ID
, AD.ASSET_NUMBER||' - '||AD.DESCRIPTION ASSET_NUMBER
, LO.MEANING TRANSACTION_TYPE
, AH.UNITS
, LU.MEANING ASSET_TYPE
, CK.CONCATENATED_SEGMENTS
, AH.CATEGORY_ID
, TH.TRANSACTION_NAME COMMENTS
FROM FA_ADDITIONS AD
, FA_LOOKUPS LO
, FA_LOOKUPS LU
, FA_ASSET_HISTORY AH
, FA_CATEGORIES_B_KFV CK
, FA_TRANSACTION_HEADERS TH
WHERE TH.TRANSACTION_HEADER_ID = AH.TRANSACTION_HEADER_ID_IN
AND AD.ASSET_ID = AH.ASSET_ID
AND AD.ASSET_CATEGORY_ID = CK.CATEGORY_ID
AND (LO.LOOKUP_TYPE = 'FAXOLTRX'
AND LO.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE)
AND (LU.LOOKUP_TYPE = 'ASSET TYPE'
AND LU.LOOKUP_CODE = AH.ASSET_TYPE)
AND AD.ASSET_CATEGORY_ID = CK.CATEGORY_ID
AND AH.TRANSACTION_HEADER_ID_OUT IS NOT NULL

Columns