View: CE_SYSTEM_PARAMETERS

View Text

SELECT SET_OF_BOOKS_ID
, CASHBOOK_BEGIN_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, SHOW_CLEARED_FLAG
, INTERFACE_PURGE_FLAG
, INTERFACE_ARCHIVE_FLAG
, LINE_AUTOCREATION_FLAG
, ENABLE_OPEN_INTERFACE_FLAG
, AMOUNT_TOLERANCE
, PERCENT_TOLERANCE
, RECEIVABLES_TRX_ID
, DIFFERENCES_ACCOUNT
, FOREIGN_DIFFERENCE_HANDLING
, FLOAT_HANDLING_FLAG
, LINES_PER_COMMIT
, ORG_ID
, AP_MATCHING_ORDER
, AR_MATCHING_ORDER
, OPEN_INTERFACE_FLOAT_STATUS
, OPEN_INTERFACE_CLEAR_STATUS
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SHOW_VOID_PAYMENT_FLAG
, OPEN_INTERFACE_MATCHING_CODE
, EXCHANGE_RATE_TYPE
, EXCHANGE_RATE_DATE
FROM CE_SYSTEM_PARAMETERS_ALL
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)

Columns