VIEW: APPS.OKX_AST_CT_BK_DFS_V

Source

View Text - Preformatted

SELECT FACBD.CATEGORY_ID ID1, FACBD.BOOK_TYPE_CODE||','||TO_CHAR(START_DPIS,'DD-MON-YYYY HH24:MI:SS') ID2, '#' NAME, '#' DESCRIPTION, FACBD.CATEGORY_ID CATEGORY_ID, FACBD.BOOK_TYPE_CODE BOOK_TYPE_CODE, FACBD.START_DPIS START_DPIS, FACBD.END_DPIS END_DPIS, FACBD.LIFE_IN_MONTHS LIFE_IN_MONTHS, FACBD.DEPRN_METHOD DEPRN_METHOD, FACBD.PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE, FACBD.ITC_ELIGIBLE_FLAG ITC_ELIGIBLE_FLAG, FACBD.USE_ITC_CEILINGS_FLAG USE_ITC_CEILINGS_FLAG, FACBD.CEILING_NAME CEILING_NAME, FACBD.BASIC_RATE BASIC_RATE, FACBD.ADJUSTED_RATE ADJUSTED_RATE, FACBD.BONUS_RULE BONUS_RULE, FACBD.DEPRECIATE_FLAG DEPRECIATE_FLAG, FACBD.RETIREMENT_PRORATE_CONVENTION RETIREMENT_PRORATE_CONVENTION, FACBD.PRICE_INDEX_NAME PRICE_INDEX_NAME, FACBD.USE_STL_RETIREMENTS_FLAG USE_STL_RETIREMENTS_FLAG, FACBD.STL_METHOD_CODE STL_METHOD_CODE, FACBD.STL_LIFE_IN_MONTHS STL_LIFE_IN_MONTHS, FACBD.SUBCOMPONENT_LIFE_RULE SUBCOMPONENT_LIFE_RULE, FACBD.MINIMUM_LIFE_IN_MONTHS MINIMUM_LIFE_IN_MONTHS, FACBD.PRODUCTION_CAPACITY PRODUCTION_CAPACITY, FACBD.UNIT_OF_MEASURE UNIT_OF_MEASURE, FACBD.CAPITAL_GAIN_THRESHOLD CAPITAL_GAIN_THRESHOLD, FACBD.USE_DEPRN_LIMITS_FLAG USE_DEPRN_LIMITS_FLAG, FACBD.ALLOWED_DEPRN_LIMIT ALLOWED_DEPRN_LIMIT, FACBD.SPECIAL_DEPRN_LIMIT_AMOUNT SPECIAL_DEPRN_LIMIT_AMOUNT, FACBD.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE, FACBD.CUA_LIFE_END_DATE CUA_LIFE_END_DATE, FACBD.CUA_RULE_SET_ID CUA_RULE_SET_ID FROM FA_CATEGORY_BOOK_DEFAULTS FACBD

View Text - HTML Formatted

SELECT FACBD.CATEGORY_ID ID1
, FACBD.BOOK_TYPE_CODE||'
, '||TO_CHAR(START_DPIS
, 'DD-MON-YYYY HH24:MI:SS') ID2
, '#' NAME
, '#' DESCRIPTION
, FACBD.CATEGORY_ID CATEGORY_ID
, FACBD.BOOK_TYPE_CODE BOOK_TYPE_CODE
, FACBD.START_DPIS START_DPIS
, FACBD.END_DPIS END_DPIS
, FACBD.LIFE_IN_MONTHS LIFE_IN_MONTHS
, FACBD.DEPRN_METHOD DEPRN_METHOD
, FACBD.PRORATE_CONVENTION_CODE PRORATE_CONVENTION_CODE
, FACBD.ITC_ELIGIBLE_FLAG ITC_ELIGIBLE_FLAG
, FACBD.USE_ITC_CEILINGS_FLAG USE_ITC_CEILINGS_FLAG
, FACBD.CEILING_NAME CEILING_NAME
, FACBD.BASIC_RATE BASIC_RATE
, FACBD.ADJUSTED_RATE ADJUSTED_RATE
, FACBD.BONUS_RULE BONUS_RULE
, FACBD.DEPRECIATE_FLAG DEPRECIATE_FLAG
, FACBD.RETIREMENT_PRORATE_CONVENTION RETIREMENT_PRORATE_CONVENTION
, FACBD.PRICE_INDEX_NAME PRICE_INDEX_NAME
, FACBD.USE_STL_RETIREMENTS_FLAG USE_STL_RETIREMENTS_FLAG
, FACBD.STL_METHOD_CODE STL_METHOD_CODE
, FACBD.STL_LIFE_IN_MONTHS STL_LIFE_IN_MONTHS
, FACBD.SUBCOMPONENT_LIFE_RULE SUBCOMPONENT_LIFE_RULE
, FACBD.MINIMUM_LIFE_IN_MONTHS MINIMUM_LIFE_IN_MONTHS
, FACBD.PRODUCTION_CAPACITY PRODUCTION_CAPACITY
, FACBD.UNIT_OF_MEASURE UNIT_OF_MEASURE
, FACBD.CAPITAL_GAIN_THRESHOLD CAPITAL_GAIN_THRESHOLD
, FACBD.USE_DEPRN_LIMITS_FLAG USE_DEPRN_LIMITS_FLAG
, FACBD.ALLOWED_DEPRN_LIMIT ALLOWED_DEPRN_LIMIT
, FACBD.SPECIAL_DEPRN_LIMIT_AMOUNT SPECIAL_DEPRN_LIMIT_AMOUNT
, FACBD.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, FACBD.CUA_LIFE_END_DATE CUA_LIFE_END_DATE
, FACBD.CUA_RULE_SET_ID CUA_RULE_SET_ID
FROM FA_CATEGORY_BOOK_DEFAULTS FACBD