VIEW: FA.FA_MC_BOOK_CONTROLS#

Source

View Text - Preformatted

select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, BOOK_TYPE_CODE BOOK_TYPE_CODE, CURRENCY_CODE CURRENCY_CODE, DEPRN_STATUS DEPRN_STATUS, DEPRN_REQUEST_ID DEPRN_REQUEST_ID, LAST_PERIOD_COUNTER LAST_PERIOD_COUNTER, LAST_DEPRN_RUN_DATE LAST_DEPRN_RUN_DATE, CURRENT_FISCAL_YEAR CURRENT_FISCAL_YEAR, RETIRED_STATUS RETIRED_STATUS, RETIRED_REQUEST_ID RETIRED_REQUEST_ID, PRIMARY_SET_OF_BOOKS_ID PRIMARY_SET_OF_BOOKS_ID, PRIMARY_CURRENCY_CODE PRIMARY_CURRENCY_CODE, SOURCE_RETIRED_STATUS SOURCE_RETIRED_STATUS, SOURCE_RETIRED_REQUEST_ID SOURCE_RETIRED_REQUEST_ID, MRC_CONVERTED_FLAG MRC_CONVERTED_FLAG, ENABLED_FLAG ENABLED_FLAG, NBV_AMOUNT_THRESHOLD NBV_AMOUNT_THRESHOLD, CONVERSION_STATUS CONVERSION_STATUS, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MASS_REQUEST_ID MASS_REQUEST_ID, ALLOW_IMPAIRMENT_FLAG ALLOW_IMPAIRMENT_FLAG, GL_POSTING_ALLOWED_FLAG GL_POSTING_ALLOWED_FLAG from "FA"."FA_MC_BOOK_CONTROLS"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, BOOK_TYPE_CODE BOOK_TYPE_CODE
, CURRENCY_CODE CURRENCY_CODE
, DEPRN_STATUS DEPRN_STATUS
, DEPRN_REQUEST_ID DEPRN_REQUEST_ID
, LAST_PERIOD_COUNTER LAST_PERIOD_COUNTER
, LAST_DEPRN_RUN_DATE LAST_DEPRN_RUN_DATE
, CURRENT_FISCAL_YEAR CURRENT_FISCAL_YEAR
, RETIRED_STATUS RETIRED_STATUS
, RETIRED_REQUEST_ID RETIRED_REQUEST_ID
, PRIMARY_SET_OF_BOOKS_ID PRIMARY_SET_OF_BOOKS_ID
, PRIMARY_CURRENCY_CODE PRIMARY_CURRENCY_CODE
, SOURCE_RETIRED_STATUS SOURCE_RETIRED_STATUS
, SOURCE_RETIRED_REQUEST_ID SOURCE_RETIRED_REQUEST_ID
, MRC_CONVERTED_FLAG MRC_CONVERTED_FLAG
, ENABLED_FLAG ENABLED_FLAG
, NBV_AMOUNT_THRESHOLD NBV_AMOUNT_THRESHOLD
, CONVERSION_STATUS CONVERSION_STATUS
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MASS_REQUEST_ID MASS_REQUEST_ID
, ALLOW_IMPAIRMENT_FLAG ALLOW_IMPAIRMENT_FLAG
, GL_POSTING_ALLOWED_FLAG GL_POSTING_ALLOWED_FLAG
FROM "FA"."FA_MC_BOOK_CONTROLS"