Product: | OKX - Contracts Integration |
---|---|
Description: | This view retrieves details of all the assets in all the books fro Oracle Fixed Assets. |
Implementation/DBA Data: | APPS.OKX_AST_BKS_V |
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')