ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 3A356619CFF9AF04E06362FB0905EB84Y select null action_, null status_, null message_, null request_id_, null modified_columns_, null row_id, gdr.from_currency, gdr.to_currency, gdct.user_conversion_type, gdr.conversion_date from_conversion_date, gdr.conversion_date to_conversion_date, gdr.conversion_rate, 1/gdr.conversion_rate inverse_conversion_rate, xxen_util.display_flexfield_context(101,'GL_DAILY_RATES',gdr.context) attribute_context, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE1',gdr.rowid,gdr.attribute1) gl_daily_rate_attribute1, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE2',gdr.rowid,gdr.attribute2) gl_daily_rate_attribute2, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE3',gdr.rowid,gdr.attribute3) gl_daily_rate_attribute3, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE4',gdr.rowid,gdr.attribute4) gl_daily_rate_attribute4, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE5',gdr.rowid,gdr.attribute5) gl_daily_rate_attribute5, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE6',gdr.rowid,gdr.attribute6) gl_daily_rate_attribute6, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE7',gdr.rowid,gdr.attribute7) gl_daily_rate_attribute7, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE8',gdr.rowid,gdr.attribute8) gl_daily_rate_attribute8, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE9',gdr.rowid,gdr.attribute9) gl_daily_rate_attribute9, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE10',gdr.rowid,gdr.attribute10) gl_daily_rate_attribute10, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE11',gdr.rowid,gdr.attribute11) gl_daily_rate_attribute11, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE12',gdr.rowid,gdr.attribute12) gl_daily_rate_attribute12, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE13',gdr.rowid,gdr.attribute13) gl_daily_rate_attribute13, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE14',gdr.rowid,gdr.attribute14) gl_daily_rate_attribute14, xxen_util.display_flexfield_value(101,'GL_DAILY_RATES',gdr.context,'ATTRIBUTE15',gdr.rowid,gdr.attribute15) gl_daily_rate_attribute15, fu.user_name created_by, gdr.creation_date creation_date, null batch_number, xxen_util.meaning('I','GL_CRM_DR_MODE_FLAG',101) mode_flag, xxen_util.meaning('N','YES_NO',0) launch_rate_change from gl_daily_rates gdr, gl_daily_conversion_types gdct, fnd_user fu where 1=1 and :p_upload_mode like '%' || xxen_upload.action_update and nvl(:p_user_conv_type,'?') = nvl(:p_user_conv_type,'?') and gdr.conversion_type = gdct.conversion_type and gdr.created_by = fu.user_id (+) U A xxen_gl_upload.insert_gl_daily_rates_intf US Ashish test 20102501 1=1 :p_upload_mode :p_user_conv_type 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 5 MODIFIED_COLUMNS_ Char varchar2 6 ROW_ID Char varchar2 Y 7 FROM_CURRENCY Char varchar2 8 TO_CURRENCY Char varchar2 9 USER_CONVERSION_TYPE Char varchar2 10 FROM_CONVERSION_DATE Date date 11 TO_CONVERSION_DATE Date date 12 CONVERSION_RATE Number number 13 INVERSE_CONVERSION_RATE Number number 14 ATTRIBUTE_CONTEXT Char varchar2 15 GL_DAILY_RATE_ATTRIBUTE1 Char varchar2 16 GL_DAILY_RATE_ATTRIBUTE2 Char varchar2 17 GL_DAILY_RATE_ATTRIBUTE3 Char varchar2 18 GL_DAILY_RATE_ATTRIBUTE4 Char varchar2 19 GL_DAILY_RATE_ATTRIBUTE5 Char varchar2 20 GL_DAILY_RATE_ATTRIBUTE6 Char varchar2 21 GL_DAILY_RATE_ATTRIBUTE7 Char varchar2 22 GL_DAILY_RATE_ATTRIBUTE8 Char varchar2 23 GL_DAILY_RATE_ATTRIBUTE9 Char varchar2 24 GL_DAILY_RATE_ATTRIBUTE10 Char varchar2 25 GL_DAILY_RATE_ATTRIBUTE11 Char varchar2 26 GL_DAILY_RATE_ATTRIBUTE12 Char varchar2 27 GL_DAILY_RATE_ATTRIBUTE13 Char varchar2 28 GL_DAILY_RATE_ATTRIBUTE14 Char varchar2 29 GL_DAILY_RATE_ATTRIBUTE15 Char varchar2 30 CREATED_BY Char varchar2 31 CREATION_DATE Date date 32 BATCH_NUMBER Char varchar2 33 MODE_FLAG Char varchar2 34 LAUNCH_RATE_CHANGE Char varchar2 U 1 p_from_currency in Char FROM_CURRENCY U 2 p_to_currency in Char TO_CURRENCY U 3 p_from_conversion_date in Date FROM_CONVERSION_DATE U 4 p_to_conversion_date in Date TO_CONVERSION_DATE U 5 p_user_conversion_type in Char USER_CONVERSION_TYPE U 6 p_conversion_rate in Number CONVERSION_RATE U 7 p_inverse_conversion_rate in Number INVERSE_CONVERSION_RATE U 8 p_attribute_context in Char ATTRIBUTE_CONTEXT U 9 p_attribute1 in Char U 10 p_attribute2 in Char U 11 p_attribute3 in Char U 12 p_attribute4 in Char U 13 p_attribute5 in Char U 14 p_attribute6 in Char U 15 p_attribute7 in Char U 16 p_attribute8 in Char U 17 p_attribute9 in Char U 18 p_attribute10 in Char U 19 p_attribute11 in Char U 20 p_attribute12 in Char U 21 p_attribute13 in Char U 22 p_attribute14 in Char U 23 p_attribute15 in Char U 24 p_user_id in Number U 25 p_batch_number in Char BATCH_NUMBER U 26 p_mode_flag in Char MODE_FLAG U 27 p_launch_rate_change in Char LAUNCH_RATE_CHANGE U 28 p_row_id in/out Char ROW_ID U 29 request_id_ out Number REQUEST_ID_ U 30 status_ out Char STATUS_CODE_ U 31 message_ out Char MESSAGE_ Error SQL Success SQL