VIEW: APPS.OKX_ASSETS_V

Source

View Text - Preformatted

SELECT 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 DEPR_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 = 'CORPORATE' 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 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 DEPR_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 = 'CORPORATE'
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')