Product: | OKX - Contracts Integration |
---|---|
Description: | Contains control information that is applicable to all assets in a depreciation book. |
Implementation/DBA Data: | APPS.OKX_ASST_BK_CONTROLS_V |
SELECT BOOK_TYPE_CODE ID1
, '#' ID2
, BOOK_TYPE_CODE NAME
, BOOK_TYPE_NAME DESCRIPTION
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, INITIAL_DATE START_DATE_ACTIVE
, DATE_INEFFECTIVE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(INITIAL_DATE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(DATE_INEFFECTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL PRIMARY_UOM_CODE
, LAST_DEPRN_RUN_DATE LAST_DEPRN_RUN_DATE
, AMORTIZE_FLAG AMORTIZE_FLAG
, FULLY_RESERVED_FLAG FULLY_RESERVED_FLAG
, DEPRN_CALENDAR DEPRN_CALENDAR
, BOOK_CLASS BOOK_CLASS
, MASS_COPY_SOURCE_BOOK MASS_COPY_SOURCE_BOOK
, ORG_ID ORG_ID
, ALLOW_MASS_CHANGES ALLOW_MASS_CHANGES
, PRORATE_CALENDAR PRORATE_CALENDAR
, COPY_RETIREMENTS_FLAG COPY_RETIREMENTS_FLAG
, COPY_ADJUSTMENTS_FLAG COPY_ADJUSTMENTS_FLAG
, ALLOW_MASS_COPY ALLOW_MASS_COPY
, ALLOW_PURGE_FLAG ALLOW_PURGE_FLAG
, ALLOW_REVAL_FLAG ALLOW_REVAL_FLAG
, AMORTIZE_REVAL_RESERVE_FLAG AMORTIZE_REVAL_RESERVE_FLAG
, COPY_SALVAGE_VALUE_FLAG COPY_SALVAGE_VALUE_FLAG
, LAST_MASS_COPY_PERIOD_COUNTER LAST_MASS_COPY_PERIOD_COUNTER
, LAST_PERIOD_COUNTER LAST_PERIOD_COUNTER
, IMMEDIATE_COPY_FLAG IMMEDIATE_COPY_FLAG
, COPY_ADDITIONS_FLAG COPY_ADDITIONS_FLAG
, USE_PERCENT_SALVAGE_VALUE_FLAG USE_PERCENT_SALVAGE_VALUE_FLAG
FROM FA_BOOK_CONTROLS