Product: | CE - Cash Management |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CE_SYSTEM_PARAMETERS_MRC_V |
SELECT SET_OF_BOOKS_ID /*NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99)*/
, CE.CASHBOOK_BEGIN_DATE
, CE.CREATED_BY
, CE.CREATION_DATE
, CE.LAST_UPDATED_BY
, CE.LAST_UPDATE_DATE
, CE.SHOW_CLEARED_FLAG
, CE.AMOUNT_TOLERANCE_OLD
, CE.PERCENT_TOLERANCE_OLD
, CE.RECEIVABLES_TRX_ID_OLD
, CE.DIFFERENCES_ACCOUNT_OLD
, CE.LINES_PER_COMMIT
, CE.ORG_ID_OLD
, CE.LAST_UPDATE_LOGIN
, CE.ATTRIBUTE_CATEGORY
, CE.ATTRIBUTE1
, CE.ATTRIBUTE2
, CE.ATTRIBUTE3
, CE.ATTRIBUTE4
, CE.ATTRIBUTE5
, CE.ATTRIBUTE6
, CE.ATTRIBUTE7
, CE.ATTRIBUTE8
, CE.ATTRIBUTE9
, CE.ATTRIBUTE10
, CE.ATTRIBUTE11
, CE.ATTRIBUTE12
, CE.ATTRIBUTE13
, CE.ATTRIBUTE14
, CE.ATTRIBUTE15
, CE.INTERFACE_PURGE_FLAG
, CE.INTERFACE_ARCHIVE_FLAG
, CE.LINE_AUTOCREATION_FLAG
, CE.FX_DIFFERENCE_HANDLING_OLD
, CE.AP_MATCHING_ORDER_OLD
, CE.AR_MATCHING_ORDER_OLD
, CE.ENABLE_OPEN_INTERFACE_FLAG_OLD
, CE.OI_FLOAT_STATUS_OLD
, CE.OI_CLEAR_STATUS_OLD
, CE.FLOAT_HANDLING_FLAG_OLD
, SHOW_VOID_PAYMENT_FLAG
, CE.OI_MATCHING_CODE_OLD
, CE.EXCHANGE_RATE_TYPE_OLD
, CE.EXCHANGE_RATE_DATE_OLD
FROM CE_SYSTEM_PARAMETERS CE