View: FA_UNPLANNED_DEPR_V

Product:	OFA - Assets
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FA_UNPLANNED_DEPR_V

View Text

SELECT TH.TRANSACTION_HEADER_ID
, TH.BOOK_TYPE_CODE
, TH.ASSET_ID
, TH.TRANSACTION_TYPE_CODE
, TH.SOURCE_TRANSACTION_HEADER_ID
, TH.TRANSACTION_SUBTYPE
, AD.CODE_COMBINATION_ID
, AD.ADJUSTMENT_AMOUNT
FROM FA_TRANSACTION_HEADERS TH
, FA_ADJUSTMENTS AD
, FA_LOOKUPS LU
WHERE LU.LOOKUP_TYPE='UNPLANNED DEPRN'
AND TH.TRANSACTION_SUBTYPE=LU.LOOKUP_CODE
AND TH.TRANSACTION_HEADER_ID=AD.TRANSACTION_HEADER_ID
AND TH.TRANSACTION_TYPE_CODE='ADJUSTMENT'

Columns