VIEW: OKL.OKL_SYS_ACCT_OPTS_ALL#

Source

View Text - Preformatted

select ID ID, CC_REP_CURRENCY_CODE CC_REP_CURRENCY_CODE, CODE_COMBINATION_ID CODE_COMBINATION_ID, AEL_REP_CURRENCY_CODE AEL_REP_CURRENCY_CODE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, REC_CCID REC_CCID, REALIZED_GAIN_CCID REALIZED_GAIN_CCID, REALIZED_LOSS_CCID REALIZED_LOSS_CCID, CC_APPLY_ROUNDING_DIFFERENCE CC_APPLY_ROUNDING_DIFFERENCE, AEL_APPLY_ROUNDING_DIFFERENCE AEL_APPLY_ROUNDING_DIFFERENCE, TAX_CCID TAX_CCID, CROSS_CURRENCY_CCID CROSS_CURRENCY_CCID, ROUNDING_CCID ROUNDING_CCID, AR_CLEARING_CCID AR_CLEARING_CCID, PAYABLES_CCID PAYABLES_CCID, LIABLITY_CCID LIABLITY_CCID, PRE_PAYMENT_CCID PRE_PAYMENT_CCID, FUT_DATE_PAY_CCID FUT_DATE_PAY_CCID, CC_ROUNDING_RULE CC_ROUNDING_RULE, CC_PRECISION CC_PRECISION, CC_MIN_ACCT_UNIT CC_MIN_ACCT_UNIT, DIS_TAKEN_CCID DIS_TAKEN_CCID, AP_CLEARING_CCID AP_CLEARING_CCID, AEL_ROUNDING_RULE AEL_ROUNDING_RULE, AEL_PRECISION AEL_PRECISION, AEL_MIN_ACCT_UNIT AEL_MIN_ACCT_UNIT, ACCRUAL_REVERSAL_DAYS ACCRUAL_REVERSAL_DAYS, LKE_HOLD_DAYS LKE_HOLD_DAYS, ORG_ID ORG_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, STM_APPLY_ROUNDING_DIFFERENCE STM_APPLY_ROUNDING_DIFFERENCE, STM_ROUNDING_RULE STM_ROUNDING_RULE, VALIDATE_KHR_START_DATE VALIDATE_KHR_START_DATE, ACCOUNT_DERIVATION ACCOUNT_DERIVATION, ISG_ARREARS_PAY_DATES_OPTION ISG_ARREARS_PAY_DATES_OPTION, PAY_DIST_SET_ID PAY_DIST_SET_ID, SECONDARY_REP_METHOD SECONDARY_REP_METHOD, AMORT_INC_ADJ_REV_DT_YN AMORT_INC_ADJ_REV_DT_YN from "OKL"."OKL_SYS_ACCT_OPTS_ALL"

View Text - HTML Formatted

SELECT ID ID
, CC_REP_CURRENCY_CODE CC_REP_CURRENCY_CODE
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, AEL_REP_CURRENCY_CODE AEL_REP_CURRENCY_CODE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REC_CCID REC_CCID
, REALIZED_GAIN_CCID REALIZED_GAIN_CCID
, REALIZED_LOSS_CCID REALIZED_LOSS_CCID
, CC_APPLY_ROUNDING_DIFFERENCE CC_APPLY_ROUNDING_DIFFERENCE
, AEL_APPLY_ROUNDING_DIFFERENCE AEL_APPLY_ROUNDING_DIFFERENCE
, TAX_CCID TAX_CCID
, CROSS_CURRENCY_CCID CROSS_CURRENCY_CCID
, ROUNDING_CCID ROUNDING_CCID
, AR_CLEARING_CCID AR_CLEARING_CCID
, PAYABLES_CCID PAYABLES_CCID
, LIABLITY_CCID LIABLITY_CCID
, PRE_PAYMENT_CCID PRE_PAYMENT_CCID
, FUT_DATE_PAY_CCID FUT_DATE_PAY_CCID
, CC_ROUNDING_RULE CC_ROUNDING_RULE
, CC_PRECISION CC_PRECISION
, CC_MIN_ACCT_UNIT CC_MIN_ACCT_UNIT
, DIS_TAKEN_CCID DIS_TAKEN_CCID
, AP_CLEARING_CCID AP_CLEARING_CCID
, AEL_ROUNDING_RULE AEL_ROUNDING_RULE
, AEL_PRECISION AEL_PRECISION
, AEL_MIN_ACCT_UNIT AEL_MIN_ACCT_UNIT
, ACCRUAL_REVERSAL_DAYS ACCRUAL_REVERSAL_DAYS
, LKE_HOLD_DAYS LKE_HOLD_DAYS
, ORG_ID ORG_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, STM_APPLY_ROUNDING_DIFFERENCE STM_APPLY_ROUNDING_DIFFERENCE
, STM_ROUNDING_RULE STM_ROUNDING_RULE
, VALIDATE_KHR_START_DATE VALIDATE_KHR_START_DATE
, ACCOUNT_DERIVATION ACCOUNT_DERIVATION
, ISG_ARREARS_PAY_DATES_OPTION ISG_ARREARS_PAY_DATES_OPTION
, PAY_DIST_SET_ID PAY_DIST_SET_ID
, SECONDARY_REP_METHOD SECONDARY_REP_METHOD
, AMORT_INC_ADJ_REV_DT_YN AMORT_INC_ADJ_REV_DT_YN
FROM "OKL"."OKL_SYS_ACCT_OPTS_ALL"