VIEW: APPS.OKX_AST_BKS_V

Source

View Text - Preformatted

SELECT fb.asset_id ID1, fb.book_type_code ID2, fa.asset_number NAME, fat.description DESCRIPTION, fb.book_type_code BOOK_TYPE_CODE, fbc.book_class BOOK_CLASS, fb.Asset_Id ASSET_ID, fa.Asset_Number ASSET_NUMBER, fa.Serial_Number SERIAL_NUMBER, fb.salvage_value SALVAGE_VALUE, fb.percent_salvage_value PERCENT_SALVAGE_VALUE, fb.life_in_months LIFE_IN_MONTHS, fb.date_placed_in_service ACQUISITION_DATE, fb.original_cost ORIGINAL_COST, fb.cost COST, fb.adjusted_cost ADJUSTED_COST, fa.tag_number TAG_NUMBER, fa.current_units CURRENT_UNITS, fb.reval_ceiling REVAL_CEILING, fa.new_used NEW_USED, fa.manufacturer_name MANUFACTURER_NAME, fa.model_number MODEL_NUMBER, fa.asset_type ASSET_TYPE, 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 FROM FA_BOOKS FB,FA_BOOK_CONTROLS FBC,FA_ADDITIONS_TL FAT,FA_ADDITIONS_B FA WHERE fb.asset_id = fa.asset_id and fb.transaction_header_id_out is null and fb.date_ineffective is null and fb.retirement_id is null and fbc.book_type_code = fb.book_type_code and fat.asset_id = fa.asset_id and fat.language = userenv('LANG')

View Text - HTML Formatted

SELECT FB.ASSET_ID ID1
, FB.BOOK_TYPE_CODE ID2
, FA.ASSET_NUMBER NAME
, FAT.DESCRIPTION DESCRIPTION
, FB.BOOK_TYPE_CODE BOOK_TYPE_CODE
, FBC.BOOK_CLASS BOOK_CLASS
, FB.ASSET_ID ASSET_ID
, FA.ASSET_NUMBER ASSET_NUMBER
, FA.SERIAL_NUMBER SERIAL_NUMBER
, FB.SALVAGE_VALUE SALVAGE_VALUE
, FB.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, FB.LIFE_IN_MONTHS LIFE_IN_MONTHS
, FB.DATE_PLACED_IN_SERVICE ACQUISITION_DATE
, FB.ORIGINAL_COST ORIGINAL_COST
, FB.COST COST
, FB.ADJUSTED_COST ADJUSTED_COST
, FA.TAG_NUMBER TAG_NUMBER
, FA.CURRENT_UNITS CURRENT_UNITS
, FB.REVAL_CEILING REVAL_CEILING
, FA.NEW_USED NEW_USED
, FA.MANUFACTURER_NAME MANUFACTURER_NAME
, FA.MODEL_NUMBER MODEL_NUMBER
, FA.ASSET_TYPE ASSET_TYPE
, 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
FROM FA_BOOKS FB
, FA_BOOK_CONTROLS FBC
, FA_ADDITIONS_TL FAT
, FA_ADDITIONS_B FA
WHERE FB.ASSET_ID = FA.ASSET_ID
AND FB.TRANSACTION_HEADER_ID_OUT IS NULL
AND FB.DATE_INEFFECTIVE IS NULL
AND FB.RETIREMENT_ID IS NULL
AND FBC.BOOK_TYPE_CODE = FB.BOOK_TYPE_CODE
AND FAT.ASSET_ID = FA.ASSET_ID
AND FAT.LANGUAGE = USERENV('LANG')