VIEW: APPS.OKL_LIKE_KIND_EXCHANGE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'