FND Design Data [Home] [Help]

View: CE_SYSTEM_PARAMETERS_MRC_V

Product: CE - Cash Management
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.CE_SYSTEM_PARAMETERS_MRC_V
View Text

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

Columns

Name
SET_OF_BOOKS_ID
CASHBOOK_BEGIN_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
SHOW_CLEARED_FLAG
AMOUNT_TOLERANCE
PERCENT_TOLERANCE
RECEIVABLES_TRX_ID
DIFFERENCES_ACCOUNT
LINES_PER_COMMIT
ORG_ID
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
INTERFACE_PURGE_FLAG
INTERFACE_ARCHIVE_FLAG
LINE_AUTOCREATION_FLAG
FOREIGN_DIFFERENCE_HANDLING
AP_MATCHING_ORDER
AR_MATCHING_ORDER
ENABLE_OPEN_INTERFACE_FLAG
OPEN_INTERFACE_FLOAT_STATUS
OPEN_INTERFACE_CLEAR_STATUS
FLOAT_HANDLING_FLAG
SHOW_VOID_PAYMENT_FLAG
OPEN_INTERFACE_MATCHING_CODE
EXCHANGE_RATE_TYPE
EXCHANGE_RATE_DATE