View: FA_ASSET_HISTORY_V

Product:	OFA - Assets
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FA_ASSET_HISTORY_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
, AH.ASSET_TYPE
, AH.CATEGORY_ID
, TH.TRANSACTION_NAME COMMENTS
FROM FA_ADDITIONS AD
, FA_LOOKUPS LO
, FA_ASSET_HISTORY AH
, 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) 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
, AH.ASSET_TYPE
, AH.CATEGORY_ID
, TH.TRANSACTION_NAME COMMENTS
FROM FA_ADDITIONS AD
, FA_LOOKUPS LO
, FA_ASSET_HISTORY AH
, 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 AH.TRANSACTION_HEADER_ID_OUT IS NOT NULL

Columns