ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 492CFDBB26F16F4FE0630100007F99AE select null action_, null status_, null message_, to_number(null) request_id_, null modified_columns_, to_number(null) manufacturer_row_id, -- mm.manufacturer_name manufacturer, mm.description manufacturer_description, null delete_manufacturer, (select count(*) from mtl_mfg_part_numbers mmpn where mmpn.manufacturer_id = mm.manufacturer_id) mfg_part_number_count, -- xxen_util.display_flexfield_context(401,'MTL_MANUFACTURERS',mm.attribute_category) manufacturer_attribute_categry, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE1',mm.rowid,mm.attribute1) manufacturer_attribute1, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE2',mm.rowid,mm.attribute2) manufacturer_attribute2, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE3',mm.rowid,mm.attribute3) manufacturer_attribute3, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE4',mm.rowid,mm.attribute4) manufacturer_attribute4, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE5',mm.rowid,mm.attribute5) manufacturer_attribute5, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE6',mm.rowid,mm.attribute6) manufacturer_attribute6, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE7',mm.rowid,mm.attribute7) manufacturer_attribute7, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE8',mm.rowid,mm.attribute8) manufacturer_attribute8, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE9',mm.rowid,mm.attribute9) manufacturer_attribute9, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE10',mm.rowid,mm.attribute10) manufacturer_attribute10, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE11',mm.rowid,mm.attribute11) manufacturer_attribute11, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE12',mm.rowid,mm.attribute12) manufacturer_attribute12, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE13',mm.rowid,mm.attribute13) manufacturer_attribute13, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE14',mm.rowid,mm.attribute14) manufacturer_attribute14, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE15',mm.rowid,mm.attribute15) manufacturer_attribute15, mm.manufacturer_id, to_number(null) upload_row from mtl_manufacturers mm where :p_upload_mode like '%' || xxen_upload.action_update and 1=1 Y U A xxen_inv_upload.upload_manufacturer US INV Manufacturer Upload INV Manufacturer Upload ====================== This upload can be used to create, update and delete Manufacturers. Enginatics Upload 1=1 :p_upload_mode 1 10 :p_upload_mode LOV custom 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 union all select xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 1=1 mm.manufacturer_id = :p_mfg_id LOV custom Y select manufacturer_id id, manufacturer_name value, description description from mtl_manufacturers order by value, description US Manufacturer 3 30 1=1 mm.manufacturer_name >= :p_mfg_from LOV custom Y select manufacturer_name value, description description from mtl_manufacturers order by value, description US Manufacturer From 4 40 1=1 mm.manufacturer_name <= :p_mfg_to LOV custom Y select manufacturer_name value, description description from mtl_manufacturers order by value, description :$flex$.Manufacturer_From US Manufacturer To :$flex$.Manufacturer_From Manufacturer From Manufacturer To 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Number number Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 MANUFACTURER_ROW_ID Number number Y Y 7 MANUFACTURER Char varchar2 Y 8 MANUFACTURER_DESCRIPTION Char varchar2 9 DELETE_MANUFACTURER LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 10 MFG_PART_NUMBER_COUNT Number number Informational only. Shows the number of Manufacturing Part Numbers are defined for this manufacturuer. 11 MANUFACTURER_ATTRIBUTE_CATEGRY 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 fdfv.descriptive_flexfield_name='MTL_MANUFACTURERS' and fdfv.application_id=401 and fdfv.application_id=fdfcv.application_id and fdfv.descriptive_flexfield_name=fdfcv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 12 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE1' 13 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE2' 14 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE3' 15 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE4' 16 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE5' 17 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE6' 18 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE7' 19 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE8' 20 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE9' 21 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE10' 22 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE11' 23 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE12' 24 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE13' 25 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE14' 26 MANUFACTURER_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 => 401, p_descriptive_flexfield_name => 'MTL_MANUFACTURERS', p_context_name => :$column$.manufacturer_attribute_categry, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.manufacturer_attribute1, p_attribute2 => :$column$.manufacturer_attribute2, p_attribute3 => :$column$.manufacturer_attribute3, p_attribute4 => :$column$.manufacturer_attribute4, p_attribute5 => :$column$.manufacturer_attribute5, p_attribute6 => :$column$.manufacturer_attribute6, p_attribute7 => :$column$.manufacturer_attribute7, p_attribute8 => :$column$.manufacturer_attribute8, p_attribute9 => :$column$.manufacturer_attribute9, p_attribute10 => :$column$.manufacturer_attribute10, p_attribute11 => :$column$.manufacturer_attribute11, p_attribute12 => :$column$.manufacturer_attribute12, p_attribute13 => :$column$.manufacturer_attribute13, p_attribute14 => :$column$.manufacturer_attribute14, p_attribute15 => :$column$.manufacturer_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 401 and dff.application_table_name = 'MTL_MANUFACTURERS' and dffcu.application_column_name = 'ATTRIBUTE15' 27 MANUFACTURER_ID Number number Y Y 28 UPLOAD_ROW Number number Y Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 request_id_ out Number REQUEST_ID_ U 5 p_manufacturer_row_id in/out Char MANUFACTURER_ROW_ID U 6 p_manufacturer in Char Y MANUFACTURER U 7 p_description in Char Y MANUFACTURER_DESCRIPTION U 8 p_delete_manufacturer in Char Y DELETE_MANUFACTURER U 9 p_attribute_category in Char Y MANUFACTURER_ATTRIBUTE_CATEGRY U 10 p_attribute1 in Char Y MANUFACTURER_ATTRIBUTE1 U 11 p_attribute2 in Char Y MANUFACTURER_ATTRIBUTE1 U 12 p_attribute3 in Char Y MANUFACTURER_ATTRIBUTE3 U 13 p_attribute4 in Char Y MANUFACTURER_ATTRIBUTE4 U 14 p_attribute5 in Char Y MANUFACTURER_ATTRIBUTE5 U 15 p_attribute6 in Char Y MANUFACTURER_ATTRIBUTE6 U 16 p_attribute7 in Char Y MANUFACTURER_ATTRIBUTE7 U 17 p_attribute8 in Char Y MANUFACTURER_ATTRIBUTE8 U 18 p_attribute9 in Char Y MANUFACTURER_ATTRIBUTE9 U 19 p_attribute10 in Char Y MANUFACTURER_ATTRIBUTE10 U 20 p_attribute11 in Char Y MANUFACTURER_ATTRIBUTE11 U 21 p_attribute12 in Char Y MANUFACTURER_ATTRIBUTE12 U 22 p_attribute13 in Char Y MANUFACTURER_ATTRIBUTE13 U 23 p_attribute14 in Char Y MANUFACTURER_ATTRIBUTE14 U 24 p_attribute15 in Char Y MANUFACTURER_ATTRIBUTE15 U 25 p_manufacturer_id in Number Y MANUFACTURER_ID Error SQL Order By upload_row, manufacturer Success SQL select xu.action_, xu.status_, case when mm.creation_date >= fcr.actual_start_date then 'Manufacturer Created' when mm.last_update_date >= fcr.actual_start_date then 'Manufacturer Updated' when xxen_util.lookup_code(xu.delete_manufacturer,'YES_NO',0)='Y' and xu.manufacturer_row_id is not null and mm.manufacturer_id is null then 'Manufacturer Deleted' end message_, xu.request_id_, null modified_columns_, xu.manufacturer_row_id, -- nvl(mm.manufacturer_name,xu.manufacturer) manufacturer, nvl(mm.description,xu.manufacturer_description) manufacturer_description, xu.delete_manufacturer, (select count(*) from mtl_mfg_part_numbers mmpn where mmpn.manufacturer_id = mm.manufacturer_id) mfg_part_number_count, -- xxen_util.display_flexfield_context(401,'MTL_MANUFACTURERS',mm.attribute_category) manufacturer_attribute_category, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE1',mm.rowid,mm.attribute1) manufacturer_attribute1, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE2',mm.rowid,mm.attribute2) manufacturer_attribute2, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE3',mm.rowid,mm.attribute3) manufacturer_attribute3, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE4',mm.rowid,mm.attribute4) manufacturer_attribute4, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE5',mm.rowid,mm.attribute5) manufacturer_attribute5, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE6',mm.rowid,mm.attribute6) manufacturer_attribute6, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE7',mm.rowid,mm.attribute7) manufacturer_attribute7, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE8',mm.rowid,mm.attribute8) manufacturer_attribute8, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE9',mm.rowid,mm.attribute9) manufacturer_attribute9, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE10',mm.rowid,mm.attribute10) manufacturer_attribute10, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE11',mm.rowid,mm.attribute11) manufacturer_attribute11, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE12',mm.rowid,mm.attribute12) manufacturer_attribute12, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE13',mm.rowid,mm.attribute13) manufacturer_attribute13, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE14',mm.rowid,mm.attribute14) manufacturer_attribute14, xxen_util.display_flexfield_value(401,'MTL_MANUFACTURERS',mm.attribute_category,'ATTRIBUTE15',mm.rowid,mm.attribute15) manufacturer_attribute15, mm.manufacturer_id, xu.upload_row from xxen_inv_manufacturer_u_5685_u xu, mtl_manufacturers mm, fnd_concurrent_requests fcr where xu.status_code_=xxen_upload.status_success and xu.request_id_ = fcr.request_id and to_number(xu.manufacturer_row_id) = mm.manufacturer_id (+) LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE1 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE10 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE11 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE12 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE13 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE14 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE15 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE2 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE3 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE4 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE5 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE6 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE7 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE8 LOV query :$column$.manufacturer_attribute1 MANUFACTURER_ATTRIBUTE1 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute10 MANUFACTURER_ATTRIBUTE10 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute11 MANUFACTURER_ATTRIBUTE11 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute12 MANUFACTURER_ATTRIBUTE12 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute13 MANUFACTURER_ATTRIBUTE13 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute14 MANUFACTURER_ATTRIBUTE14 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute15 MANUFACTURER_ATTRIBUTE15 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute2 MANUFACTURER_ATTRIBUTE2 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute3 MANUFACTURER_ATTRIBUTE3 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute4 MANUFACTURER_ATTRIBUTE4 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute5 MANUFACTURER_ATTRIBUTE5 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute6 MANUFACTURER_ATTRIBUTE6 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute7 MANUFACTURER_ATTRIBUTE7 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute8 MANUFACTURER_ATTRIBUTE8 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute9 MANUFACTURER_ATTRIBUTE9 MANUFACTURER_ATTRIBUTE9 LOV query :$column$.manufacturer_attribute_categry MANUFACTURER_ATTRIBUTE_CATEGRY MANUFACTURER_ATTRIBUTE9