VIEW: APPS.OKL_TAX_BK_TRX_ASSTS_V

Source

View Text - Preformatted

SELECT cle.ID id1, '#' id2, fa.NAME NAME, fa.description description, tl.item_description item_description, tl.comments comments, cle.chr_id chr_id, cle.dnz_chr_id dnz_chr_id, ls.lty_code lty_code, ls.lse_type lse_type, ls.lse_parent_id lse_parent_id, cle.cle_id parent_line_id, cle.line_number line_number, cle.date_terminated date_terminated, fa.asset_id asset_id, fa.current_units quantity, cim.uom_code unit_of_measure_code, fa.asset_number asset_number, fa.tax_book tax_book, fa.life_in_months life_in_months, fa.COST COST, fa.adjusted_cost adjusted_cost, fa.tag_number tag_number, fa.current_units current_units, fa.serial_number serial_number, fa.reval_ceiling reval_ceiling, fa.new_used new_used, fa.in_service_date in_service_date, fa.manufacturer_name manufacturer_name, fa.model_number model_number, fa.asset_type asset_type, fa.salvage_value salvage_value, fa.percent_salvage_value percent_salvage_value, fa.depreciation_category depreciation_category, fa.deprn_start_date deprn_start_date, fa.deprn_method_code deprn_method_code, fa.rate_adjustment_factor rate_adjustment_factor, fa.basic_rate basic_rate, fa.adjusted_rate adjusted_rate, cle.start_date start_date_active, cle.end_date end_date_active, fa.status status, fa.recoverable_cost recoverable_cost, fa.org_id org_id, fa.set_of_books_id set_of_books_id, fa.property_1245_1250_code property_1245_1250_code, fa.property_type_code property_type_code, fa.in_use_flag in_use_flag, fa.owned_leased owned_leased, fa.inventorial inventorial, cle.sts_code line_status FROM okl_tax_bk_assets_v fa, okl_k_headers khr, okc_k_lines_b cle, okc_k_lines_tl tl, okc_line_styles_b ls, okc_k_items cim WHERE khr.ID = cle.dnz_chr_id AND tl.ID = cle.ID AND tl.LANGUAGE = USERENV ('LANG') AND ls.ID = cle.lse_id AND ls.lty_code = 'FIXED_ASSET' AND cim.dnz_chr_id = cle.dnz_chr_id AND cim.cle_id = cle.ID AND cim.jtot_object1_code = 'OKX_ASSET' AND fa.id1 = cim.object1_id1 AND fa.id2 = cim.object1_id2

View Text - HTML Formatted

SELECT CLE.ID ID1
, '#' ID2
, FA.NAME NAME
, FA.DESCRIPTION DESCRIPTION
, TL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, TL.COMMENTS COMMENTS
, CLE.CHR_ID CHR_ID
, CLE.DNZ_CHR_ID DNZ_CHR_ID
, LS.LTY_CODE LTY_CODE
, LS.LSE_TYPE LSE_TYPE
, LS.LSE_PARENT_ID LSE_PARENT_ID
, CLE.CLE_ID PARENT_LINE_ID
, CLE.LINE_NUMBER LINE_NUMBER
, CLE.DATE_TERMINATED DATE_TERMINATED
, FA.ASSET_ID ASSET_ID
, FA.CURRENT_UNITS QUANTITY
, CIM.UOM_CODE UNIT_OF_MEASURE_CODE
, FA.ASSET_NUMBER ASSET_NUMBER
, FA.TAX_BOOK TAX_BOOK
, FA.LIFE_IN_MONTHS LIFE_IN_MONTHS
, FA.COST COST
, FA.ADJUSTED_COST ADJUSTED_COST
, FA.TAG_NUMBER TAG_NUMBER
, FA.CURRENT_UNITS CURRENT_UNITS
, FA.SERIAL_NUMBER SERIAL_NUMBER
, FA.REVAL_CEILING REVAL_CEILING
, FA.NEW_USED NEW_USED
, FA.IN_SERVICE_DATE IN_SERVICE_DATE
, FA.MANUFACTURER_NAME MANUFACTURER_NAME
, FA.MODEL_NUMBER MODEL_NUMBER
, FA.ASSET_TYPE ASSET_TYPE
, FA.SALVAGE_VALUE SALVAGE_VALUE
, FA.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, FA.DEPRECIATION_CATEGORY DEPRECIATION_CATEGORY
, FA.DEPRN_START_DATE DEPRN_START_DATE
, FA.DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, FA.RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR
, FA.BASIC_RATE BASIC_RATE
, FA.ADJUSTED_RATE ADJUSTED_RATE
, CLE.START_DATE START_DATE_ACTIVE
, CLE.END_DATE END_DATE_ACTIVE
, FA.STATUS STATUS
, FA.RECOVERABLE_COST RECOVERABLE_COST
, FA.ORG_ID ORG_ID
, FA.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, FA.PROPERTY_1245_1250_CODE PROPERTY_1245_1250_CODE
, FA.PROPERTY_TYPE_CODE PROPERTY_TYPE_CODE
, FA.IN_USE_FLAG IN_USE_FLAG
, FA.OWNED_LEASED OWNED_LEASED
, FA.INVENTORIAL INVENTORIAL
, CLE.STS_CODE LINE_STATUS
FROM OKL_TAX_BK_ASSETS_V FA
, OKL_K_HEADERS KHR
, OKC_K_LINES_B CLE
, OKC_K_LINES_TL TL
, OKC_LINE_STYLES_B LS
, OKC_K_ITEMS CIM
WHERE KHR.ID = CLE.DNZ_CHR_ID
AND TL.ID = CLE.ID
AND TL.LANGUAGE = USERENV ('LANG')
AND LS.ID = CLE.LSE_ID
AND LS.LTY_CODE = 'FIXED_ASSET'
AND CIM.DNZ_CHR_ID = CLE.DNZ_CHR_ID
AND CIM.CLE_ID = CLE.ID
AND CIM.JTOT_OBJECT1_CODE = 'OKX_ASSET'
AND FA.ID1 = CIM.OBJECT1_ID1
AND FA.ID2 = CIM.OBJECT1_ID2