VIEW: APPS.OKL_AM_OFF_LEASE_TRX_UV

Source

View Text - Preformatted

SELECT TALB.ROWID ROW_ID, TALB.ID TAL_ID, TASB.TAS_TYPE TAS_TYPE, FL1.MEANING TAS_TYPE_MEANING, TALB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TALT.SFWT_FLAG SFWT_FLAG, TALB.TAS_ID TAS_ID, TALB.ILO_ID ILO_ID, TALB.ILO_ID_OLD ILO_ID_OLD, TALB.IAY_ID IAY_ID, FACAT.DESCRIPTION FA_CATEGORY_DESCRIPTION, TALB.IAY_ID_NEW IAY_ID_NEW, TALB.KLE_ID KLE_ID, TALB.DNZ_KHR_ID DNZ_KHR_ID, HDR.CONTRACT_NUMBER CONTRACT_NUMBER, TALB.LINE_NUMBER LINE_NUMBER, TALB.ORG_ID ORG_ID, TALB.TAL_TYPE TAL_TYPE, TALB.ASSET_NUMBER ASSET_NUMBER, TALT.DESCRIPTION DESCRIPTION, TALB.FA_LOCATION_ID FA_LOCATION_ID, TALB.ORIGINAL_COST ORIGINAL_COST, TALB.CURRENT_UNITS CURRENT_UNITS, TALB.MANUFACTURER_NAME MANUFACTURER_NAME, TALB.YEAR_MANUFACTURED YEAR_MANUFACTURED, TALB.SUPPLIER_ID SUPPLIER_ID, TALB.USED_ASSET_YN USED_ASSET_YN, TALB.TAG_NUMBER TAG_NUMBER, TALB.MODEL_NUMBER MODEL_NUMBER, TALB.DATE_PURCHASED DATE_PURCHASED, TALB.DATE_DELIVERY DATE_DELIVERY, TALB.IN_SERVICE_DATE IN_SERVICE_DATE, TALB.LIFE_IN_MONTHS LIFE_IN_MONTHS, TALB.DEPRECIATION_ID DEPRECIATION_ID, TALB.DEPRECIATION_COST DEPRECIATION_COST, TALB.DEPRN_METHOD DEPRN_METHOD, FAMET.NAME DEPRN_METHOD_NAME, TALB.DEPRN_RATE DEPRN_RATE, TALB.SALVAGE_VALUE SALVAGE_VALUE, TALB.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE, TALB.DATE_DUE DATE_DUE, TALB.CREATED_BY CREATED_BY, TALB.CREATION_DATE CREATION_DATE, TALB.LAST_UPDATED_BY LAST_UPDATED_BY, TALB.LAST_UPDATE_DATE LAST_UPDATE_DATE, TALB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TALB.DEPRECIATE_YN DEPRECIATE_YN, TALB.HOLD_PERIOD_DAYS HOLD_PERIOD_DAYS, TALB.OLD_SALVAGE_VALUE OLD_SALVAGE_VALUE, TALB.NEW_RESIDUAL_VALUE NEW_RESIDUAL_VALUE, TALB.OLD_RESIDUAL_VALUE OLD_RESIDUAL_VALUE, TALB.UNITS_RETIRED UNITS_RETIRED, TALB.COST_RETIRED COST_RETIRED, TALB.SALE_PROCEEDS SALE_PROCEEDS, TALB.REMOVAL_COST REMOVAL_COST, TALB.DNZ_ASSET_ID DNZ_ASSET_ID, TASB.TSU_CODE TSU_CODE, FL2.MEANING TSU_CODE_MEANING, TASB.TRY_ID TRY_ID, TASB.DATE_TRANS_OCCURRED DATE_TRANS_OCCURRED, DECODE(TXDB.TAX_BOOK,NULL, TALB.CORPORATE_BOOK,TXDB.TAX_BOOK ) ASSET_BOOK, FBC.BOOK_CLASS ASSET_BOOK_TYPE FROM OKL_TRX_ASSETS TASB,OKL_TXL_ASSETS_B TALB,OKL_TXL_ASSETS_TL TALT,FA_CATEGORIES_VL FACAT,FND_LOOKUPS FL1,FND_LOOKUPS FL2,FA_METHODS FAMET,OKC_K_HEADERS_B HDR,OKL_TXD_ASSETS_B TXDB,FA_BOOK_CONTROLS FBC WHERE TALB.ID = TALT.ID AND TALB.DNZ_KHR_ID = HDR.ID AND TALT.LANGUAGE = USERENV('LANG') AND TASB.ID = TALB.TAS_ID AND TASB.TAS_TYPE in ('AMT','AUD','AUS') AND TALB.IAY_ID = FACAT.CATEGORY_ID (+) AND FL1.LOOKUP_CODE = TASB.TAS_TYPE AND FL1.LOOKUP_TYPE = 'OKL_TRANS_HEADER_TYPE' AND FL2.LOOKUP_CODE = TASB.TSU_CODE AND FL2.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS' AND TALB.DEPRECIATION_ID = FAMET.METHOD_ID (+) AND TALB.ID = TXDB.TAL_ID(+) AND DECODE(TXDB.TAX_BOOK,NULL,TALB.CORPORATE_BOOK,TXDB.TAX_BOOK ) = FBC.BOOK_TYPE_CODE

View Text - HTML Formatted

SELECT TALB.ROWID ROW_ID
, TALB.ID TAL_ID
, TASB.TAS_TYPE TAS_TYPE
, FL1.MEANING TAS_TYPE_MEANING
, TALB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TALT.SFWT_FLAG SFWT_FLAG
, TALB.TAS_ID TAS_ID
, TALB.ILO_ID ILO_ID
, TALB.ILO_ID_OLD ILO_ID_OLD
, TALB.IAY_ID IAY_ID
, FACAT.DESCRIPTION FA_CATEGORY_DESCRIPTION
, TALB.IAY_ID_NEW IAY_ID_NEW
, TALB.KLE_ID KLE_ID
, TALB.DNZ_KHR_ID DNZ_KHR_ID
, HDR.CONTRACT_NUMBER CONTRACT_NUMBER
, TALB.LINE_NUMBER LINE_NUMBER
, TALB.ORG_ID ORG_ID
, TALB.TAL_TYPE TAL_TYPE
, TALB.ASSET_NUMBER ASSET_NUMBER
, TALT.DESCRIPTION DESCRIPTION
, TALB.FA_LOCATION_ID FA_LOCATION_ID
, TALB.ORIGINAL_COST ORIGINAL_COST
, TALB.CURRENT_UNITS CURRENT_UNITS
, TALB.MANUFACTURER_NAME MANUFACTURER_NAME
, TALB.YEAR_MANUFACTURED YEAR_MANUFACTURED
, TALB.SUPPLIER_ID SUPPLIER_ID
, TALB.USED_ASSET_YN USED_ASSET_YN
, TALB.TAG_NUMBER TAG_NUMBER
, TALB.MODEL_NUMBER MODEL_NUMBER
, TALB.DATE_PURCHASED DATE_PURCHASED
, TALB.DATE_DELIVERY DATE_DELIVERY
, TALB.IN_SERVICE_DATE IN_SERVICE_DATE
, TALB.LIFE_IN_MONTHS LIFE_IN_MONTHS
, TALB.DEPRECIATION_ID DEPRECIATION_ID
, TALB.DEPRECIATION_COST DEPRECIATION_COST
, TALB.DEPRN_METHOD DEPRN_METHOD
, FAMET.NAME DEPRN_METHOD_NAME
, TALB.DEPRN_RATE DEPRN_RATE
, TALB.SALVAGE_VALUE SALVAGE_VALUE
, TALB.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, TALB.DATE_DUE DATE_DUE
, TALB.CREATED_BY CREATED_BY
, TALB.CREATION_DATE CREATION_DATE
, TALB.LAST_UPDATED_BY LAST_UPDATED_BY
, TALB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TALB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TALB.DEPRECIATE_YN DEPRECIATE_YN
, TALB.HOLD_PERIOD_DAYS HOLD_PERIOD_DAYS
, TALB.OLD_SALVAGE_VALUE OLD_SALVAGE_VALUE
, TALB.NEW_RESIDUAL_VALUE NEW_RESIDUAL_VALUE
, TALB.OLD_RESIDUAL_VALUE OLD_RESIDUAL_VALUE
, TALB.UNITS_RETIRED UNITS_RETIRED
, TALB.COST_RETIRED COST_RETIRED
, TALB.SALE_PROCEEDS SALE_PROCEEDS
, TALB.REMOVAL_COST REMOVAL_COST
, TALB.DNZ_ASSET_ID DNZ_ASSET_ID
, TASB.TSU_CODE TSU_CODE
, FL2.MEANING TSU_CODE_MEANING
, TASB.TRY_ID TRY_ID
, TASB.DATE_TRANS_OCCURRED DATE_TRANS_OCCURRED
, DECODE(TXDB.TAX_BOOK
, NULL
, TALB.CORPORATE_BOOK
, TXDB.TAX_BOOK ) ASSET_BOOK
, FBC.BOOK_CLASS ASSET_BOOK_TYPE
FROM OKL_TRX_ASSETS TASB
, OKL_TXL_ASSETS_B TALB
, OKL_TXL_ASSETS_TL TALT
, FA_CATEGORIES_VL FACAT
, FND_LOOKUPS FL1
, FND_LOOKUPS FL2
, FA_METHODS FAMET
, OKC_K_HEADERS_B HDR
, OKL_TXD_ASSETS_B TXDB
, FA_BOOK_CONTROLS FBC
WHERE TALB.ID = TALT.ID
AND TALB.DNZ_KHR_ID = HDR.ID
AND TALT.LANGUAGE = USERENV('LANG')
AND TASB.ID = TALB.TAS_ID
AND TASB.TAS_TYPE IN ('AMT'
, 'AUD'
, 'AUS')
AND TALB.IAY_ID = FACAT.CATEGORY_ID (+)
AND FL1.LOOKUP_CODE = TASB.TAS_TYPE
AND FL1.LOOKUP_TYPE = 'OKL_TRANS_HEADER_TYPE'
AND FL2.LOOKUP_CODE = TASB.TSU_CODE
AND FL2.LOOKUP_TYPE = 'OKL_TRANSACTION_STATUS'
AND TALB.DEPRECIATION_ID = FAMET.METHOD_ID (+)
AND TALB.ID = TXDB.TAL_ID(+)
AND DECODE(TXDB.TAX_BOOK
, NULL
, TALB.CORPORATE_BOOK
, TXDB.TAX_BOOK ) = FBC.BOOK_TYPE_CODE