View: OKL_LIKE_KIND_EXCHANGE_V

Product:	OKL - Lease and Finance Management
Description:	OKL_LINE_KIND_EXCHANGE_V will retrieve data necessary for performing Like Kind Exchange.
Implementation/DBA Data:	APPS.OKL_LIKE_KIND_EXCHANGE_V

View Text

SELECT FAD.ASSET_ID ASSET_ID
, FAD.ASSET_NUMBER ASSET_NUMBER
, FAB.BOOK_TYPE_CODE BOOK_TYPE_CODE
, FBC.BOOK_CLASS BOOK_CLASS
, FBC.ORG_ID ORG_ID
, FBC.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, FAB.DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, FADTL.DESCRIPTION DESCRIPTION
, FAD.TAG_NUMBER TAG_NUMBER
, FAD.SERIAL_NUMBER SERIAL_NUMBER
, FAD.ASSET_KEY_CCID ASSET_KEY_CCID
, FAD.PARENT_ASSET_ID PARENT_ASSET_ID
, FAD.MANUFACTURER_NAME MANUFACTURER_NAME
, FAD.MODEL_NUMBER MODEL_NUMBER
, FAD.LEASE_ID LEASE_ID
, FAD.IN_USE_FLAG IN_USE_FLAG
, FAD.INVENTORIAL INVENTORIAL
, FAD.PROPERTY_TYPE_CODE PROPERTY_TYPE_CODE
, FAD.PROPERTY_1245_1250_CODE PROPERTY_1245_1250_CODE
, FAD.OWNED_LEASED OWNED_LEASED
, FAD.NEW_USED NEW_USED
, FAD.CURRENT_UNITS CURRENT_UNITS
, FAD.ASSET_TYPE ASSET_TYPE
, FAD.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, FAB.DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, FAB.LIFE_IN_MONTHS LIFE_IN_MONTHS
, FAB.COST COST
, FAB.ADJUSTED_COST ADJUSTED_COST
, FAB.ORIGINAL_COST ORIGINAL_COST
, FAB.RECOVERABLE_COST RECOVERABLE_COST
, FAB.SALVAGE_VALUE SALVAGE_VALUE
, FAB.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, FAB.PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE
, FAB.DEPRECIATE_FLAG DEPRECIATE_FLAG
, FAB.ITC_AMOUNT_ID ITC_AMOUNT_ID
, FAB.BASIC_RATE BASIC_RATE
, FAB.ADJUSTED_RATE ADJUSTED_RATE
, FAB.BONUS_RULE BONUS_RULE
, FAB.CEILING_NAME CEILING_NAME
, FAB.PRODUCTION_CAPACITY PRODUCTION_CAPACITY
, FAB.UNIT_OF_MEASURE UNIT_OF_MEASURE
, FAB.REVAL_CEILING REVAL_CEILING
, FAB.UNREVALUED_COST UNREVALUED_COST
, FAB.SHORT_FISCAL_YEAR_FLAG SHORT_FISCAL_YEAR_FLAG
, FAB.CONVERSION_DATE CONVERSION_DATE
, FAB.ORIGINAL_DEPRN_START_DATE ORIGINAL_DEPRN_START_DATE
, FAB.GROUP_ASSET_ID GROUP_ASSET_ID
, FAR.COST_RETIRED COST_RETIRED
, FAR.UNITS UNITS
, FAR.NBV_RETIRED NBV_RETIRED
, FAR.GAIN_LOSS_AMOUNT GAIN_LOSS_AMOUNT
, FAR.PROCEEDS_OF_SALE PROCEEDS_OF_SALE
, FAR.DATE_RETIRED DATE_RETIRED
, OKLAR.KLE_ID KLE_ID
FROM FA_ADDITIONS_TL FADTL
, FA_ADDITIONS_B FAD
, FA_BOOK_CONTROLS FBC
, FA_BOOKS FAB
, OKC_K_ITEMS CIM
, OKC_K_LINES_B FA_LINE
, OKC_LINE_STYLES_B FA_LSE
, OKL_ASSET_RETURNS_ALL_B OKLAR
, OKL_SYS_ACCT_OPTS OKLSYS
, FA_RETIREMENTS FAR
WHERE FADTL.ASSET_ID = FAD.ASSET_ID
AND FADTL.LANGUAGE = USERENV('LANG')
AND FAD.ASSET_ID = FAR.ASSET_ID
AND FBC.BOOK_TYPE_CODE = FAB.BOOK_TYPE_CODE
AND NVL(FBC.DATE_INEFFECTIVE
, SYSDATE+1) > SYSDATE
AND FAB.BOOK_TYPE_CODE = FAR.BOOK_TYPE_CODE
AND FAB.ASSET_ID = FAR.ASSET_ID
AND FAB.TRANSACTION_HEADER_ID_OUT IS NULL
AND CIM.OBJECT1_ID1 = TO_CHAR(FAR.ASSET_ID)
AND CIM.OBJECT1_ID2 = '#'
AND CIM.JTOT_OBJECT1_CODE = 'OKX_ASSET'
AND CIM.CLE_ID = FA_LINE.ID
AND CIM.DNZ_CHR_ID = FA_LINE.DNZ_CHR_ID
AND FA_LINE.LSE_ID = FA_LSE.ID
AND FA_LSE.LTY_CODE = 'FIXED_ASSET'
AND FA_LINE.CLE_ID = OKLAR.KLE_ID
AND OKLAR.LIKE_KIND_YN = 'Y'
AND FAR.DATE_RETIRED BETWEEN (SYSDATE-OKLSYS.LKE_HOLD_DAYS)
AND SYSDATE
AND FAR.STATUS = 'PROCESSED'

Columns