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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 2CCA4AA89822078AE06362FB09056605Y select null action_, null status_, null message_, null request_id_, null modified_columns_, :p_upload_mode upload_mode_, :p_disable_excel_validation no_excel_validation_, :p_pte_code pte_code, :p_appl_sn source_system_code, to_number(null) qualifier_rule_row_id, to_number(null) qualifier_row_id, -- Qualifier Group qqr.name rule_name, qqr.description rule_description, -- Qualifier Group DFF Attributes xxen_util.display_flexfield_context(661,'QP_QUALIFIER_RULES',qqr.context) qualifier_rule_dff_context, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE1',qqr.rowid,qqr.attribute1) qualifier_rule_attribute1, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE2',qqr.rowid,qqr.attribute2) qualifier_rule_attribute2, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE3',qqr.rowid,qqr.attribute3) qualifier_rule_attribute3, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE4',qqr.rowid,qqr.attribute4) qualifier_rule_attribute4, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE5',qqr.rowid,qqr.attribute5) qualifier_rule_attribute5, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE6',qqr.rowid,qqr.attribute6) qualifier_rule_attribute6, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE7',qqr.rowid,qqr.attribute7) qualifier_rule_attribute7, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE8',qqr.rowid,qqr.attribute8) qualifier_rule_attribute8, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE9',qqr.rowid,qqr.attribute9) qualifier_rule_attribute9, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE10',qqr.rowid,qqr.attribute10) qualifier_rule_attribute10, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE11',qqr.rowid,qqr.attribute11) qualifier_rule_attribute11, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE12',qqr.rowid,qqr.attribute12) qualifier_rule_attribute12, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE13',qqr.rowid,qqr.attribute13) qualifier_rule_attribute13, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE14',qqr.rowid,qqr.attribute14) qualifier_rule_attribute14, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE15',qqr.rowid,qqr.attribute15) qualifier_rule_attribute15, -- Qualifiers xxen_qp_upload.get_orig_sys_ref('QUALIFIER',qqv.qualifier_id) qualifier_orig_sys_ref, qqv.qualifier_grouping_no qualifier_grouping_number, qp_util.get_context('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context) qualifier_context, qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context,qqv.qualifier_attribute) qualifier_attribute, xxen_util.meaning(decode(qqv.qualify_hier_descendents_flag,'Y','Y',null),'YES_NO',0) qualifier_applies_party_hier, qqv.qualifier_precedence qualifier_precedence, qqv.comparision_operator_code qualifier_operator, rtrim(replace( qp_util.get_attribute_value ('QP_ATTR_DEFNS_QUALIFIER', qqv.qualifier_context, qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context, qqv.qualifier_attribute), qqv.qualifier_attr_value, qqv.comparision_operator_code ),chr(0),null) ) qualifier_value_from, rtrim(replace( qp_util.get_attribute_value_meaning ('QP_ATTR_DEFNS_QUALIFIER', qqv.qualifier_context, qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context, qqv.qualifier_attribute), qqv.qualifier_attr_value, qqv.comparision_operator_code ),chr(0),null) ) qualifier_value_from_desc, qp_util.get_attribute_value ('QP_ATTR_DEFNS_QUALIFIER', qqv.qualifier_context, qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context, qqv.qualifier_attribute), qqv.qualifier_attr_value_to, qqv.comparision_operator_code ) qualifier_value_to, qqv.start_date_active qualifier_start_date, qqv.end_date_active qualifier_end_date, null delete_qualifier, -- Qualifier DFF Attributes xxen_util.display_flexfield_context(661,'QP_QUALIFIERS',qqv.context) qualifier_dff_context, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE1',qqv.row_id,qqv.attribute1) qualifier_attribute1, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE2',qqv.row_id,qqv.attribute2) qualifier_attribute2, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE3',qqv.row_id,qqv.attribute3) qualifier_attribute3, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE4',qqv.row_id,qqv.attribute4) qualifier_attribute4, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE5',qqv.row_id,qqv.attribute5) qualifier_attribute5, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE6',qqv.row_id,qqv.attribute6) qualifier_attribute6, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE7',qqv.row_id,qqv.attribute7) qualifier_attribute7, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE8',qqv.row_id,qqv.attribute8) qualifier_attribute8, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE9',qqv.row_id,qqv.attribute9) qualifier_attribute9, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE10',qqv.row_id,qqv.attribute10) qualifier_attribute10, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE11',qqv.row_id,qqv.attribute11) qualifier_attribute11, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE12',qqv.row_id,qqv.attribute12) qualifier_attribute12, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE13',qqv.row_id,qqv.attribute13) qualifier_attribute13, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE14',qqv.row_id,qqv.attribute14) qualifier_attribute14, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE15',qqv.row_id,qqv.attribute15) qualifier_attribute15, -- IDs qqr.qualifier_rule_id, qqv.qualifier_id, 1 upload_row from qp_qualifier_rules qqr, qp_qualifiers_v qqv where 1=1 and :p_upload_mode like '%' || xxen_upload.action_update and qqr.qualifier_rule_id = qqv.qualifier_rule_id U A xxen_qp_upload.upload_qualifier_rule xxen_qp_upload.validate_qualifier_rule_row( :$column$.no_excel_validation_, :$column$.pte_code, :$column$.source_system_code, :$column$.rule_name, :$column$.qualifier_grouping_number, :$column$.qualifier_context, :$column$.qualifier_attribute, :$column$.qualifier_precedence, :$column$.qualifier_operator, :$column$.qualifier_value_from, :$column$.qualifier_value_from_desc, :$column$.qualifier_value_to, :$column$.qualifier_start_date, :$column$.qualifier_end_date ) US QP Qualifier Group Upload This upload supports the creation and update of Qualifier Groups in Oracle Advanced Pricing. Enginatics Upload 1=1 :p_appl_sn :p_disable_excel_validation :p_pte_code :p_upload_mode 1 -40 :p_disable_excel_validation LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Disable Excel Validation 2 -30 :p_pte_code LOV custom Y select lookup_code id, lookup_code value, null description from qp_lookups where lookup_type = 'QP_PTE_TYPE' order by value select nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'),'ORDFUL') from dual Y US Pricing Transaction Entity 3 -20 :p_appl_sn LOV custom Y select qpss.application_short_name id, qpss.application_short_name value, fav.application_name description from qp_pte_source_systems qpss, fnd_application_vl fav where qpss.application_short_name = fav.application_short_name and qpss.pte_code = :$flex$.Pricing_Transaction_Entity and qpss.enabled_flag = 'Y' order by value select fnd_profile.value('QP_SOURCE_SYSTEM_CODE') from dual Y US Source System Code 4 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,U Y US Upload Mode 5 20 1=1 qqr.qualifier_rule_id=:p_qualifier_rule LOV custom Y select qqr.qualifier_rule_id id, qqr.name value, qqr.description from qp_qualifier_rules qqr order by value US Qualifier Group 6 80 1=1 :p_effective_date between nvl(qqv.start_date_active,:p_effective_date) and nvl(qqv.end_date_active,:p_effective_date) Date sysdate US Qualifier Effective Date BF73B194EC023783354E90FE65B32139 Default SYSADMIN -.0016 COMMENTS 13 DELETE_QUALIFIER -.0003 DESCRIPTION -.0004 GLOBAL -.0002 NAME 5 QUALIFIER_ATTRIBUTE 4 QUALIFIER_CONTEXT 12 QUALIFIER_END_DATE 3 QUALIFIER_GROUPING_NUMBER 7 QUALIFIER_OPERATOR 6 QUALIFIER_PRECEDENCE 11 QUALIFIER_START_DATE 8 QUALIFIER_VALUE_FROM 9 QUALIFIER_VALUE_FROM_DESC 10 QUALIFIER_VALUE_TO 2 RULE_DESCRIPTION 1 RULE_NAME -.0001 TYPE S Site BF73B194EC023783354E90FE65B32139 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 UPLOAD_MODE_ Char varchar2 2000 Y 7 NO_EXCEL_VALIDATION_ Char varchar2 2000 :$flex$.Disable_Excel_Validation Y 8 PTE_CODE Char varchar2 2000 :$flex$.Pricing_Transaction_Entity Y Y Y 9 SOURCE_SYSTEM_CODE Char varchar2 2000 :$flex$.Source_System_Code Y Y Y 10 QUALIFIER_RULE_ROW_ID Number number Y 11 QUALIFIER_ROW_ID Number number Y 12 RULE_NAME LOV custom varchar2 240 select qqr.qualifier_rule_id id, qqr.name value, qqr.description from qp_qualifier_rules qqr order by value Y 13 RULE_DESCRIPTION Char varchar2 2000 select qqr.description from qp_qualifier_rules qqr where qqr.name = :$column$.rule_name 14 QUALIFIER_RULE_DFF_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 15 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE1' 16 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE2' 17 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE3' 18 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE4' 19 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE5' 20 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE6' 21 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE7' 22 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE8' 23 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE9' 24 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE10' 25 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE11' 26 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE12' 27 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE13' 28 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE14' 29 QUALIFIER_RULE_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIER_RULES', p_context_name => :$column$.qualifier_rule_dff_context, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.qualifier_rule_attribute1, p_attribute2 => :$column$.qualifier_rule_attribute2, p_attribute3 => :$column$.qualifier_rule_attribute3, p_attribute4 => :$column$.qualifier_rule_attribute4, p_attribute5 => :$column$.qualifier_rule_attribute5, p_attribute6 => :$column$.qualifier_rule_attribute6, p_attribute7 => :$column$.qualifier_rule_attribute7, p_attribute8 => :$column$.qualifier_rule_attribute8, p_attribute9 => :$column$.qualifier_rule_attribute9, p_attribute10 => :$column$.qualifier_rule_attribute10, p_attribute11 => :$column$.qualifier_rule_attribute11, p_attribute12 => :$column$.qualifier_rule_attribute12, p_attribute13 => :$column$.qualifier_rule_attribute13, p_attribute14 => :$column$.qualifier_rule_attribute14, p_attribute15 => :$column$.qualifier_rule_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIER_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE15' 30 QUALIFIER_ORIG_SYS_REF Char varchar2 Y Y 31 QUALIFIER_GROUPING_NUMBER Number number Y 32 QUALIFIER_CONTEXT LOV custom varchar2 Y select x.id, x.value, x.description from xmltable ('/CONTEXT/ROW' passing xxen_qp_upload.get_contexts_lov(:$column$.pte_code) columns type varchar2(240) path 'TYPE', id varchar2(240) path 'ID', value varchar2(240) path 'VALUE', description varchar2(240) path 'DESCRIPTION' ) x where x.type = 'QUALIFIER' order by value select x.id, x.value from xmltable ('/CONTEXT/ROW' passing xxen_qp_upload.get_contexts_lov(:$column$.pte_code) columns type varchar2(240) path 'TYPE', id varchar2(240) path 'ID', value varchar2(240) path 'VALUE', description varchar2(240) path 'DESCRIPTION' ) x where x.type = 'QUALIFIER' Y 33 QUALIFIER_ATTRIBUTE LOV custom varchar2 Y select x.id, x.value, x.description from xmltable ('/ATTRIBUTE/ROW' passing xxen_qp_upload.get_attributes_lov(:$column$.pte_code) columns context_type varchar2(240) path 'CONTEXT_TYPE', context_code varchar2(240) path 'CONTEXT_CODE', context_value varchar2(240) path 'CONTEXT_VALUE', id varchar2(240) path 'ID', value varchar2(240) path 'VALUE', description varchar2(240) path 'DESCRIPTION', enabled varchar2(1) path 'ENABLED', segment_level varchar2(10) path 'SEGMENT_LEVEL' ) x where x.context_type = 'QUALIFIER' and x.context_value = :$column$.qualifier_context and x.enabled = 'Y' and nvl(x.segment_level,'LINE') in ('LINE','BOTH') order by value select x.id, x.value from xmltable ('/ATTRIBUTE/ROW' passing xxen_qp_upload.get_attributes_lov(:$column$.pte_code) columns context_type varchar2(240) path 'CONTEXT_TYPE', context_code varchar2(240) path 'CONTEXT_CODE', context_value varchar2(240) path 'CONTEXT_VALUE', id varchar2(240) path 'ID', value varchar2(240) path 'VALUE', description varchar2(240) path 'DESCRIPTION', enabled varchar2(1) path 'ENABLED', segment_level varchar2(10) path 'SEGMENT_LEVEL' ) x where x.context_type = 'QUALIFIER' and x.context_value = :$column$.qualifier_context and x.enabled = 'Y' and nvl(x.segment_level,'LINE') in ('LINE','BOTH') Y 34 QUALIFIER_APPLIES_PARTY_HIER LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select lookup_code id, meaning value from fnd_lookups where fnd_lookups.lookup_type='YES_NO' Y 35 QUALIFIER_PRECEDENCE Number number xxen_qp_upload.get_attribute_info(:$column$.pte_code,'QUALIFIER',:$column$.qualifier_context,:$column$.qualifier_attribute,'PRECEDENCE') 36 QUALIFIER_OPERATOR LOV custom varchar2 30 Y select ql.lookup_code id, ql.lookup_code value, null description from qp_lookups ql where ql.lookup_type='COMPARISON_OPERATOR' order by value Y 37 QUALIFIER_VALUE_FROM LOV custom varchar2 Y Y select regexp_substr(lov.column_value,'[^^]+',1,1) id, regexp_substr(lov.column_value,'[^^]+',1,2) value, regexp_substr(lov.column_value,'[^^]+',1,3) description from table( xxen_qp_upload.attribute_value_lov ( p_pte_code => :$column$.pte_code , p_context_type => 'QUALIFIER' , p_context_value => :$column$.qualifier_context , p_attribute_value => :$column$.qualifier_attribute , p_entered_value => :$column$.qualifier_value_from , p_operator => :$column$.qualifier_operator , p_delimiter => '^' ) ) lov order by value Y 38 QUALIFIER_VALUE_FROM_DESC LOV custom varchar2 Y select regexp_substr(lov.column_value,'[^^]+',1,1) id, regexp_substr(lov.column_value,'[^^]+',1,3) value, regexp_substr(lov.column_value,'[^^]+',1,2) description from table( xxen_qp_upload.attribute_value_lov ( p_pte_code => :$column$.pte_code , p_context_type => 'QUALIFIER' , p_context_value => :$column$.qualifier_context , p_attribute_value => :$column$.qualifier_attribute , p_entered_value => :$column$.qualifier_value_from , p_operator => :$column$.qualifier_operator , p_delimiter => '^' , p_exact_match => 'Y' ) ) lov where :$column$.qualifier_value_from is not null order by value select regexp_substr(lov.column_value,'[^^]+',1,3) value from table( xxen_qp_upload.attribute_value_lov ( p_pte_code => :$column$.pte_code , p_context_type => 'QUALIFIER' , p_context_value => :$column$.qualifier_context , p_attribute_value => :$column$.qualifier_attribute , p_entered_value => :$column$.qualifier_value_from , p_operator => :$column$.qualifier_operator , p_delimiter => '^' , p_exact_match => 'Y' ) ) lov where :$column$.qualifier_value_from is not null 39 QUALIFIER_VALUE_TO Char varchar2 40 QUALIFIER_START_DATE Date date 41 QUALIFIER_END_DATE Date date 42 DELETE_QUALIFIER LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select lookup_code id, meaning value from fnd_lookups where fnd_lookups.lookup_type='YES_NO' 43 QUALIFIER_DFF_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 44 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 45 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 46 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 47 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 48 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 49 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 50 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 51 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 52 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 53 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 54 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 55 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 56 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 57 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 58 QUALIFIER_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 => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_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 = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 59 QUALIFIER_RULE_ID Number number Y 60 QUALIFIER_ID Number number Y 61 UPLOAD_ROW Number number 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 Char REQUEST_ID_ U 6 p_qualifier_rule_row_id out Number QUALIFIER_RULE_ROW_ID U 7 p_qualifier_row_id out Number QUALIFIER_ROW_ID U 8 p_pte_code in Char PTE_CODE U 10 p_rule_name in Char RULE_NAME value U 11 p_rule_description in Char RULE_DESCRIPTION U 12 p_qualifier_rule_dff_context in Char QUALIFIER_RULE_DFF_CONTEXT U 13 p_qualifier_rule_attribute1 in Char QUALIFIER_RULE_ATTRIBUTE1 U 14 p_qualifier_rule_attribute2 in Char QUALIFIER_RULE_ATTRIBUTE2 U 15 p_qualifier_rule_attribute3 in Char QUALIFIER_RULE_ATTRIBUTE3 U 16 p_qualifier_rule_attribute4 in Char QUALIFIER_RULE_ATTRIBUTE4 U 17 p_qualifier_rule_attribute5 in Char QUALIFIER_RULE_ATTRIBUTE5 U 18 p_qualifier_rule_attribute6 in Char QUALIFIER_RULE_ATTRIBUTE6 U 19 p_qualifier_rule_attribute7 in Char QUALIFIER_RULE_ATTRIBUTE7 U 20 p_qualifier_rule_attribute8 in Char QUALIFIER_RULE_ATTRIBUTE8 U 21 p_qualifier_rule_attribute9 in Char QUALIFIER_RULE_ATTRIBUTE9 U 22 p_qualifier_rule_attribute10 in Char QUALIFIER_RULE_ATTRIBUTE10 U 23 p_qualifier_rule_attribute11 in Char QUALIFIER_RULE_ATTRIBUTE11 U 24 p_qualifier_rule_attribute12 in Char QUALIFIER_RULE_ATTRIBUTE12 U 25 p_qualifier_rule_attribute13 in Char QUALIFIER_RULE_ATTRIBUTE13 U 26 p_qualifier_rule_attribute14 in Char QUALIFIER_RULE_ATTRIBUTE14 U 27 p_qualifier_rule_attribute15 in Char QUALIFIER_RULE_ATTRIBUTE15 U 29 p_qualifier_grouping_number in Number QUALIFIER_GROUPING_NUMBER U 30 p_qualifier_context in Char QUALIFIER_CONTEXT U 31 p_qualifier_attribute in Char QUALIFIER_ATTRIBUTE U 33 p_qualifier_precedence in Number QUALIFIER_PRECEDENCE U 34 p_qualifier_operator in Char QUALIFIER_OPERATOR U 35 p_qualifier_value_from in Char QUALIFIER_VALUE_FROM value U 36 p_qualifier_value_from_mng in Char QUALIFIER_VALUE_FROM_DESC value U 37 p_qualifier_value_to in Char QUALIFIER_VALUE_TO U 38 p_qualifier_start_date in Date QUALIFIER_START_DATE U 39 p_qualifier_end_date in Date QUALIFIER_END_DATE U 40 p_delete_qualifier in Char DELETE_QUALIFIER U 41 p_qualifier_dff_context in Char QUALIFIER_DFF_CONTEXT U 42 p_qualifier_attribute1 in Char QUALIFIER_ATTRIBUTE1 U 43 p_qualifier_attribute2 in Char QUALIFIER_ATTRIBUTE2 U 44 p_qualifier_attribute3 in Char QUALIFIER_ATTRIBUTE3 U 45 p_qualifier_attribute4 in Char QUALIFIER_ATTRIBUTE4 U 46 p_qualifier_attribute5 in Char QUALIFIER_ATTRIBUTE5 U 47 p_qualifier_attribute6 in Char QUALIFIER_ATTRIBUTE6 U 48 p_qualifier_attribute7 in Char QUALIFIER_ATTRIBUTE7 U 49 p_qualifier_attribute8 in Char QUALIFIER_ATTRIBUTE8 U 50 p_qualifier_attribute9 in Char QUALIFIER_ATTRIBUTE9 U 51 p_qualifier_attribute10 in Char QUALIFIER_ATTRIBUTE10 U 52 p_qualifier_attribute11 in Char QUALIFIER_ATTRIBUTE11 U 53 p_qualifier_attribute12 in Char QUALIFIER_ATTRIBUTE12 U 54 p_qualifier_attribute13 in Char QUALIFIER_ATTRIBUTE13 U 55 p_qualifier_attribute14 in Char QUALIFIER_ATTRIBUTE14 U 56 p_qualifier_attribute15 in Char QUALIFIER_ATTRIBUTE15 U 57 p_qualifier_rule_id in Number QUALIFIER_RULE_ID U 58 p_qualifier_id in Number QUALIFIER_ID Error SQL Order By x.rule_name, x.upload_row, x.qualifier_grouping_number, x.qualifier_precedence, x.qualifier_context, x.qualifier_attribute Success SQL select xu.action_, xu.status_, ltrim( xu.message_ || case when xu.delete_qualifier is not null and xu.qualifier_row_id is not null and qqv.qualifier_id is null then ',Qualifer Deleted' end, ',') message_, xu.request_id_, xu.modified_columns_, xu.upload_mode_, xu.no_excel_validation_, xu.pte_code, xu.source_system_code, xu.qualifier_rule_row_id, xu.qualifier_row_id, -- Qualifier Group qqr.name rule_name, qqr.description rule_description, -- Qualifier Group DFF Attributes xxen_util.display_flexfield_context(661,'QP_QUALIFIER_RULES',qqr.context) qualifier_rule_dff_context, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE1',qqr.rowid,qqr.attribute1) qualifier_rule_attribute1, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE2',qqr.rowid,qqr.attribute2) qualifier_rule_attribute2, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE3',qqr.rowid,qqr.attribute3) qualifier_rule_attribute3, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE4',qqr.rowid,qqr.attribute4) qualifier_rule_attribute4, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE5',qqr.rowid,qqr.attribute5) qualifier_rule_attribute5, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE6',qqr.rowid,qqr.attribute6) qualifier_rule_attribute6, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE7',qqr.rowid,qqr.attribute7) qualifier_rule_attribute7, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE8',qqr.rowid,qqr.attribute8) qualifier_rule_attribute8, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE9',qqr.rowid,qqr.attribute9) qualifier_rule_attribute9, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE10',qqr.rowid,qqr.attribute10) qualifier_rule_attribute10, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE11',qqr.rowid,qqr.attribute11) qualifier_rule_attribute11, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE12',qqr.rowid,qqr.attribute12) qualifier_rule_attribute12, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE13',qqr.rowid,qqr.attribute13) qualifier_rule_attribute13, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE14',qqr.rowid,qqr.attribute14) qualifier_rule_attribute14, xxen_util.display_flexfield_value(661,'QP_QUALIFIER_RULES',qqr.context,'ATTRIBUTE15',qqr.rowid,qqr.attribute15) qualifier_rule_attribute15, -- Qualifiers nvl(xxen_qp_upload.get_orig_sys_ref('QUALIFIER',qqv.qualifier_id), case when xu.delete_qualifier is not null then xu.qualifier_orig_sys_ref end) qualifier_orig_sys_ref, nvl(qqv.qualifier_grouping_no, case when xu.delete_qualifier is not null then xu.qualifier_grouping_number end) qualifier_grouping_number, nvl(qp_util.get_context('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context), case when xu.delete_qualifier is not null then xu.qualifier_context end) qualifier_context, nvl(qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context,qqv.qualifier_attribute), case when xu.delete_qualifier is not null then xu.qualifier_attribute end) qualifier_attribute, nvl(xxen_util.meaning(decode(qqv.qualify_hier_descendents_flag,'Y','Y',null),'YES_NO',0), case when xu.delete_qualifier is not null then xu.qualifier_applies_party_hier end) qualifier_applies_party_hier, nvl(qqv.qualifier_precedence, case when xu.delete_qualifier is not null then xu.qualifier_precedence end) qualifier_precedence, nvl(qqv.comparision_operator_code, case when xu.delete_qualifier is not null then xu.qualifier_operator end) qualifier_operator, nvl(rtrim(replace(qp_util.get_attribute_value('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context,qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context, qqv.qualifier_attribute),qqv.qualifier_attr_value,qqv.comparision_operator_code),chr(0),null)), case when xu.delete_qualifier is not null then xu.qualifier_value_from end ) qualifier_value_from, nvl(rtrim(replace(qp_util.get_attribute_value_meaning('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context,qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context, qqv.qualifier_attribute),qqv.qualifier_attr_value,qqv.comparision_operator_code),chr(0),null)), case when xu.delete_qualifier is not null then xu.qualifier_value_from_desc end ) qualifier_value_from_desc, nvl(qp_util.get_attribute_value('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context,qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context, qqv.qualifier_attribute), qqv.qualifier_attr_value_to,qqv.comparision_operator_code), case when xu.delete_qualifier is not null then xu.qualifier_value_to end ) qualifier_value_to, nvl(qqv.start_date_active,case when xu.delete_qualifier is not null then xu.qualifier_start_date end) qualifier_start_date, nvl(qqv.end_date_active,case when xu.delete_qualifier is not null then xu.qualifier_end_date end) qualifier_end_date, xu.delete_qualifier, -- Qualifier DFF Attributes xxen_util.display_flexfield_context(661,'QP_QUALIFIERS',qqv.context) qualifier_dff_context, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE1',qqv.row_id,qqv.attribute1) qualifier_attribute1, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE2',qqv.row_id,qqv.attribute2) qualifier_attribute2, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE3',qqv.row_id,qqv.attribute3) qualifier_attribute3, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE4',qqv.row_id,qqv.attribute4) qualifier_attribute4, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE5',qqv.row_id,qqv.attribute5) qualifier_attribute5, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE6',qqv.row_id,qqv.attribute6) qualifier_attribute6, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE7',qqv.row_id,qqv.attribute7) qualifier_attribute7, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE8',qqv.row_id,qqv.attribute8) qualifier_attribute8, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE9',qqv.row_id,qqv.attribute9) qualifier_attribute9, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE10',qqv.row_id,qqv.attribute10) qualifier_attribute10, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE11',qqv.row_id,qqv.attribute11) qualifier_attribute11, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE12',qqv.row_id,qqv.attribute12) qualifier_attribute12, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE13',qqv.row_id,qqv.attribute13) qualifier_attribute13, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE14',qqv.row_id,qqv.attribute14) qualifier_attribute14, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE15',qqv.row_id,qqv.attribute15) qualifier_attribute15, -- Ids qqr.qualifier_rule_id, qqv.qualifier_id, xu.upload_row from xxen_qp_qualifier_group_6138_u xu, qp_qualifier_rules qqr, qp_qualifiers_v qqv where xu.status_code_=xxen_upload.status_success and xu.qualifier_rule_row_id = qqr.qualifier_rule_id and xu.qualifier_rule_row_id = qqv.qualifier_rule_id(+) and xu.qualifier_row_id = qqv.qualifier_id(+)