VIEW: APPS.OKX_ASST_BK_CONTROLS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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