MSC_AP_GL_CONVERSION_TYPES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
CONVERSION_TYPE USER_CONVERSION_TYPE DEFAULT_FLAG DESCRIPTION PIVOT_CURRENCY_CODE ROW_ID

Query

SQL_Statement
SELECT CONVERSION_TYPE, USER_CONVERSION_TYPE, DECODE( gsu.default_conversion_type,null,2,1) DEFAULT_FLAG, DESCRIPTION, PIVOT_CURRENCY_CODE, gdct.rowid ROW_ID FROM GL_DAILY_CONVERSION_TYPES gdct, GL_SYSTEM_USAGES gsu where gsu.default_conversion_type(+) = gdct.CONVERSION_TYPE