VIEW: APPS.FA_ASSET_HIST_WEB_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 , 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

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
, 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