VIEW: APPS.CE_SYSTEM_PARAMETERS_MRC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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