ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 8E2FF36EDE9079D2E0530100007F1FF2 FND Currency Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code US 91D3167A335F1204E053BB6B63585EE3 GL Currency Conversion Type Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by 1 US FFCAA08B1F170584E0530100007F74DDY 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 :Upload_mode = 'C' or ( (:From_Currency is not null or :To_Currency is not null) and :From_Date is not null and :To_Date is not null ) A 6 xxen_gl_upload.insert_gl_daily_rates_intf xxen_gl_upload.do_daily_rate_import US GL Daily Rates Upload GL Daily Rates Upload ================== Use this upload to upload new or update existing GL Daily Exchange Rate Conversions. If exchange rates do not already exist for the entered data, they will be created. If exchange rates do already exist for the entered data, they will be updated. In Download Mode please specify a From and/or To Currency and a From/To Date Range Enginatics Upload 1=1 :p_upload_mode :p_user_conv_type 1 -10 1=1 :p_action=:p_action LOV custom Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'GL_CRM_DR_MODE_FLAG' and flvv.view_application_id = 101 order by value select flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type = 'GL_CRM_DR_MODE_FLAG' and flvv.view_application_id = 101 and flvv.lookup_code='I' Y US Action 2 10 :p_upload_mode LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 3 15 1=1 :p_user_conv_type=:p_user_conv_type LOV GL Currency Conversion Type 91D3167A335F1204E053BB6B63585EE3 Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by 1 US Default User Conversion Type 4 20 1=1 gdr.from_currency=:p_fr_curr LOV FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code US From Currency 5 30 1=1 gdr.to_currency=:p_to_curr LOV FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code US To Currency 6 40 1=1 gdct.user_conversion_type=:p_rate_type LOV GL Currency Conversion Type 91D3167A335F1204E053BB6B63585EE3 Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by 1 US Conversion Type 7 50 1=1 gdr.conversion_date>=trunc(:p_fr_date) Date US From Date 8 60 1=1 gdr.conversion_date<trunc(:p_to_date)+1 Date US To Date 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 ROW_ID Char varchar2 Y 7 FROM_CURRENCY LOV custom varchar2 15 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' and sysdate between nvl(fcv.start_date_active, sysdate) and nvl(fcv.end_date_active, sysdate) and fcv.currency_code <> 'STAT' and (fcv.derive_type <> 'EMU' or fcv.derive_type is null) order by fcv.currency_code Y 8 TO_CURRENCY LOV custom varchar2 15 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' and sysdate between nvl(fcv.start_date_active, sysdate) and nvl(fcv.end_date_active, sysdate) and fcv.currency_code <> 'STAT' and (fcv.derive_type <> 'EMU' or fcv.derive_type is null) and fcv.currency_code != :$column$.from_currency order by fcv.currency_code Y 9 USER_CONVERSION_TYPE LOV custom varchar2 30 Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct where gdct.conversion_type <> 'User' and gdct.conversion_type <> 'EMU FIXED' order by gdct.user_conversion_type :$flex$.default_user_conversion_type Y 10 FROM_CONVERSION_DATE Date date Y 11 TO_CONVERSION_DATE Date date Y 12 CONVERSION_RATE Number number Y 13 INVERSE_CONVERSION_RATE Number number Only enter an inverse rate when profile 'Daily Rates Window: Enforce Inverse Relationship During Entry' is set to No. It will be ignored otherwise 14 ATTRIBUTE_CONTEXT LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 15 GL_DAILY_RATE_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE1' 16 GL_DAILY_RATE_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE2' 17 GL_DAILY_RATE_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE3' 18 GL_DAILY_RATE_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE4' 19 GL_DAILY_RATE_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE5' 20 GL_DAILY_RATE_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE6' 21 GL_DAILY_RATE_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE7' 22 GL_DAILY_RATE_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE8' 23 GL_DAILY_RATE_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE9' 24 GL_DAILY_RATE_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE10' 25 GL_DAILY_RATE_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE11' 26 GL_DAILY_RATE_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE12' 27 GL_DAILY_RATE_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE13' 28 GL_DAILY_RATE_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE14' 29 GL_DAILY_RATE_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 101, p_descriptive_flexfield_name => 'GL_DAILY_RATES', p_context_name => :$column$.attribute_context, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.gl_daily_rate_attribute1, p_attribute2 => :$column$.gl_daily_rate_attribute2, p_attribute3 => :$column$.gl_daily_rate_attribute3, p_attribute4 => :$column$.gl_daily_rate_attribute4, p_attribute5 => :$column$.gl_daily_rate_attribute5, p_attribute6 => :$column$.gl_daily_rate_attribute6, p_attribute7 => :$column$.gl_daily_rate_attribute7, p_attribute8 => :$column$.gl_daily_rate_attribute8, p_attribute9 => :$column$.gl_daily_rate_attribute9, p_attribute10 => :$column$.gl_daily_rate_attribute10, p_attribute11 => :$column$.gl_daily_rate_attribute11, p_attribute12 => :$column$.gl_daily_rate_attribute12, p_attribute13 => :$column$.gl_daily_rate_attribute13, p_attribute14 => :$column$.gl_daily_rate_attribute14, p_attribute15 => :$column$.gl_daily_rate_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 101 and fdfv.descriptive_flexfield_name = 'GL_DAILY_RATES' and fdfcuv.application_column_name = 'ATTRIBUTE15' 30 CREATED_BY LOV Oracle varchar2 100 FND_USERS Y select user_id id, user_name value, null description from fnd_user order by user_name select user_id id, user_name value, null description from fnd_user fnd_global.user_name Y 31 CREATION_DATE DateTime date Y 32 BATCH_NUMBER Char varchar2 Y 33 MODE_FLAG LOV custom varchar2 Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'GL_CRM_DR_MODE_FLAG' and flvv.view_application_id = 101 order by value select flvv.lookup_code id, flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type = 'GL_CRM_DR_MODE_FLAG' and flvv.view_application_id = 101 :$flex$.Action Y Y 34 LAUNCH_RATE_CHANGE LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y 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 GL_DAILY_RATE_ATTRIBUTE1 U 10 p_attribute2 in Char GL_DAILY_RATE_ATTRIBUTE2 U 11 p_attribute3 in Char GL_DAILY_RATE_ATTRIBUTE3 U 12 p_attribute4 in Char GL_DAILY_RATE_ATTRIBUTE4 U 13 p_attribute5 in Char GL_DAILY_RATE_ATTRIBUTE5 U 14 p_attribute6 in Char GL_DAILY_RATE_ATTRIBUTE6 U 15 p_attribute7 in Char GL_DAILY_RATE_ATTRIBUTE7 U 16 p_attribute8 in Char GL_DAILY_RATE_ATTRIBUTE8 U 17 p_attribute9 in Char GL_DAILY_RATE_ATTRIBUTE9 U 18 p_attribute10 in Char GL_DAILY_RATE_ATTRIBUTE10 U 19 p_attribute11 in Char GL_DAILY_RATE_ATTRIBUTE11 U 20 p_attribute12 in Char GL_DAILY_RATE_ATTRIBUTE12 U 21 p_attribute13 in Char GL_DAILY_RATE_ATTRIBUTE13 U 22 p_attribute14 in Char GL_DAILY_RATE_ATTRIBUTE14 U 23 p_attribute15 in Char GL_DAILY_RATE_ATTRIBUTE15 U 24 p_user_id in Number CREATED_BY 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_ P 1 p_batch_number in Char BATCH_NUMBER P 2 request_id_ out Number REQUEST_ID_ P 3 status_ out Char STATUS_CODE_ P 4 message_ out Char MESSAGE_ Error SQL select xu.action_, xxen_upload.status_meaning(xxen_upload.status_error) status_, nvl(case gdri.error_code when 'NONEXISTANT_CONVERSION_TYPE' then fnd_message.get_string('SQLGL','CRM0007') when 'DATE_RANGE_TOO_LARGE' then fnd_message.get_string('SQLGL','CRM0008') when 'NEGATIVE_CONVERSION_RATE' then fnd_message.get_string('SQLGL','CRM0009') when 'NEGATIVE_INVERSE_RATE' then fnd_message.get_string('SQLGL','CRM0010') when 'NONEXISTANT_FROM_CURRENCY' then fnd_message.get_string('SQLGL','CRM0011') when 'DISABLED_FROM_CURRENCY' then fnd_message.get_string('SQLGL','CRM0012') when 'STATISTICAL_FROM_CURRENCY' then fnd_message.get_string('SQLGL','CRM0013') when 'OUT_OF_DATE_FROM_CURRENCY' then fnd_message.get_string('SQLGL','CRM0014') when 'EMU_FROM_CURRENCY' then fnd_message.get_string('SQLGL','CRM0015') when 'NONEXISTANT_TO_CURRENCY' then fnd_message.get_string('SQLGL','CRM0016') when 'DISABLED_TO_CURRENCY' then fnd_message.get_string('SQLGL','CRM0017') when 'STATISTICAL_TO_CURRENCY' then fnd_message.get_string('SQLGL','CRM0018') when 'OUT_OF_DATE_TO_CURRENCY' then fnd_message.get_string('SQLGL','CRM0019') when 'EMU_TO_CURRENCY' then fnd_message.get_string('SQLGL','CRM0020') when 'DUPLICATE_ROWS' then fnd_message.get_string('SQLGL','CRM0044') else gdri.error_code end ,xu.message_ ) message_, xu.request_id_, xu.modified_columns_, xu.row_id, nvl(gdri.from_currency,xu.from_currency) from_currency, nvl(gdri.to_currency,xu.to_currency) to_currency, nvl(gdri.user_conversion_type,xu.user_conversion_type) user_conversion_type, nvl(gdri.from_conversion_date,xu.from_conversion_date) from_conversion_date, nvl(gdri.to_conversion_date,xu.to_conversion_date) to_conversion_date, nvl(gdri.conversion_rate,to_number(xu.conversion_rate)) conversion_rate, nvl(gdri.inverse_conversion_rate,to_number(xu.inverse_conversion_rate)) inverse_conversion_rate, nvl(gdri.context,xu.attribute_context) attribute_context, nvl(gdri.attribute1,xu.gl_daily_rate_attribute1) gl_daily_rate_attribute1, nvl(gdri.attribute2,xu.gl_daily_rate_attribute2) gl_daily_rate_attribute2, nvl(gdri.attribute3,xu.gl_daily_rate_attribute3) gl_daily_rate_attribute3, nvl(gdri.attribute4,xu.gl_daily_rate_attribute4) gl_daily_rate_attribute4, nvl(gdri.attribute5,xu.gl_daily_rate_attribute5) gl_daily_rate_attribute5, nvl(gdri.attribute6,xu.gl_daily_rate_attribute6) gl_daily_rate_attribute6, nvl(gdri.attribute7,xu.gl_daily_rate_attribute7) gl_daily_rate_attribute7, nvl(gdri.attribute8,xu.gl_daily_rate_attribute8) gl_daily_rate_attribute8, nvl(gdri.attribute9,xu.gl_daily_rate_attribute9) gl_daily_rate_attribute9, nvl(gdri.attribute10,xu.gl_daily_rate_attribute10) gl_daily_rate_attribute10, nvl(gdri.attribute11,xu.gl_daily_rate_attribute11) gl_daily_rate_attribute11, nvl(gdri.attribute12,xu.gl_daily_rate_attribute12) gl_daily_rate_attribute12, nvl(gdri.attribute13,xu.gl_daily_rate_attribute13) gl_daily_rate_attribute13, nvl(gdri.attribute14,xu.gl_daily_rate_attribute14) gl_daily_rate_attribute14, nvl(gdri.attribute15,xu.gl_daily_rate_attribute15) gl_daily_rate_attribute15, nvl(fu.user_name,xu.created_by) created_by, xu.creation_date, gdri.batch_number, nvl(xxen_util.meaning(gdri.mode_flag,'GL_CRM_DR_MODE_FLAG',101),xu.mode_flag) mode_flag, nvl(gdri.launch_rate_change,xu.launch_rate_change) launch_rate_change from gl_daily_rates_interface gdri, fnd_user fu, xxen_gl_daily_rates_upl_7392_u xu where chartorowid(xu.row_id) = gdri.rowid (+) and gdri.user_id = fu.user_id (+) and (nvl(xu.status_code_,xxen_upload.status_error) != xxen_upload.status_success or nvl(gdri.error_code,'null') != 'null' ) Order By from_currency, to_currency, user_conversion_type, from_conversion_date, to_conversion_date Success SQL select xxen_upload.action_meaning(xxen_upload.action_update) action_, xxen_upload.status_meaning(xxen_upload.status_success) status_, 'Loaded' message_, xu.request_id_, xu.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, xu.batch_number, xu.mode_flag mode_flag, xu.launch_rate_change from xxen_gl_daily_rates_upl_7392_u xu, gl_daily_rates gdr, gl_daily_conversion_types gdct, fnd_user fu where xu.status_code_=xxen_upload.status_success and xu.from_currency=gdr.from_currency and xu.to_currency=gdr.to_currency and gdr.conversion_date between xu.from_conversion_date and xu.to_conversion_date and xxen_util.user_id(xu.created_by)=gdr.created_by and xu.user_conversion_type=gdct.user_conversion_type and chartorowid(xu.row_id) not in (select gdri.rowid from gl_daily_rates_interface gdri where gdri.error_code is not null) and gdr.conversion_type=gdct.conversion_type and gdr.created_by=fu.user_id