VIEW: APPS.FA_ASSET_HISTORY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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