VIEW: APPS.CE_SYSTEM_PARAMETERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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