Product: | CE - Cash Management |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CE_SYSTEM_PARAMETERS_V |
SELECT CSP.ROWID ROW_ID
, CSP.SET_OF_BOOKS_ID
, SOB.NAME
, SOB.SHORT_NAME SHORT_NAME
, SOB.CURRENCY_CODE
, CSP.CASHBOOK_BEGIN_DATE
, CSP.SHOW_CLEARED_FLAG
, CSP.LINES_PER_COMMIT
, CSP.LINE_AUTOCREATION_FLAG
, CSP.INTERFACE_PURGE_FLAG
, CSP.INTERFACE_ARCHIVE_FLAG
, CSP.CREATED_BY
, CSP.CREATION_DATE
, CSP.LAST_UPDATED_BY
, CSP.LAST_UPDATE_DATE
, CSP.LAST_UPDATE_LOGIN
, CSP.ATTRIBUTE_CATEGORY
, CSP.ATTRIBUTE1
, CSP.ATTRIBUTE2
, CSP.ATTRIBUTE3
, CSP.ATTRIBUTE4
, CSP.ATTRIBUTE5
, CSP.ATTRIBUTE6
, CSP.ATTRIBUTE7
, CSP.ATTRIBUTE8
, CSP.ATTRIBUTE9
, CSP.ATTRIBUTE10
, CSP.ATTRIBUTE11
, CSP.ATTRIBUTE12
, CSP.ATTRIBUTE13
, CSP.ATTRIBUTE14
, CSP.ATTRIBUTE15
, CSP.SHOW_VOID_PAYMENT_FLAG
, CSP.LEGAL_ENTITY_ID
, CSP.CASHFLOW_EXCHANGE_RATE_TYPE
, GL.USER_CONVERSION_TYPE CASHFLOW_XRATE_TYPE_DSP
, CSP.AUTHORIZATION_BAT
, CSP.BSC_EXCHANGE_DATE_TYPE
, CSP.BAT_EXCHANGE_DATE_TYPE
, CSP.SIGNING_AUTHORITY_APPR_FLAG
FROM CE_SYSTEM_PARAMETERS CSP
, GL_SETS_OF_BOOKS SOB
, GL_DAILY_CONVERSION_TYPES GL
WHERE SOB.SET_OF_BOOKS_ID = CSP.SET_OF_BOOKS_ID
AND CSP.CASHFLOW_EXCHANGE_RATE_TYPE = GL.CONVERSION_TYPE (+)
AND CSP.LEGAL_ENTITY_ID IS NOT NULL