Product: | OKL - Lease and Finance Management |
---|---|
Description: | System accounting options |
Implementation/DBA Data: | Not implemented in this database |
SELECT SAOB.ROWID ROW_ID
, SAOB.ID ID
, SAOB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SAOB.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SAOB.CODE_COMBINATION_ID CODE_COMBINATION_ID
, SAOB.CC_REP_CURRENCY_CODE CC_REP_CURRENCY_CODE
, SAOB.AEL_REP_CURRENCY_CODE AEL_REP_CURRENCY_CODE
, SAOB.REC_CCID REC_CCID
, SAOB.REALIZED_GAIN_CCID REALIZED_GAIN_CCID
, SAOB.REALIZED_LOSS_CCID REALIZED_LOSS_CCID
, SAOB.CC_APPLY_ROUNDING_DIFFERENCE CC_APPLY_ROUNDING_DIFFERENCE
, SAOB.AEL_APPLY_ROUNDING_DIFFERENCE AEL_APPLY_ROUNDING_DIFFERENCE
, SAOB.TAX_CCID TAX_CCID
, SAOB.CROSS_CURRENCY_CCID CROSS_CURRENCY_CCID
, SAOB.ROUNDING_CCID ROUNDING_CCID
, SAOB.AR_CLEARING_CCID AR_CLEARING_CCID
, SAOB.PAYABLES_CCID PAYABLES_CCID
, SAOB.LIABLITY_CCID LIABLITY_CCID
, SAOB.PRE_PAYMENT_CCID PRE_PAYMENT_CCID
, SAOB.FUT_DATE_PAY_CCID FUT_DATE_PAY_CCID
, SAOB.DIS_TAKEN_CCID DIS_TAKEN_CCID
, SAOB.AP_CLEARING_CCID AP_CLEARING_CCID
, SAOB.AEL_ROUNDING_RULE AEL_ROUNDING_RULE
, SAOB.AEL_PRECISION AEL_PRECISION
, SAOB.AEL_MIN_ACCT_UNIT AEL_MIN_ACCT_UNIT
, SAOB.CC_ROUNDING_RULE CC_ROUNDING_RULE
, SAOB.CC_PRECISION CC_PRECISION
, SAOB.CC_MIN_ACCT_UNIT CC_MIN_ACCT_UNIT
, SAOB.ACCRUAL_REVERSAL_DAYS ACCRUAL_REVERSAL_DAYS
, SAOB.LKE_HOLD_DAYS LKE_HOLD_DAYS
, SAOB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SAOB.ATTRIBUTE1 ATTRIBUTE1
, SAOB.ATTRIBUTE2 ATTRIBUTE2
, SAOB.ATTRIBUTE3 ATTRIBUTE3
, SAOB.ATTRIBUTE4 ATTRIBUTE4
, SAOB.ATTRIBUTE5 ATTRIBUTE5
, SAOB.ATTRIBUTE6 ATTRIBUTE6
, SAOB.ATTRIBUTE7 ATTRIBUTE7
, SAOB.ATTRIBUTE8 ATTRIBUTE8
, SAOB.ATTRIBUTE9 ATTRIBUTE9
, SAOB.ATTRIBUTE10 ATTRIBUTE10
, SAOB.ATTRIBUTE11 ATTRIBUTE11
, SAOB.ATTRIBUTE12 ATTRIBUTE12
, SAOB.ATTRIBUTE13 ATTRIBUTE13
, SAOB.ATTRIBUTE14 ATTRIBUTE14
, SAOB.ATTRIBUTE15 ATTRIBUTE15
, SAOB.ORG_ID ORG_ID
, SAOB.CREATED_BY CREATED_BY
, SAOB.CREATION_DATE CREATION_DATE
, SAOB.LAST_UPDATED_BY LAST_UPDATED_BY
, SAOB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SAOB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_SYS_ACCT_OPTS SAOB
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)