VIEW: APPS.OKL_TAX_BK_ASSETS_V

Source

View Text - Preformatted

SELECT TO_CHAR(fa.asset_id) id1, '#' id2, fa.asset_number NAME, fat.description description, fa.asset_id asset_id, fa.asset_number asset_number, fb.book_type_code book_type_code, fb.life_in_months life_in_months, fb.original_cost original_cost, fb.COST COST, fb.adjusted_cost adjusted_cost, fa.tag_number tag_number, fa.current_units current_units, fa.serial_number serial_number, fb.reval_ceiling reval_ceiling, fa.new_used new_used, fb.date_placed_in_service in_service_date, fa.manufacturer_name manufacturer_name, fa.model_number model_number, fa.asset_type asset_type, fb.salvage_value salvage_value, fb.percent_salvage_value percent_salvage_value, fa.asset_category_id depreciation_category, fb.deprn_start_date DEPRN_START_DATE, fb.deprn_method_code deprn_method_code, fb.rate_adjustment_factor rate_adjustment_factor, fb.basic_rate basic_rate, fb.adjusted_rate adjusted_rate, fb.date_effective start_date_active, fb.date_ineffective end_date_active, DECODE (SIGN ( TRUNC (SYSDATE) - NVL (fb.date_effective, TRUNC (SYSDATE))), -1, 'I', DECODE (SIGN ( TRUNC (SYSDATE) - NVL (fb.date_ineffective, TRUNC (SYSDATE))), 1, 'I', 'A ' ) ) status, NULL primary_uom_code, fb.recoverable_cost recoverable_cost, fbc.org_id org_id, fbc.set_of_books_id set_of_books_id, fa.property_type_code property_type_code, fa.property_1245_1250_code property_1245_1250_code, fa.in_use_flag in_use_flag, fa.owned_leased owned_leased, fa.inventorial inventorial FROM fa_book_controls fbc, fa_books fb, fa_additions_tl fat, fa_additions_b fa WHERE fbc.book_type_code = fb.book_type_code AND NVL (fbc.date_ineffective, SYSDATE + 1) > SYSDATE AND fbc.book_class = 'TAX' AND fb.asset_id = fa.asset_id AND fb.transaction_header_id_out IS NULL AND fat.asset_id = fa.asset_id AND fat.LANGUAGE = USERENV ('LANG')

View Text - HTML Formatted

SELECT TO_CHAR(FA.ASSET_ID) ID1
, '#' ID2
, FA.ASSET_NUMBER NAME
, FAT.DESCRIPTION DESCRIPTION
, FA.ASSET_ID ASSET_ID
, FA.ASSET_NUMBER ASSET_NUMBER
, FB.BOOK_TYPE_CODE BOOK_TYPE_CODE
, FB.LIFE_IN_MONTHS LIFE_IN_MONTHS
, FB.ORIGINAL_COST ORIGINAL_COST
, FB.COST COST
, FB.ADJUSTED_COST ADJUSTED_COST
, FA.TAG_NUMBER TAG_NUMBER
, FA.CURRENT_UNITS CURRENT_UNITS
, FA.SERIAL_NUMBER SERIAL_NUMBER
, FB.REVAL_CEILING REVAL_CEILING
, FA.NEW_USED NEW_USED
, FB.DATE_PLACED_IN_SERVICE IN_SERVICE_DATE
, FA.MANUFACTURER_NAME MANUFACTURER_NAME
, FA.MODEL_NUMBER MODEL_NUMBER
, FA.ASSET_TYPE ASSET_TYPE
, FB.SALVAGE_VALUE SALVAGE_VALUE
, FB.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, FA.ASSET_CATEGORY_ID DEPRECIATION_CATEGORY
, FB.DEPRN_START_DATE DEPRN_START_DATE
, FB.DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, FB.RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR
, FB.BASIC_RATE BASIC_RATE
, FB.ADJUSTED_RATE ADJUSTED_RATE
, FB.DATE_EFFECTIVE START_DATE_ACTIVE
, FB.DATE_INEFFECTIVE END_DATE_ACTIVE
, DECODE (SIGN ( TRUNC (SYSDATE) - NVL (FB.DATE_EFFECTIVE
, TRUNC (SYSDATE)))
, -1
, 'I'
, DECODE (SIGN ( TRUNC (SYSDATE) - NVL (FB.DATE_INEFFECTIVE
, TRUNC (SYSDATE)))
, 1
, 'I'
, 'A ' ) ) STATUS
, NULL PRIMARY_UOM_CODE
, FB.RECOVERABLE_COST RECOVERABLE_COST
, FBC.ORG_ID ORG_ID
, FBC.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, FA.PROPERTY_TYPE_CODE PROPERTY_TYPE_CODE
, FA.PROPERTY_1245_1250_CODE PROPERTY_1245_1250_CODE
, FA.IN_USE_FLAG IN_USE_FLAG
, FA.OWNED_LEASED OWNED_LEASED
, FA.INVENTORIAL INVENTORIAL
FROM FA_BOOK_CONTROLS FBC
, FA_BOOKS FB
, FA_ADDITIONS_TL FAT
, FA_ADDITIONS_B FA
WHERE FBC.BOOK_TYPE_CODE = FB.BOOK_TYPE_CODE
AND NVL (FBC.DATE_INEFFECTIVE
, SYSDATE + 1) > SYSDATE
AND FBC.BOOK_CLASS = 'TAX'
AND FB.ASSET_ID = FA.ASSET_ID
AND FB.TRANSACTION_HEADER_ID_OUT IS NULL
AND FAT.ASSET_ID = FA.ASSET_ID
AND FAT.LANGUAGE = USERENV ('LANG')