Product: | OKX - Contracts Integration |
---|---|
Description: | Source View for Fixed Asset Line in Oracle Contracts for lease. |
Implementation/DBA Data: | APPS.OKX_ASSETS_V |
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')