ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 2536DB32E91243C9E0636DFB0905F10BY select case when :p_override_list_line = 'Y' then xxen_upload.action_meaning(xxen_upload.action_create) else null end action_, case when :p_override_list_line = 'Y' then xxen_upload.status_meaning(xxen_upload.status_new) else null end status_, case when :p_override_list_line = 'Y' then xxen_util.description('U_EXCEL_MSG_VALIDATION_PENDING','XXEN_REPORT_TRANSLATIONS',0) else null end message_, null request_id_, null modified_columns_, :p_upload_mode upload_mode_, :p_override_list_line override_list_line_, to_number(null) price_list_row_id, to_number(null) qualifier_group_row_id, to_number(null) qualifier_row_id, to_number(null) secondary_price_list_row_id, to_number(null) price_list_line_row_id, to_number(null) price_break_line_row_id, to_number(null) pricing_attribute_row_id, qp.* from ( -- -- Q1 List Header Qualifiers -- select -- Price List Header qslhv.pte_code pte_code, qslhv.source_system_code source_system_code, xxen_util.meaning(qslhv.list_type_code,'LIST_TYPE_CODE',661) type, qslhv.orig_system_header_ref list_orig_sys_ref, qslhv.name name, qslhv.description description, xxen_util.meaning(nvl(qslhv.global_flag,'Y'),'YES_NO',0) global, qp_util.get_ou_name(qslhv.orig_org_id) operating_unit, qslhv.currency_code currency, (select qclv.name from qp_currency_lists_vl qclv where qslhv.currency_header_id=qclv.currency_header_id) multi_currency_conversion, qslhv.rounding_factor round_to, xxen_util.meaning(nvl(qslhv.active_flag,'N'),'YES_NO',0) active, qslhv.start_date_active effective_from, qslhv.end_date_active effective_to, xxen_util.meaning(qslhv.freight_terms_code,'FREIGHT_TERMS',660) freight_terms, qslhv.ship_method_code ship_method, (select rtt.name from ra_terms_tl rtt where qslhv.terms_id=rtt.term_id and rtt.language(+)=userenv('lang')) payment_term, xxen_util.meaning(qslhv.mobile_download,'YES_NO',0) mobile_download, qslhv.comments comments, -- Price List DFF Attributes xxen_util.display_flexfield_context(661,'QP_LIST_HEADERS',qslhv.context) list_header_dff_context, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE1',qslhv.row_id,qslhv.attribute1) list_header_attribute1, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE2',qslhv.row_id,qslhv.attribute2) list_header_attribute2, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE3',qslhv.row_id,qslhv.attribute3) list_header_attribute3, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE4',qslhv.row_id,qslhv.attribute4) list_header_attribute4, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE5',qslhv.row_id,qslhv.attribute5) list_header_attribute5, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE6',qslhv.row_id,qslhv.attribute6) list_header_attribute6, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE7',qslhv.row_id,qslhv.attribute7) list_header_attribute7, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE8',qslhv.row_id,qslhv.attribute8) list_header_attribute8, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE9',qslhv.row_id,qslhv.attribute9) list_header_attribute9, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE10',qslhv.row_id,qslhv.attribute10) list_header_attribute10, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE11',qslhv.row_id,qslhv.attribute11) list_header_attribute11, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE12',qslhv.row_id,qslhv.attribute12) list_header_attribute12, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE13',qslhv.row_id,qslhv.attribute13) list_header_attribute13, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE14',qslhv.row_id,qslhv.attribute14) list_header_attribute14, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE15',qslhv.row_id,qslhv.attribute15) list_header_attribute15, -- Price List Lines null line_orig_sys_ref, to_number(null) line_no, null line_product_context, null line_product_attribute, null line_product_value, null line_product_attribute_desc, null line_product_uom, null line_primary_uom_flag, null line_type, null line_price_break_type, null line_application_method, null line_accumulation_attribute, null line_break_uom, null line_break_uom_attribute, to_number(null) line_value, null line_dynamic_formula, null line_static_formula, to_date(null) line_start_date, to_date(null) line_end_date, to_number(null) line_precedence, null delete_line, -- Price Breaks null price_break_orig_sys_ref, null price_break_pricing_context, null price_break_pricing_attribute, to_number(null) price_break_value_from, to_number(null) price_break_value_to, to_number(null) price_break_price, null price_break_application_method, null price_break_formula, to_number(null) price_break_recurring_value, null delete_price_break, -- Price List Line Pricing Attributes null pricing_attribute_orig_sys_ref, null pricing_attribute_context, null pricing_attribute, null pricing_attribute_operator, null pricing_attribute_value_from, null pricing_attribute_val_fr_desc, null pricing_attribute_value_to, null delete_pricing_attribute, -- Price List Line DFF Attributes null list_line_dff_context, null list_line_attribute1, null list_line_attribute2, null list_line_attribute3, null list_line_attribute4, null list_line_attribute5, null list_line_attribute6, null list_line_attribute7, null list_line_attribute8, null list_line_attribute9, null list_line_attribute10, null list_line_attribute11, null list_line_attribute12, null list_line_attribute13, null list_line_attribute14, null list_line_attribute15, -- Price List Qualifiers xxen_qp_upload.get_orig_sys_ref('QUALIFIER',qqv.qualifier_id) qualifier_orig_sys_ref, qqv.rule_name qualifier_group, to_number(null) qualifier_group_qualifier_id, 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(qqv.qualify_hier_descendents_flag,'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, -- Secondary Price Lists null sec_price_list_orig_sys_ref, null secondary_price_list, to_number(null) secondary_price_list_precedenc, null delete_secondary_price_list, -- IDs qslhv.list_header_id price_list_id, qqv.qualifier_id qualifier_id, to_number(null) sec_price_list_qualifier_id, to_number(null) price_list_line_id, to_number(null) price_break_line_id, to_number(null) pricing_attribute_id, 'Qualifier' row_type, 1 upload_row from qp_secu_list_headers_vl qslhv, qp_qualifiers_v qqv where 1=1 and :p_show_qualifiers = 'Y' and nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :p_pte_code and nvl(qslhv.source_system_code,'QP') = :p_appl_sn and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag = 'Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and -- qslhv.list_header_id = qqv.list_header_id and qqv.list_line_id = -1 and qqv.qualifier_context != 'MODLIST' and qqv.qualifier_attribute != 'QUALIFIER_ATTRIBUTE4' and -- exists (select null from qp_list_lines_v qllv where 2=2 and qslhv.list_header_id = qllv.list_header_id and qllv.list_line_type_code in ('PBH','PLL') and qllv.product_attribute_context = 'ITEM' and ( (qllv.product_attribute = 'PRICING_ATTRIBUTE1' and exists (select null from mtl_system_items msi where msi.inventory_item_id = to_number(decode(translate(qllv.product_attr_value,'.0123456789','.'),null,qllv.product_attr_value,null)) and msi.organization_id = qp_util.get_item_validation_org) ) or (qllv.product_attribute != 'PRICING_ATTRIBUTE1' ) ) ) -- union -- -- Q2 List Header Secondary Price Lists -- select -- Price List Header qslhv.pte_code pte_code, qslhv.source_system_code source_system_code, xxen_util.meaning(qslhv.list_type_code,'LIST_TYPE_CODE',661) type, qslhv.orig_system_header_ref list_orig_sys_ref, qslhv.name name, qslhv.description description, xxen_util.meaning(nvl(qslhv.global_flag,'Y'),'YES_NO',0) global, qp_util.get_ou_name(qslhv.orig_org_id) operating_unit, qslhv.currency_code currency, (select qclv.name from qp_currency_lists_vl qclv where qslhv.currency_header_id=qclv.currency_header_id) multi_currency_conversion, qslhv.rounding_factor round_to, xxen_util.meaning(nvl(qslhv.active_flag,'N'),'YES_NO',0) active, qslhv.start_date_active effective_from, qslhv.end_date_active effective_to, xxen_util.meaning(qslhv.freight_terms_code,'FREIGHT_TERMS',660) freight_terms, qslhv.ship_method_code ship_method, (select rtt.name from ra_terms_tl rtt where qslhv.terms_id=rtt.term_id and rtt.language(+)=userenv('lang')) payment_term, xxen_util.meaning(qslhv.mobile_download,'YES_NO',0) mobile_download, qslhv.comments comments, -- Price List DFF Attributes xxen_util.display_flexfield_context(661,'QP_LIST_HEADERS',qslhv.context) list_header_dff_context, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE1',qslhv.row_id,qslhv.attribute1) list_header_attribute1, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE2',qslhv.row_id,qslhv.attribute2) list_header_attribute2, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE3',qslhv.row_id,qslhv.attribute3) list_header_attribute3, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE4',qslhv.row_id,qslhv.attribute4) list_header_attribute4, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE5',qslhv.row_id,qslhv.attribute5) list_header_attribute5, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE6',qslhv.row_id,qslhv.attribute6) list_header_attribute6, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE7',qslhv.row_id,qslhv.attribute7) list_header_attribute7, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE8',qslhv.row_id,qslhv.attribute8) list_header_attribute8, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE9',qslhv.row_id,qslhv.attribute9) list_header_attribute9, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE10',qslhv.row_id,qslhv.attribute10) list_header_attribute10, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE11',qslhv.row_id,qslhv.attribute11) list_header_attribute11, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE12',qslhv.row_id,qslhv.attribute12) list_header_attribute12, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE13',qslhv.row_id,qslhv.attribute13) list_header_attribute13, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE14',qslhv.row_id,qslhv.attribute14) list_header_attribute14, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE15',qslhv.row_id,qslhv.attribute15) list_header_attribute15, -- Price List Lines null line_orig_sys_ref, to_number(null) line_no, null line_product_context, null line_product_attribute, null line_product_value, null line_product_attribute_desc, null line_product_uom, null line_primary_uom_flag, null line_type, null line_price_break_type, null line_application_method, null line_accumulation_attribute, null line_break_uom, null line_break_uom_attribute, to_number(null) line_value, null line_dynamic_formula, null line_static_formula, to_date(null) line_start_date, to_date(null) line_end_date, to_number(null) line_precedence, null delete_line, -- Price Breaks null price_break_orig_sys_ref, null price_break_pricing_context, null price_break_pricing_attribute, to_number(null) price_break_value_from, to_number(null) price_break_value_to, to_number(null) price_break_price, null price_break_application_method, null price_break_formula, to_number(null) price_break_recurring_value, null delete_price_break, -- Price List Line Pricing Attributes null pricing_attribute_orig_sys_ref, null pricing_attribute_context, null pricing_attribute, null pricing_attribute_operator, null pricing_attribute_value_from, null pricing_attribute_val_fr_desc, null pricing_attribute_value_to, null delete_pricing_attribute, -- Price List Line DFF Attributes null list_line_dff_context, null list_line_attribute1, null list_line_attribute2, null list_line_attribute3, null list_line_attribute4, null list_line_attribute5, null list_line_attribute6, null list_line_attribute7, null list_line_attribute8, null list_line_attribute9, null list_line_attribute10, null list_line_attribute11, null list_line_attribute12, null list_line_attribute13, null list_line_attribute14, null list_line_attribute15, -- Price List Qualifiers null qualifier_orig_sys_ref, null qualifier_group, to_number(null) qualifier_group_qualifier_id, to_number(null) qualifier_grouping_number, null qualifier_context, null qualifier_attribute, null qualifier_applies_party_hier, to_number(null) qualifier_precedence, null qualifier_operator, null qualifier_value_from, null qualifier_value_from_desc, null qualifier_value_to, to_date(null) qualifier_start_date, to_date(null) qualifier_end_date, null delete_qualifier, -- Qualifier DFF Attributes null qualifier_dff_context, null qualifier_attribute1, null qualifier_attribute2, null qualifier_attribute3, null qualifier_attribute4, null qualifier_attribute5, null qualifier_attribute6, null qualifier_attribute7, null qualifier_attribute8, null qualifier_attribute9, null qualifier_attribute10, null qualifier_attribute11, null qualifier_attribute12, null qualifier_attribute13, null qualifier_attribute14, null qualifier_attribute15, -- Secondary Price Lists xxen_qp_upload.get_orig_sys_ref('LIST_HEADER',qsplv.list_header_id) sec_price_list_orig_sys_ref, qsplv.name secondary_price_list, qsplv.precedence secondary_price_list_precedenc, null delete_secondary_price_list, -- IDs qslhv.list_header_id price_list_id, to_number(null) qualifier_id, qsplv.qualifier_id sec_price_list_qualifier_id, to_number(null) price_list_line_id, to_number(null) price_break_line_id, to_number(null) pricing_attribute_id, 'Secondary Price List' row_type, 2 upload_row from qp_secu_list_headers_vl qslhv, qp_secondary_price_lists_v qsplv where 1=1 and :p_show_secondary_price_lists = 'Y' and nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :p_pte_code and nvl(qslhv.source_system_code,'QP') = :p_appl_sn and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag = 'Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and -- qslhv.list_header_id = qsplv.parent_price_list_id and -- exists (select null from qp_list_lines_v qllv where 2=2 and qslhv.list_header_id = qllv.list_header_id and qllv.list_line_type_code in ('PBH','PLL') and qllv.product_attribute_context = 'ITEM' and ( (qllv.product_attribute = 'PRICING_ATTRIBUTE1' and exists (select null from mtl_system_items msi where msi.inventory_item_id = to_number(decode(translate(qllv.product_attr_value,'.0123456789','.'),null,qllv.product_attr_value,null)) and msi.organization_id = qp_util.get_item_validation_org) ) or (qllv.product_attribute != 'PRICING_ATTRIBUTE1' ) ) ) -- union -- -- Q3 Price Lists Lines - Pricing Attributes -- select -- Price List Header qslhv.pte_code pte_code, qslhv.source_system_code source_system_code, xxen_util.meaning(qslhv.list_type_code,'LIST_TYPE_CODE',661) type, qslhv.orig_system_header_ref list_orig_sys_ref, qslhv.name name, qslhv.description description, xxen_util.meaning(nvl(qslhv.global_flag,'Y'),'YES_NO',0) global, qp_util.get_ou_name(qslhv.orig_org_id) operating_unit, qslhv.currency_code currency, (select qclv.name from qp_currency_lists_vl qclv where qslhv.currency_header_id=qclv.currency_header_id) multi_currency_conversion, qslhv.rounding_factor round_to, xxen_util.meaning(nvl(qslhv.active_flag,'N'),'YES_NO',0) active, qslhv.start_date_active effective_from, qslhv.end_date_active effective_to, xxen_util.meaning(qslhv.freight_terms_code,'FREIGHT_TERMS',660) freight_terms, qslhv.ship_method_code ship_method, (select rtt.name from ra_terms_tl rtt where qslhv.terms_id=rtt.term_id and rtt.language(+)=userenv('lang'))payment_term, xxen_util.meaning(qslhv.mobile_download,'YES_NO',0) mobile_download, qslhv.comments comments, -- Price List DFF Attributes xxen_util.display_flexfield_context(661,'QP_LIST_HEADERS',qslhv.context) list_header_dff_context, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE1',qslhv.row_id,qslhv.attribute1) list_header_attribute1, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE2',qslhv.row_id,qslhv.attribute2) list_header_attribute2, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE3',qslhv.row_id,qslhv.attribute3) list_header_attribute3, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE4',qslhv.row_id,qslhv.attribute4) list_header_attribute4, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE5',qslhv.row_id,qslhv.attribute5) list_header_attribute5, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE6',qslhv.row_id,qslhv.attribute6) list_header_attribute6, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE7',qslhv.row_id,qslhv.attribute7) list_header_attribute7, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE8',qslhv.row_id,qslhv.attribute8) list_header_attribute8, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE9',qslhv.row_id,qslhv.attribute9) list_header_attribute9, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE10',qslhv.row_id,qslhv.attribute10) list_header_attribute10, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE11',qslhv.row_id,qslhv.attribute11) list_header_attribute11, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE12',qslhv.row_id,qslhv.attribute12) list_header_attribute12, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE13',qslhv.row_id,qslhv.attribute13) list_header_attribute13, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE14',qslhv.row_id,qslhv.attribute14) list_header_attribute14, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE15',qslhv.row_id,qslhv.attribute15) list_header_attribute15, -- Price List Lines xxen_qp_upload.get_orig_sys_ref('LINE',qllv.list_line_id) line_orig_sys_ref, qllv.list_line_no line_no, qp_util.get_context('QP_ATTR_DEFNS_PRICING',qllv.product_attribute_context) line_product_context, qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qllv.product_attribute_context, qllv.product_attribute) line_product_attribute, qllv.product_attr_val_disp line_product_value, xxen_qp_upload.get_product_description(qslhv.pte_code,qp_util.get_context('QP_ATTR_DEFNS_PRICING',qllv.product_attribute_context),qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qllv.product_attribute_context,qllv.product_attribute),qllv.product_attr_value,qllv.product_attr_val_disp) line_product_attribute_desc, qllv.product_uom_code line_product_uom, xxen_util.meaning(qllv.primary_uom_flag,'YES_NO',0) line_primary_uom_flag, xxen_util.meaning(qllv.list_line_type_code,'LIST_LINE_TYPE_CODE',661) line_type, xxen_util.meaning(qllv.price_break_type_code,'PRICE_BREAK_TYPE_CODE',661) line_price_break_type, xxen_util.meaning(qllv.arithmetic_operator,'ARITHMETIC_OPERATOR',661) line_application_method, replace(qllv.accum_attribute,chr(0),'') line_accumulation_attribute, qllv.break_uom_code line_break_uom, qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qllv.break_uom_context,qllv.break_uom_attribute) line_break_uom_attribute, qllv.operand line_value, nvl2(qllv.price_by_formula_id,qp_qp_form_pricing_attr.get_formula(qllv.price_by_formula_id),null) line_dynamic_formula, nvl2(qllv.generate_using_formula_id,qp_qp_form_pricing_attr.get_formula(qllv.generate_using_formula_id),null) line_static_formula, qllv.start_date_active line_start_date, qllv.end_date_active line_end_date, qllv.product_precedence line_precedence, null delete_line, -- Price Breaks null price_break_orig_sys_ref, null price_break_pricing_context, null price_break_pricing_attribute, to_number(null) price_break_value_from, to_number(null) price_break_value_to, to_number(null) price_break_price, null price_break_application_method, null price_break_formula, to_number(null) price_break_recurring_value, null delete_price_break, -- Price List Line Pricing Attributes qpa.orig_sys_pricing_attr_ref pricing_attribute_orig_sys_ref, qp_util.get_context('QP_ATTR_DEFNS_PRICING',qpa.pricing_attribute_context) pricing_attribute_context, qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qpa.pricing_attribute_context, qpa.pricing_attribute) pricing_attribute, qpa.comparison_operator_code pricing_attribute_operator, rtrim(replace( qp_util.get_attribute_value ('QP_ATTR_DEFNS_PRICING', qpa.pricing_attribute_context, qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_PRICING',qpa.pricing_attribute_context, qpa.pricing_attribute), qpa.pricing_attr_value_from, qpa.comparison_operator_code ),chr(0),null) ) pricing_attribute_value_from, rtrim(replace( qp_util.get_attribute_value_meaning ('QP_ATTR_DEFNS_PRICING', qpa.pricing_attribute_context, qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_PRICING',qpa.pricing_attribute_context, qpa.pricing_attribute), qpa.pricing_attr_value_from, qpa.comparison_operator_code ),chr(0),null) ) pricing_attribute_val_fr_desc, qp_util.get_attribute_value ('QP_ATTR_DEFNS_PRICING', qpa.pricing_attribute_context, qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_PRICING',qpa.pricing_attribute_context, qpa.pricing_attribute), qpa.pricing_attr_value_to, qpa.comparison_operator_code ) pricing_attribute_value_to, null delete_pricing_attribute, -- Price List Line DFF Attributes xxen_util.display_flexfield_context(661,'QP_LIST_LINES',qllv.context) list_line_dff_context, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE1',qllv.row_id,qllv.attribute1) list_line_attribute1, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE2',qllv.row_id,qllv.attribute2) list_line_attribute2, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE3',qllv.row_id,qllv.attribute3) list_line_attribute3, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE4',qllv.row_id,qllv.attribute4) list_line_attribute4, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE5',qllv.row_id,qllv.attribute5) list_line_attribute5, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE6',qllv.row_id,qllv.attribute6) list_line_attribute6, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE7',qllv.row_id,qllv.attribute7) list_line_attribute7, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE8',qllv.row_id,qllv.attribute8) list_line_attribute8, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE9',qllv.row_id,qllv.attribute9) list_line_attribute9, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE10',qllv.row_id,qllv.attribute10) list_line_attribute10, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE11',qllv.row_id,qllv.attribute11) list_line_attribute11, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE12',qllv.row_id,qllv.attribute12) list_line_attribute12, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE13',qllv.row_id,qllv.attribute13) list_line_attribute13, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE14',qllv.row_id,qllv.attribute14) list_line_attribute14, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE15',qllv.row_id,qllv.attribute15) list_line_attribute15, -- Price List Qualifiers null qualifier_orig_sys_ref, null qualifier_group, to_number(null) qualifier_group_qualifier_id, to_number(null) qualifier_grouping_number, null qualifier_context, null qualifier_attribute, null qualifier_applies_party_hier, to_number(null) qualifier_precedence, null qualifier_operator, null qualifier_value_from, null qualifier_value_from_desc, null qualifier_value_to, to_date(null) qualifier_start_date, to_date(null) qualifier_end_date, null delete_qualifier, -- Qualifier DFF Attributes null qualifier_dff_context, null qualifier_attribute1, null qualifier_attribute2, null qualifier_attribute3, null qualifier_attribute4, null qualifier_attribute5, null qualifier_attribute6, null qualifier_attribute7, null qualifier_attribute8, null qualifier_attribute9, null qualifier_attribute10, null qualifier_attribute11, null qualifier_attribute12, null qualifier_attribute13, null qualifier_attribute14, null qualifier_attribute15, -- Secondary Price Lists null sec_price_list_orig_sys_ref, null secondary_price_list, to_number(null) secondary_price_list_precedenc, null delete_secondary_price_list, -- IDs qslhv.list_header_id price_list_id, to_number(null)qualifier_id, to_number(null) sec_price_list_qualifier_id, qllv.list_line_id price_list_line_id, to_number(null) price_break_line_id, qpa.pricing_attribute_id pricing_attribute_id, 'List Line' row_type, 3 upload_row from qp_secu_list_headers_vl qslhv, qp_list_lines_v qllv, qp_pricing_attributes qpa where 1=1 and 2=2 and :p_show_price_list_lines = 'Y' and nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :p_pte_code and nvl(qslhv.source_system_code,'QP') = :p_appl_sn and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag = 'Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and -- qslhv.list_header_id = qllv.list_header_id and qllv.list_line_type_code in ('PBH','PLL') and qllv.product_attribute_context = 'ITEM' and ( (qllv.product_attribute= 'PRICING_ATTRIBUTE1' and exists (select null from mtl_system_items msi where msi.inventory_item_id = to_number(decode(translate(qllv.product_attr_value,'.0123456789','.'),null,qllv.product_attr_value,null)) and msi.organization_id = qp_util.get_item_validation_org) ) or (qllv.product_attribute != 'PRICING_ATTRIBUTE1' ) ) and -- nvl2(:p_show_pricing_attributes,qllv.list_line_id,null) = qpa.list_line_id (+) and qpa.pricing_attribute (+) is not null and -- ( (qllv.list_line_type_code = 'PLL') or (qllv.list_line_type_code = 'PBH' and (qpa.pricing_attribute is not null or not exists (select null from qp_price_breaks_v qpbv where qpbv.parent_list_line_id = qllv.list_line_id) ) ) ) union -- -- Q4 Price Breaks -- select -- Price List Header qslhv.pte_code pte_code, qslhv.source_system_code source_system_code, xxen_util.meaning(qslhv.list_type_code,'LIST_TYPE_CODE',661) type, qslhv.orig_system_header_ref list_orig_sys_ref, qslhv.name name, qslhv.description description, xxen_util.meaning(nvl(qslhv.global_flag,'Y'),'YES_NO',0) global, qp_util.get_ou_name(qslhv.orig_org_id) operating_unit, qslhv.currency_code currency, (select qclv.name from qp_currency_lists_vl qclv where qslhv.currency_header_id=qclv.currency_header_id) multi_currency_conversion, qslhv.rounding_factor round_to, xxen_util.meaning(nvl(qslhv.active_flag,'N'),'YES_NO',0) active, qslhv.start_date_active effective_from, qslhv.end_date_active effective_to, xxen_util.meaning(qslhv.freight_terms_code,'FREIGHT_TERMS',660) freight_terms, qslhv.ship_method_code ship_method, (select rtt.name from ra_terms_tl rtt where qslhv.terms_id=rtt.term_id and rtt.language(+)=userenv('lang'))payment_term, xxen_util.meaning(qslhv.mobile_download,'YES_NO',0) mobile_download, qslhv.comments comments, -- Price List DFF Attributes xxen_util.display_flexfield_context(661,'QP_LIST_HEADERS',qslhv.context) list_header_dff_context, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE1',qslhv.row_id,qslhv.attribute1) list_header_attribute1, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE2',qslhv.row_id,qslhv.attribute2) list_header_attribute2, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE3',qslhv.row_id,qslhv.attribute3) list_header_attribute3, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE4',qslhv.row_id,qslhv.attribute4) list_header_attribute4, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE5',qslhv.row_id,qslhv.attribute5) list_header_attribute5, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE6',qslhv.row_id,qslhv.attribute6) list_header_attribute6, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE7',qslhv.row_id,qslhv.attribute7) list_header_attribute7, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE8',qslhv.row_id,qslhv.attribute8) list_header_attribute8, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE9',qslhv.row_id,qslhv.attribute9) list_header_attribute9, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE10',qslhv.row_id,qslhv.attribute10) list_header_attribute10, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE11',qslhv.row_id,qslhv.attribute11) list_header_attribute11, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE12',qslhv.row_id,qslhv.attribute12) list_header_attribute12, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE13',qslhv.row_id,qslhv.attribute13) list_header_attribute13, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE14',qslhv.row_id,qslhv.attribute14) list_header_attribute14, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE15',qslhv.row_id,qslhv.attribute15) list_header_attribute15, -- Price List Lines xxen_qp_upload.get_orig_sys_ref('LINE',qllv.list_line_id) line_orig_sys_ref, qllv.list_line_no line_no, qp_util.get_context('QP_ATTR_DEFNS_PRICING',qllv.product_attribute_context) line_product_context, qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qllv.product_attribute_context, qllv.product_attribute) line_product_attribute, qllv.product_attr_val_disp line_product_value, xxen_qp_upload.get_product_description(qslhv.pte_code,qp_util.get_context('QP_ATTR_DEFNS_PRICING',qllv.product_attribute_context),qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qllv.product_attribute_context,qllv.product_attribute),qllv.product_attr_value,qllv.product_attr_val_disp) line_product_attribute_desc, qllv.product_uom_code line_product_uom, xxen_util.meaning(qllv.primary_uom_flag,'YES_NO',0) line_primary_uom_flag, xxen_util.meaning(qllv.list_line_type_code,'LIST_LINE_TYPE_CODE',661) line_type, xxen_util.meaning(qllv.price_break_type_code,'PRICE_BREAK_TYPE_CODE',661) line_price_break_type, xxen_util.meaning(qllv.arithmetic_operator,'ARITHMETIC_OPERATOR',661) line_application_method, replace(qllv.accum_attribute,chr(0),'') line_accumulation_attribute, qllv.break_uom_code line_break_uom, qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qllv.break_uom_context,qllv.break_uom_attribute) line_break_uom_attribute, qllv.operand line_value, nvl2(qllv.price_by_formula_id,qp_qp_form_pricing_attr.get_formula(qllv.price_by_formula_id),null) line_dynamic_formula, nvl2(qllv.generate_using_formula_id,qp_qp_form_pricing_attr.get_formula(qllv.generate_using_formula_id),null) line_static_formula, qllv.start_date_active line_start_date, qllv.end_date_active line_end_date, qllv.product_precedence line_precedence, null delete_line, -- Price Breaks xxen_qp_upload.get_orig_sys_ref('LINE',qpbv.list_line_id) price_break_orig_sys_ref, qp_util.Get_Context('QP_ATTR_DEFNS_PRICING',qpbv.pricing_attribute_context) price_break_pricing_context, qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qpbv.pricing_attribute_context,qpbv.pricing_attribute) price_break_pricing_attribute, qpbv.pricing_attr_value_from_number price_break_value_from, qpbv.pricing_attr_value_to_number price_break_value_to, qpbv.operand price_break_price, xxen_util.meaning(qpbv.arithmetic_operator,'ARITHMETIC_OPERATOR',661) price_break_application_method, nvl2(qpbv.price_by_formula_id,qp_qp_form_pricing_attr.get_formula(qpbv.price_by_formula_id),null) price_break_formula, qpbv.recurring_value price_break_recurring_value, null delete_price_break, -- Price List Line Pricing Attributes null pricing_attribute_orig_sys_ref, null pricing_attribute_context, null pricing_attribute, null pricing_attribute_operator, null pricing_attribute_value_from, null pricing_attribute_val_fr_desc, null pricing_attribute_value_to, null delete_pricing_attribute, -- Price List Line DFF Attributes xxen_util.display_flexfield_context(661,'QP_LIST_LINES',qllv.context) list_line_dff_context, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE1',qllv.row_id,qllv.attribute1) list_line_attribute1, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE2',qllv.row_id,qllv.attribute2) list_line_attribute2, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE3',qllv.row_id,qllv.attribute3) list_line_attribute3, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE4',qllv.row_id,qllv.attribute4) list_line_attribute4, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE5',qllv.row_id,qllv.attribute5) list_line_attribute5, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE6',qllv.row_id,qllv.attribute6) list_line_attribute6, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE7',qllv.row_id,qllv.attribute7) list_line_attribute7, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE8',qllv.row_id,qllv.attribute8) list_line_attribute8, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE9',qllv.row_id,qllv.attribute9) list_line_attribute9, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE10',qllv.row_id,qllv.attribute10) list_line_attribute10, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE11',qllv.row_id,qllv.attribute11) list_line_attribute11, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE12',qllv.row_id,qllv.attribute12) list_line_attribute12, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE13',qllv.row_id,qllv.attribute13) list_line_attribute13, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE14',qllv.row_id,qllv.attribute14) list_line_attribute14, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE15',qllv.row_id,qllv.attribute15) list_line_attribute15, -- Price List Qualifiers null qualifier_orig_sys_ref, null qualifier_group, to_number(null) qualifier_group_qualifier_id, to_number(null) qualifier_grouping_number, null qualifier_context, null qualifier_attribute, null qualifier_applies_party_hier, to_number(null) qualifier_precedence, null qualifier_operator, null qualifier_value_from, null qualifier_value_from_desc, null qualifier_value_to, to_date(null) qualifier_start_date, to_date(null) qualifier_end_date, null delete_qualifier, -- Qualifier DFF Attributes null qualifier_dff_context, null qualifier_attribute1, null qualifier_attribute2, null qualifier_attribute3, null qualifier_attribute4, null qualifier_attribute5, null qualifier_attribute6, null qualifier_attribute7, null qualifier_attribute8, null qualifier_attribute9, null qualifier_attribute10, null qualifier_attribute11, null qualifier_attribute12, null qualifier_attribute13, null qualifier_attribute14, null qualifier_attribute15, -- Secondary Price Lists null sec_price_list_orig_sys_ref, null secondary_price_list, to_number(null) secondary_price_list_precedenc, null delete_secondary_price_list, -- IDs qslhv.list_header_id price_list_id, to_number(null)qualifier_id, to_number(null) sec_price_list_qualifier_id, qllv.list_line_id price_list_line_id, qpbv.list_line_id price_break_line_id, to_number(null) pricing_attribute_id, 'Price Break' row_type, 3 upload_row from qp_secu_list_headers_vl qslhv, qp_list_lines_v qllv, qp_price_breaks_v qpbv where 1=1 and 2=2 and :p_show_price_list_lines = 'Y' and nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :p_pte_code and nvl(qslhv.source_system_code,'QP') = :p_appl_sn and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag = 'Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and -- qslhv.list_header_id = qllv.list_header_id and qllv.list_line_type_code = 'PBH' and qllv.product_attribute_context = 'ITEM' and ( (qllv.product_attribute= 'PRICING_ATTRIBUTE1' and exists (select null from mtl_system_items msi where msi.inventory_item_id = to_number(decode(translate(qllv.product_attr_value,'.0123456789','.'),null,qllv.product_attr_value,null)) and msi.organization_id = qp_util.get_item_validation_org) ) or (qllv.product_attribute != 'PRICING_ATTRIBUTE1' ) ) and -- qllv.list_line_id = qpbv.parent_list_line_id -- ) qp where :p_upload_mode like '%' || xxen_upload.action_update and nvl(:p_category_set_id,-99) = nvl(:p_category_set_id,-99) U A xxen_qp_upload.upload_price_list xxen_qp_upload.validate_price_list_row( :$column$.pte_code, :$column$.source_system_code, :$column$.type, :$column$.name, :$column$.global, :$column$.operating_unit, :$column$.multi_currency_conversion, :$column$.qualifier_grouping_number, :$column$.qualifier_context, :$column$.qualifier_attribute, :$column$.qualifier_operator, :$column$.qualifier_value_from, :$column$.qualifier_value_from_desc, :$column$.qualifier_value_to, :$column$.line_product_context, :$column$.line_product_attribute, :$column$.line_product_value, :$column$.line_product_attribute_desc, :$column$.line_product_uom, :$column$.line_type, :$column$.line_price_break_type, :$column$.line_application_method, :$column$.line_accumulation_attribute, :$column$.line_break_uom, :$column$.line_break_uom_attribute, :$column$.line_value, :$column$.line_dynamic_formula, :$column$.line_static_formula, :$column$.price_break_value_from, :$column$.price_break_value_to, :$column$.price_break_price, :$column$.price_break_application_method, :$column$.price_break_formula, :$column$.price_break_recurring_value, :$column$.pricing_attribute_context, :$column$.pricing_attribute, :$column$.pricing_attribute_operator, :$column$.pricing_attribute_value_from, :$column$.pricing_attribute_val_fr_desc, :$column$.pricing_attribute_value_to ) US QP Price List Upload This upload supports the creation and update of Standard Price Lists in Oracle Advanced Pricing. The upload supports creation/update/deletion of the following entities within the Price List: - Price List Lines 'End Date Matching List Lines?' When creating new Price List Lines, the upload can automatically end date any existing matching active price list line by setting the report parameter 'End Date Matching List Lines?' to Yes. Set this parameter to Yes to automatically end date any active matching price list line on upload. Any price list lines downloaded when this parameter is set to yes will have the Action field automatically set to ’Create’ to indicate a new Price List Line should be created instead off the existing price list line being updated. This allows the user to use the downloaded (current) price list lines as a basis for creating the new price list lines. - Price Breaks To enter the Price Breaks in the upload, repeat the Price Break Header Line and enter/adjust the Price Break Columns for each Price Break. - Price List Line Pricing Attributes By default, the upload will treat all rows with the same Product, Unit of Measure, and Start Date as the same Price List Line. If you have different Price List Lines that use the same Product, Unit of Measure and Start Date but which have different Pricing Attribute assignments, the use the ‘Line No’ column to distinguish the different Price List Lines. If not specified, then all rows with the same Product, Unit of Measure, and Start Date will be uploaded as a single Price List Line and any Pricing Attributes will be added to that Price List Line. The Line Number entered here is not uploaded to Oracle. It is only used by the upload to distinguish different lines with the same product, Unit of Measure, and Start date. - Price Lists Qualifiers Qualifier Groups can be copied to the Price List by selecting the Qualifier Group and leaving all other qualifier columns blank. The upload will copy and attach all the qualifier group's qualifiers to the price list. Alternatively, you can select specific qualifiers from a Qualifier Group by selecting the Qualifier Group and the Qualifier Group Qualifier ID. The upload excel will then default in the details of that qualifier into the excel. In this scenario you would enter each qualifier on a separate row in the excel. - Secondary Price Lists Note: When downloading existing Price List data into the upload excel: - Header level Qualifiers and Secondary Price Lists will be downloaded into separate rows in the excel - Line level Price Breaks and Pricing Attributes will be downloaded into separate rows in the excel This is to minimize the duplication of data in the excel. However, when entering data for upload Qualifiers, Secondary Price Lists, Price Breaks, and Pricing Attributes can be added in the same excel row. i.e. You can upload an excel row containing a header level qualifier, header level secondary price list, price list line details with associated price break and pricing attribute. Enginatics Upload 1=1 2=2 :p_appl_sn :p_category_set_id :p_override_list_line :p_pte_code :p_show_price_list_lines :p_show_pricing_attributes :p_show_qualifiers :p_show_secondary_price_lists :p_upload_mode 1 -50 2=2 qllv.product_attribute_context=:p_prod_attribute_context LOV custom Y select x.id, x.value, x.description from xmltable ('/CONTEXT/ROW' passing xxen_qp_upload.get_contexts_lov(:$flex$.pricing_transaction_entity) 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 = 'PRODUCT' order by value ITEM US Product Attribute Context 2 -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 3 -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 4 -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 5 -10 1=1 qslhv.list_type_code = :p_list_type_code LOV custom Y select ql.lookup_code id, ql.meaning value, null description from qp_lookups ql where ql.lookup_type = 'LIST_TYPE_CODE' and ql.lookup_code in ('PRL') order by value PRL Y US Price List Type 6 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 7 15 :p_override_list_line LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US End Date Matching List Lines? Set this parameter to Yes to automatically end date any active matching price list line on upload. 8 20 1=1 qslhv.list_header_id=:p_price_list LOV custom Y select qslhv.list_header_id id, qslhv.name value, qslhv.description || ' (' || decode(qslhv.global_flag,'Y','Global',haouv.name) || ')' description from qp_secu_list_headers_vl qslhv, hr_all_organization_units_vl haouv where qslhv.orig_org_id = haouv.organization_id (+) and nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$flex$.pricing_transaction_entity and nvl(qslhv.source_system_code,'QP') = :$flex$.source_system_code and qslhv.list_type_code = :$flex$.Price_List_Type and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') order by value US Price List 9 25 1=1 lower(qslhv.name) like lower(:p_price_list_like) || '%' Char US Price List Like 10 40 2=2 qllv.product_attribute=:p_prod_attribute LOV custom Y select x.id, x.value, x.description from xmltable ('/ATTRIBUTE/ROW' passing xxen_qp_upload.get_attributes_lov(:$flex$.pricing_transaction_entity) 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 = 'PRODUCT' and x.context_value = qp_util.get_context('QP_ATTR_DEFNS_PRICING',:$flex$.product_attribute_context) and x.enabled = 'Y' and nvl(x.segment_level,'LINE') = 'LINE' order by value US Product Attribute 11 50 2=2 qllv.product_attr_value=to_char(:p_prod_attribute_value) LOV custom Y Y select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where :$flex$.Product_Attribute = 'PRICING_ATTRIBUTE1' and msiv.enabled_flag = 'Y' and msiv.organization_id = qp_util.get_item_validation_org union select category_id id, category_name value, category_desc description from qp_item_categories_v qicv where :$flex$.Product_Attribute = 'PRICING_ATTRIBUTE2' and qicv.functional_area_id in (select distinct qsfm.functional_area_id from qp_sourcesystem_fnarea_map qsfm where qsfm.enabled_flag = 'Y' ) and qicv.functional_area_id in (select distinct qfv.functional_area_id from qp_fass_v qfv where qfv.pte_code = fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY') and qfv.application_short_name = fnd_profile.value('QP_SOURCE_SYSTEM_CODE') and qfv.enabled_flag = 'Y' ) order by value US Product Value (Item/Item Cat) 12 55 2=2 qllv.product_attr_value=:p_prod_attrib_val_oth LOV custom 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 => :$flex$.pricing_transaction_entity , p_context_type => 'PRODUCT' , p_context_value => qp_util.get_context('QP_ATTR_DEFNS_PRICING',:$flex$.product_attribute_context) , p_attribute_value => qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',:$flex$.product_attribute_context, :$flex$.product_attribute) , p_entered_value => null , p_operator => '=' , p_delimiter => '^' ) ) lov where not (:$flex$.product_attribute_context = 'ITEM' and :$flex$.product_attribute in ('PRICING_ATTRIBUTE1','PRICING_ATTRIBUTE2')) order by value select 'ALL' from dual where :$flex$.product_attribute = 'PRICING_ATTRIBUTE3' US Product Value (Other) 13 60 :p_category_set_id LOV custom Y select mcsv.category_set_id id, mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where exists (select null from mtl_item_categories mic where mic.organization_id=fnd_profile.value('QP_ORGANIZATION_ID') and mic.category_set_id = mcsv.category_set_id ) order by mcsv.category_set_name US Item Category Set Use the Item Category Set and Item Category Parameters to download all Items within the specified Price Lists that are assigned to the specified Item Categories. 14 70 2=2 qllv.product_attr_value in ( select to_char(mic.inventory_item_id) from mtl_item_categories mic, mtl_categories_kfv mck where mic.category_id = mck.category_id and mic.category_set_id = :p_category_set_id and mic.organization_id=fnd_profile.value('QP_ORGANIZATION_ID') and mck.concatenated_segments = :p_category ) and qllv.product_attribute_context='ITEM' and qllv.product_attribute='PRICING_ATTRIBUTE1' LOV custom Y select mcbk.concatenated_segments value, mct.description from mtl_category_sets_b mcsb, mtl_categories_b_kfv mcbk, mtl_categories_tl mct where mcsb.category_set_id=:$flex$.item_category_set and mcsb.structure_id=mcbk.structure_id and mcbk.category_id=mct.category_id and mct.language=userenv('lang') and exists (select null from mtl_item_categories mic where mic.organization_id=fnd_profile.value('QP_ORGANIZATION_ID') and mic.category_set_id = mcsb.category_set_id and mic.category_id = mcbk.category_id) order by mcbk.concatenated_segments US Item Category Use the Item Category Set and Item Category Parameters to download all Items within the specified Price Lists that are assigned to the specified Item Categories. 15 80 2=2 :p_effective_date between nvl(qllv.start_date_active,:p_effective_date) and nvl(qllv.end_date_active,:p_effective_date) Date sysdate US Effective Date 16 85 2=2 nvl(qllv.end_date_active,:p_effective_date_from) >= :p_effective_date_from Date US Effective Date From 17 87 2=2 nvl(qllv.start_date_active,:p_effective_date_to) <= :p_effective_date_to Date US Effective Date To 18 90 :p_show_price_list_lines LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.Upload_Mode like '%U' Y US Download Price List Lines Download the Price List Lines. 19 100 2=2 qllv.list_line_type_code=:p_list_line_type_code LOV custom Y select ql.lookup_code id, ql.meaning value, null description from qp_lookups ql where ql.lookup_type = 'LIST_LINE_TYPE_CODE' and ql.lookup_code in ('PLL','PBH') and :$flex$.Download_Price_List_Lines = 'Y' order by value US Line Type Restrict the downloaded Price List Lines by Line Type. 20 120 :p_show_pricing_attributes LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.Download_Price_List_Lines = 'Y' select :$flex$.End_Date_Matching_List_Lines from dual US Download Pricing Attributes Download the Price List Lines assigned Pricing Attributes. 21 130 :p_show_qualifiers LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.Upload_Mode like '%U' US Download Qualifiers Download the Price List Lists assigned Qualifiers. 22 140 :p_show_secondary_price_lists LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$flex$.Upload_Mode like '%U' US Download Secondary Price Lists Download the Price List Lists assigned Secondary Price Lists. 2EDDBC735136764053CC1A11E7FAE053 Default SYSADMIN 9 ACTIVE 16 COMMENTS 6 CURRENCY 36 DELETE_LINE 43 DELETE_PRICE_BREAK 50 DELETE_PRICING_ATTRIBUTE 64 DELETE_QUALIFIER 67 DELETE_SECONDARY_PRICE_LIST 3 DESCRIPTION 10 EFFECTIVE_FROM 11 EFFECTIVE_TO 12 FREIGHT_TERMS 4 GLOBAL 27 LINE_ACCUMULATION_ATTRIBUTE 26 LINE_APPLICATION_METHOD 28 LINE_BREAK_UOM 29 LINE_BREAK_UOM_ATTRIBUTE 31 LINE_DYNAMIC_FORMULA 34 LINE_END_DATE 17 LINE_NO 35 LINE_PRECEDENCE 25 LINE_PRICE_BREAK_TYPE 23 LINE_PRIMARY_UOM_FLAG 19 LINE_PRODUCT_ATTRIBUTE 21 LINE_PRODUCT_ATTRIBUTE_DESC 18 LINE_PRODUCT_CONTEXT 22 LINE_PRODUCT_UOM 20 LINE_PRODUCT_VALUE 33 LINE_START_DATE 32 LINE_STATIC_FORMULA 24 LINE_TYPE 30 LINE_VALUE 15 MOBILE_DOWNLOAD 7 MULTI_CURRENCY_CONVERSION 2 NAME 5 OPERATING_UNIT 14 PAYMENT_TERM 40 PRICE_BREAK_APPLICATION_METHOD 41 PRICE_BREAK_FORMULA 39 PRICE_BREAK_PRICE 42 PRICE_BREAK_RECURRING_VALUE 37 PRICE_BREAK_VALUE_FROM 38 PRICE_BREAK_VALUE_TO 45 PRICING_ATTRIBUTE 44 PRICING_ATTRIBUTE_CONTEXT 46 PRICING_ATTRIBUTE_OPERATOR 47 PRICING_ATTRIBUTE_VALUE_FROM 49 PRICING_ATTRIBUTE_VALUE_TO 48 PRICING_ATTRIBUTE_VAL_FR_DESC 56 QUALIFIER_APPLIES_PARTY_HIER 55 QUALIFIER_ATTRIBUTE 54 QUALIFIER_CONTEXT 63 QUALIFIER_END_DATE 51 QUALIFIER_GROUP 53 QUALIFIER_GROUPING_NUMBER 52 QUALIFIER_GROUP_QUALIFIER_ID 58 QUALIFIER_OPERATOR 57 QUALIFIER_PRECEDENCE 62 QUALIFIER_START_DATE 59 QUALIFIER_VALUE_FROM 60 QUALIFIER_VALUE_FROM_DESC 61 QUALIFIER_VALUE_TO 8 ROUND_TO 65 SECONDARY_PRICE_LIST 66 SECONDARY_PRICE_LIST_PRECEDENC 13 SHIP_METHOD 1 TYPE S Site 2EDDBC735136764053CC1A11E7FAE053 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 OVERRIDE_LIST_LINE_ Char varchar2 2000 :$flex$.End_Date_Matching_List_Lines Y 8 PRICE_LIST_ROW_ID Number number Y 9 QUALIFIER_GROUP_ROW_ID Number number Y 10 QUALIFIER_ROW_ID Number number Y 11 SECONDARY_PRICE_LIST_ROW_ID Number number Y 12 PRICE_LIST_LINE_ROW_ID Number number Y 13 PRICE_BREAK_LINE_ROW_ID Number number Y 14 PRICING_ATTRIBUTE_ROW_ID Number number Y 15 PTE_CODE Char varchar2 30 :$flex$.Pricing_Transaction_Entity Y Y Y 16 SOURCE_SYSTEM_CODE Char varchar2 30 :$flex$.Source_System_Code Y Y Y 17 TYPE LOV custom varchar2 Y select ql.lookup_code id, ql.meaning value, null description from qp_lookups ql where ql.lookup_type = 'LIST_TYPE_CODE' and lookup_code = 'PRL' order by value select ql.lookup_code id, ql.meaning value from qp_lookups ql where ql.lookup_type = 'LIST_TYPE_CODE' order by value xxen_util.meaning('PRL','LIST_TYPE_CODE',661) Y Y 18 LIST_ORIG_SYS_REF Char varchar2 50 Y Y 19 NAME LOV custom varchar2 240 select qslhv.list_header_id id, qslhv.name value, qslhv.description || ' (' || decode(qslhv.global_flag,'Y','Global',haouv.name) || ')' description from qp_secu_list_headers_vl qslhv, hr_all_organization_units_vl haouv where qslhv.orig_org_id = haouv.organization_id (+) and nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code = xxen_util.lookup_code(:$column$.type,'LIST_TYPE_CODE',661) and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') order by value Y 20 DESCRIPTION Char varchar2 2000 select qslhv.description from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 21 GLOBAL LOV custom varchar2 Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' and (lookup_code = 'Y' or nvl(qp_security.security_on,'N') = 'Y') order by value,description select lookup_code id, meaning value from fnd_lookups where fnd_lookups.lookup_type='YES_NO' select nvl( ( select xxen_util.meaning(nvl(qslhv.global_flag,'Y'),'YES_NO',0) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name ), xxen_util.meaning('Y','YES_NO',0) ) from dual Y 22 OPERATING_UNIT LOV custom varchar2 Y select hou.organization_id id, hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and xxen_util.lookup_code(:$column$.global,'YES_NO',0) = 'N' and nvl(qp_security.security_on,'N') = 'Y' order by hou.name select hou.organization_id id, hou.name value from hr_operating_units hou select qp_util.get_ou_name(qslhv.orig_org_id) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 23 CURRENCY LOV custom varchar2 30 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag = 'Y' and fcv.currency_flag='Y' and trunc(sysdate) between nvl(fcv.start_date_active,trunc(sysdate)) and nvl(fcv.end_date_active,trunc(sysdate)) order by value select qslhv.currency_code from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name Y 24 MULTI_CURRENCY_CONVERSION LOV custom varchar2 240 Y select qclb.currency_header_id id, qclt.name value, qclt.description from qp_currency_lists_tl qclt, qp_currency_lists_b qclb where QP_UTIL.Get_QP_Status = 'I' and fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED') = 'Y' and qclb.base_currency_code = :$column$.currency and qclt.currency_header_id = qclb.currency_header_id and qclt.language = userenv('LANG') order by value select qclb.currency_header_id id, qclt.name value from qp_currency_lists_tl qclt, qp_currency_lists_b qclb where qclb.base_currency_code = :$column$.currency and qclt.currency_header_id = qclb.currency_header_id and qclt.language = userenv('LANG') select (select qclv.name from qp_currency_lists_vl qclv where qslhv.currency_header_id=qclv.currency_header_id) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 25 ROUND_TO LOV custom number select x.value, null description from ( select -1 * decode(fnd_profile.value('QP_UNIT_PRICE_PRECISION_TYPE'),'EXTENDED',fcv.extended_precision,fcv.precision) value from fnd_currencies_vl fcv where fcv.currency_code = :$column$.currency and (not(qp_util.Get_QP_Status = 'I' and fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED') = 'Y') or :$column$.multi_currency_conversion is null ) union select qclv.base_rounding_factor value from qp_currency_lists_vl qclv where qp_util.Get_QP_Status = 'I' and fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED') = 'Y' and qclv.base_currency_code = :$column$.currency and qclv.name = :$column$.multi_currency_conversion ) x order by value select coalesce( ( select qslhv.rounding_factor from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name and qslhv.currency_code = :$column$.currency ), ( select qclv.base_rounding_factor value from qp_currency_lists_vl qclv where qp_util.get_qp_status = 'I' and fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED') = 'Y' and qclv.base_currency_code = :$column$.currency and qclv.name = :$column$.multi_currency_conversion ), ( select -1 * decode(fnd_profile.value('QP_UNIT_PRICE_PRECISION_TYPE'),'EXTENDED',fcv.extended_precision,fcv.precision) value from fnd_currencies_vl fcv where fcv.currency_code = :$column$.currency and (not(qp_util.Get_QP_Status = 'I' and fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED') = 'Y') or :$column$.multi_currency_conversion is null ) ) ) from dual Y 26 ACTIVE LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description select nvl( ( select xxen_util.meaning(nvl(qslhv.active_flag,'N'),'YES_NO',0) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name ), xxen_util.meaning('Y','YES_NO',0) ) from dual 27 EFFECTIVE_FROM Date date select qslhv.start_date_active from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 28 EFFECTIVE_TO Date date select qslhv.end_date_active from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 29 FREIGHT_TERMS LOV custom varchar2 Y select oftav.freight_terms_code id, oftav.freight_terms value, oftav.description from oe_frght_terms_active_v oftav order by value select oftav.freight_terms_code id, oftav.freight_terms value from oe_frght_terms_active_v oftav select xxen_util.meaning(qslhv.freight_terms_code,'FREIGHT_TERMS',660) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 30 SHIP_METHOD LOV custom varchar2 30 Y select osmv.lookup_code id, osmv.lookup_code value, osmv.meaning description from oe_ship_methods_v osmv where osmv.enabled_flag = 'Y' order by value select qslhv.ship_method_code from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 31 PAYMENT_TERM LOV custom varchar2 15 Y select distinct rt.term_id id, rt.name value, rt.description from ra_terms rt where trunc(sysdate) <= nvl(rt.end_date_active,trunc(sysdate)) order by value select distinct rt.term_id id, rt.name value from ra_terms rt where trunc(sysdate) <= nvl(rt.end_date_active,trunc(sysdate)) select (select rtt.name from ra_terms_tl rtt where qslhv.terms_id=rtt.term_id and rtt.language(+)=userenv('lang')) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 32 MOBILE_DOWNLOAD 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' select xxen_util.meaning(decode(qslhv.mobile_download,'Y','Y',null),'YES_NO',0) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 33 COMMENTS Char varchar2 2000 select qslhv.comments from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 34 LIST_HEADER_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_LIST_HEADERS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name select xxen_util.display_flexfield_context(661,'QP_LIST_HEADERS',qslhv.context) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 35 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE1',qslhv.row_id,qslhv.attribute1) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 36 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE2',qslhv.row_id,qslhv.attribute2) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 37 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE3',qslhv.row_id,qslhv.attribute3) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 38 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE4',qslhv.row_id,qslhv.attribute4) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 39 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE5',qslhv.row_id,qslhv.attribute5) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 40 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE6',qslhv.row_id,qslhv.attribute6) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 41 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE7',qslhv.row_id,qslhv.attribute7) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 42 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE8',qslhv.row_id,qslhv.attribute8) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 43 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE9',qslhv.row_id,qslhv.attribute9) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 44 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE10',qslhv.row_id,qslhv.attribute10) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 45 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE11',qslhv.row_id,qslhv.attribute11) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 46 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE12',qslhv.row_id,qslhv.attribute12) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 47 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE13',qslhv.row_id,qslhv.attribute13) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 48 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE14',qslhv.row_id,qslhv.attribute14) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 49 LIST_HEADER_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_LIST_HEADERS', p_context_name => :$column$.list_header_dff_context, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.list_header_attribute1, p_attribute2 => :$column$.list_header_attribute2, p_attribute3 => :$column$.list_header_attribute3, p_attribute4 => :$column$.list_header_attribute4, p_attribute5 => :$column$.list_header_attribute5, p_attribute6 => :$column$.list_header_attribute6, p_attribute7 => :$column$.list_header_attribute7, p_attribute8 => :$column$.list_header_attribute8, p_attribute9 => :$column$.list_header_attribute9, p_attribute10 => :$column$.list_header_attribute10, p_attribute11 => :$column$.list_header_attribute11, p_attribute12 => :$column$.list_header_attribute12, p_attribute13 => :$column$.list_header_attribute13, p_attribute14 => :$column$.list_header_attribute14, p_attribute15 => :$column$.list_header_attribute15 ) ) lov order by value select xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE15',qslhv.row_id,qslhv.attribute15) from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.list_type_code in ('PRL') and nvl(qslhv.list_source_code,'null') not in ('BSO','OKS') and qslhv.update_flag = 'Y' and (qslhv.global_flag='Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and qslhv.name = :$column$.name 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_LIST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 50 LINE_ORIG_SYS_REF Char varchar2 Y Y 51 LINE_NO Char varchar2 30 By default, the upload will treat all rows with the same Product, Unit of Measure, and Start Date as the same Price List Line. If you have different Price List Lines that use the same Product, Unit of Measure and Start Date but which have different Pricing Attribute assignments, the use the ‘Line No’ column to distinguish the different Price List Lines. If not specified, then all rows with the same Product, Unit of Measure, and Start Date will be uploaded as a single Price List Line and any Pricing Attributes will be added to that Price List Line. The Line Number entered here is not uploaded to Oracle. It is only used by the upload to distinguish different lines with the same product, Unit of Measure, and Start date. Y 52 LINE_PRODUCT_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 = 'PRODUCT' 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 = 'PRODUCT' Y 53 LINE_PRODUCT_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 = 'PRODUCT' and x.context_value = :$column$.line_product_context and x.enabled = 'Y' and nvl(x.segment_level,'LINE') = 'LINE' 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 = 'PRODUCT' and x.context_value = :$column$.line_product_context and x.enabled = 'Y' and nvl(x.segment_level,'LINE') = 'LINE' Y 54 LINE_PRODUCT_VALUE 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 => 'PRODUCT' , p_context_value => :$column$.line_product_context , p_attribute_value => :$column$.line_product_attribute , p_entered_value => :$column$.line_product_value , p_operator => '=' , p_delimiter => '^' ) ) lov order by value select regexp_substr(lov.column_value,'[^^]+',1,2) id, regexp_substr(lov.column_value,'[^^]+',1,2) value from table( xxen_qp_upload.attribute_value_lov ( p_pte_code => :$column$.pte_code , p_context_type => 'PRODUCT' , p_context_value => :$column$.line_product_context , p_attribute_value => :$column$.line_product_attribute , p_entered_value => :$column$.line_product_value , p_operator => '=' , p_delimiter => '^' , p_exact_match => 'Y' ) ) lov Y 55 LINE_PRODUCT_ATTRIBUTE_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 => 'PRODUCT' , p_context_value => :$column$.line_product_context , p_attribute_value => :$column$.line_product_attribute , p_entered_value => :$column$.line_product_value , p_operator => '=' , p_delimiter => '^' , p_exact_match => 'Y' ) ) lov where :$column$.line_product_value is not null order by value select regexp_substr(lov.column_value,'[^^]+',1,3) id, 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 => 'PRODUCT' , p_context_value => :$column$.line_product_context , p_attribute_value => :$column$.line_product_attribute , p_entered_value => :$column$.line_product_value , p_operator => '=' , p_delimiter => '^' , p_exact_match => 'Y' ) ) lov where :$column$.line_product_value is not null select regexp_substr(lov.column_value,'[^^]+',1,3) from table( xxen_qp_upload.attribute_value_lov ( p_pte_code => :$column$.pte_code , p_context_type => 'PRODUCT' , p_context_value => :$column$.line_product_context , p_attribute_value => :$column$.line_product_attribute , p_entered_value => :$column$.line_product_value , p_operator => '=' , p_delimiter => '^' , p_exact_match => 'Y' ) ) lov where :$column$.line_product_value is not null Y 56 LINE_PRODUCT_UOM LOV custom varchar2 3 Y select x.id, x.value, x.description from ( select -- uom other muomv.uom_code id, muomv.uom_code value, muomv.unit_of_measure_tl || ' (' || muomv.uom_class || ')' description from mtl_units_of_measure_vl muomv where not (xxen_qp_upload.get_context_code(:$column$.pte_code,'PRODUCT',:$column$.line_product_context) = 'ITEM' and xxen_qp_upload.get_attribute_code(:$column$.pte_code,'PRODUCT',:$column$.line_product_context,:$column$.line_product_attribute) in ('PRICING_ATTRIBUTE1','PRICING_ATTRIBUTE2') ) and nvl(muomv.disable_date, trunc(sysdate)+1 ) > trunc(sysdate) union select -- uom item miuv.uom_code id, miuv.uom_code value, miuv.unit_of_measure_tl || ' (' || miuv.uom_class || ')' description from mtl_system_items_vl msiv, mtl_item_uoms_view miuv where msiv.organization_id = miuv.organization_id and msiv.inventory_item_id = miuv.inventory_item_id and xxen_qp_upload.get_context_code(:$column$.pte_code,'PRODUCT',:$column$.line_product_context) = 'ITEM' and xxen_qp_upload.get_attribute_code(:$column$.pte_code,'PRODUCT',:$column$.line_product_context,:$column$.line_product_attribute) = 'PRICING_ATTRIBUTE1' and msiv.organization_id = qp_util.get_item_validation_org and msiv.concatenated_segments = :$column$.line_product_value union select -- uom item category muomv.uom_code id, muomv.uom_code value, muomv.unit_of_measure_tl || ' (' || muomv.uom_class || ')' description from mtl_units_of_measure_vl muomv where xxen_qp_upload.get_context_code(:$column$.pte_code,'PRODUCT',:$column$.line_product_context) = 'ITEM' and xxen_qp_upload.get_attribute_code(:$column$.pte_code,'PRODUCT',:$column$.line_product_context,:$column$.line_product_attribute) = 'PRICING_ATTRIBUTE2' and nvl(muomv.disable_date, trunc(sysdate)+1 ) > trunc(sysdate) and exists (select /*+no_unnest*/ 1 from mtl_system_items_vl msiv, mtl_uom_conversions muc where muomv.uom_code = muc.uom_code and msiv.organization_id = qp_util.get_item_validation_org and msiv.inventory_item_id in (select inventory_item_id from mtl_item_categories mic, mtl_categories_b_kfv mcbk where mic.category_id = mcbk.category_id and mic.organization_id = qp_util.get_item_validation_org and (mcbk.concatenated_segments = :$column$.line_product_value or exists (select 'Y' from eni_denorm_hierarchies edh, mtl_categories_b_kfv mcbk2 where edh.parent_id = mcbk2.category_id and mcbk2.concatenated_segments = :$column$.line_product_value and edh.child_id = mic.category_id and exists (select 'Y' from qp_sourcesystem_fnarea_map qsfn, qp_pte_source_systems qpss, mtl_default_category_sets mdcs, mtl_category_sets mcs where qsfn.pte_source_system_id = qpss.pte_source_system_id and qpss.pte_code = :$column$.pte_code and qpss.application_short_name = :$column$.source_system_code and qsfn.functional_area_id = mdcs.functional_area_id and mdcs.category_set_id = mcs.category_set_id and mcs.hierarchy_enabled = 'Y' and qsfn.enabled_flag = 'Y' and qpss.enabled_flag = 'Y' ) ) ) ) and ( ( (msiv.allowed_units_lookup_code in (1,3) and muc.inventory_item_id = msiv.inventory_item_id) or ( muc.inventory_item_id = 0 and muomv.base_uom_flag = 'Y' and muomv.uom_class = muc.uom_class and muc.uom_class in (select muom.uom_class from mtl_units_of_measure muom where muom.uom_code = msiv.primary_uom_code) ) or ( muc.inventory_item_id = 0 and muc.uom_code in (select mucc.to_uom_code from mtl_uom_class_conversions mucc where mucc.inventory_item_id = msiv.inventory_item_id and nvl(mucc.disable_date, trunc(sysdate)+1) > trunc(sysdate)) ) ) or ( msiv.allowed_units_lookup_code in (2,3) and muc.inventory_item_id = 0 and (muc.uom_class in (select mucc.to_uom_class from mtl_uom_class_conversions mucc where mucc.inventory_item_id = msiv.inventory_item_id and nvl(mucc.disable_date, trunc(sysdate)+1) > trunc(sysdate)) or muc.uom_class = (select muom.uom_class from mtl_units_of_measure muom where muom.uom_code = msiv.primary_uom_code) ) ) ) ) ) x order by value select muomv.uom_code id, muomv.uom_code value from mtl_units_of_measure_vl muomv select msiv.primary_uom_code from mtl_system_items_vl msiv where xxen_qp_upload.get_context_code(:$column$.pte_code,'PRODUCT',:$column$.line_product_context) = 'ITEM' and xxen_qp_upload.get_attribute_code(:$column$.pte_code,'PRODUCT',:$column$.line_product_context,:$column$.line_product_attribute) = 'PRICING_ATTRIBUTE1' and msiv.organization_id = qp_util.get_item_validation_org and msiv.concatenated_segments = :$column$.line_product_value 57 LINE_PRIMARY_UOM_FLAG 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' 58 LINE_TYPE LOV custom varchar2 Y select ql.lookup_code id, ql.meaning value, null description from qp_lookups ql where :$column$.line_product_value is not null and ql.lookup_type = 'LIST_LINE_TYPE_CODE' and ql.lookup_code in ('PLL','PBH') order by value select ql.lookup_code id, ql.meaning value from qp_lookups ql where ql.lookup_type = 'LIST_LINE_TYPE_CODE' and ql.lookup_code in ('PLL','PBH') select ql.meaning from qp_lookups ql where :$column$.line_product_value is not null and ql.lookup_type = 'LIST_LINE_TYPE_CODE' and ql.lookup_code = 'PLL' Y 59 LINE_PRICE_BREAK_TYPE LOV custom varchar2 Y select ql.lookup_code id, ql.meaning value, null description from qp_lookups ql where :$column$.line_type = xxen_util.meaning('PBH','LIST_LINE_TYPE_CODE',661) and ql.lookup_type = 'PRICE_BREAK_TYPE_CODE' and ql.lookup_code in ('POINT','RANGE') order by value select ql.lookup_code id, ql.meaning value from qp_lookups ql where ql.lookup_type = 'PRICE_BREAK_TYPE_CODE' and ql.lookup_code in ('POINT','RANGE') 60 LINE_APPLICATION_METHOD LOV custom varchar2 Y select x.id, x.value, x.description from ( select ql.lookup_code id, ql.meaning value, null description from qp_lookups ql where ql.lookup_type = 'ARITHMETIC_OPERATOR' and (ql.lookup_code = 'UNIT_PRICE' or (ql.lookup_code = 'BLOCK_PRICE' and :$column$.line_type = xxen_util.meaning('PBH','LIST_LINE_TYPE_CODE',661) and ql.enabled_flag = 'Y') ) union select ql.lookup_code id, ql.meaning value, null description from qp_lookups ql, mtl_system_items_vl msiv where xxen_qp_upload.get_context_code(:$column$.pte_code,'PRODUCT',:$column$.line_product_context) = 'ITEM' and xxen_qp_upload.get_attribute_code(:$column$.pte_code,'PRODUCT',:$column$.line_product_context,:$column$.line_product_attribute) = 'PRICING_ATTRIBUTE1' and msiv.organization_id = qp_util.get_item_validation_org and msiv.concatenated_segments = :$column$.line_product_value and msiv.service_item_flag = 'Y' and ql.lookup_type = 'ARITHMETIC_OPERATOR' and ql.lookup_code = 'PERCENT_PRICE' ) x order by x.value select ql.lookup_code id, ql.meaning value from qp_lookups ql where ql.lookup_type = 'ARITHMETIC_OPERATOR' select ql.meaning from qp_lookups ql where ql.lookup_type = 'ARITHMETIC_OPERATOR' and :$column$.line_product_value is not null and ql.lookup_code = 'UNIT_PRICE' 61 LINE_ACCUMULATION_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(30) path 'SEGMENT_LEVEL' ) x where :$column$.line_type = xxen_util.meaning('PBH','LIST_LINE_TYPE_CODE',661) and :$column$.line_price_break_type = xxen_util.meaning('RANGE','PRICE_BREAK_TYPE_CODE',661) and x.context_type = 'PRICING_ATTRIBUTE' and x.context_code = 'VOLUME' and x.enabled = 'Y' and nvl(x.segment_level,'LINE') = 'LINE' and x.id = 'PRICING_ATTRIBUTE10' 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 = 'PRICING_ATTRIBUTE' and x.context_code = 'VOLUME' and x.enabled = 'Y' and nvl(x.segment_level,'LINE') = 'LINE' and x.id = 'PRICING_ATTRIBUTE10' 62 LINE_BREAK_UOM LOV custom varchar2 3 Y select x.id, x.value, x.description from ( select -- uom other muomv.uom_code id, muomv.uom_code value, muomv.unit_of_measure_tl || ' (' || muomv.uom_class || ')' description from mtl_units_of_measure_vl muomv where nvl(muomv.disable_date, trunc(sysdate)+1 ) > trunc(sysdate) ) x where :$column$.line_type = xxen_util.meaning('PBH','LIST_LINE_TYPE_CODE',661) and :$column$.line_application_method = xxen_util.meaning('UNIT_PRICE','ARITHMETIC_OPERATOR',661) order by value 63 LINE_BREAK_UOM_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(30) path 'SEGMENT_LEVEL' ) x where :$column$.line_break_uom is not null and x.context_type = 'PRICING_ATTRIBUTE' and x.context_code = 'BREAK_UOM' and nvl(x.segment_level,'LINE') = 'LINE' 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(30) path 'SEGMENT_LEVEL' ) x where :$column$.line_application_method = xxen_util.meaning('UNIT_PRICE','ARITHMETIC_OPERATOR',661) and x.context_type = 'PRICING_ATTRIBUTE' and x.context_code = 'BREAK_UOM' and nvl(x.segment_level,'LINE') = 'LINE' 64 LINE_VALUE Number number 65 LINE_DYNAMIC_FORMULA LOV custom varchar2 Y select qpfv.price_formula_id id, qpfv.name value, qpfv.description from qp_price_formulas_vl qpfv where :$column$.line_type = xxen_util.meaning('PLL','LIST_LINE_TYPE_CODE',661) and trunc(sysdate) between nvl(qpfv.start_date_active, trunc(sysdate)) and nvl(qpfv.end_date_active, trunc(sysdate)) order by value select qpfv.price_formula_id id, qpfv.name value from qp_price_formulas_vl qpfv where trunc(sysdate) between nvl(qpfv.start_date_active, trunc(sysdate)) and nvl(qpfv.end_date_active, trunc(sysdate)) 66 LINE_STATIC_FORMULA LOV custom varchar2 Y select qpfv.price_formula_id id, qpfv.name value, qpfv.description from qp_price_formulas_vl qpfv where :$column$.line_type = xxen_util.meaning('PLL','LIST_LINE_TYPE_CODE',661) and trunc(sysdate) between nvl(qpfv.start_date_active, trunc(sysdate)) and nvl(qpfv.end_date_active, trunc(sysdate)) order by value select qpfv.price_formula_id id, qpfv.name value from qp_price_formulas_vl qpfv where trunc(sysdate) between nvl(qpfv.start_date_active, trunc(sysdate)) and nvl(qpfv.end_date_active, trunc(sysdate)) 67 LINE_START_DATE Date date 68 LINE_END_DATE Date date 69 LINE_PRECEDENCE Number number xxen_qp_upload.get_attribute_info(:$column$.pte_code,'PRODUCT',:$column$.line_product_context,:$column$.line_product_attribute,'PRECEDENCE') 70 DELETE_LINE 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' 71 PRICE_BREAK_ORIG_SYS_REF Char varchar2 Y Y 72 PRICE_BREAK_PRICING_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 :$column$.line_type = xxen_util.meaning('PBH','LIST_LINE_TYPE_CODE',661) and x.type = 'PRICING_ATTRIBUTE' and x.id = 'VOLUME' 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 = 'PRICING_ATTRIBUTE' and x.id = 'VOLUME' select 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 :$column$.line_type = xxen_util.meaning('PBH','LIST_LINE_TYPE_CODE',661) and x.type = 'PRICING_ATTRIBUTE' and x.id = 'VOLUME' order by value Y 73 PRICE_BREAK_PRICING_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(30) path 'SEGMENT_LEVEL' ) x where :$column$.line_type = xxen_util.meaning('PBH','LIST_LINE_TYPE_CODE',661) and x.context_type = 'PRICING_ATTRIBUTE' and x.context_value = :$column$.price_break_pricing_context and x.enabled = 'Y' and nvl(x.segment_level,'LINE') = 'LINE' and x.id = 'PRICING_ATTRIBUTE10' 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 = 'PRICING_ATTRIBUTE' and x.context_value = :$column$.price_break_pricing_context and x.enabled = 'Y' and nvl(x.segment_level,'LINE') = 'LINE' and x.id = 'PRICING_ATTRIBUTE10' select 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(30) path 'SEGMENT_LEVEL' ) x where :$column$.line_type = xxen_util.meaning('PBH','LIST_LINE_TYPE_CODE',661) and x.context_type = 'PRICING_ATTRIBUTE' and x.context_value = :$column$.price_break_pricing_context and x.enabled = 'Y' and nvl(x.segment_level,'LINE') = 'LINE' and x.id = 'PRICING_ATTRIBUTE10' Y 74 PRICE_BREAK_VALUE_FROM Number number 75 PRICE_BREAK_VALUE_TO Number number 76 PRICE_BREAK_PRICE Number number 77 PRICE_BREAK_APPLICATION_METHOD LOV custom varchar2 Y select ql.lookup_code id, ql.meaning value, null description from qp_lookups ql where :$column$.line_type = xxen_util.meaning('PBH','LIST_LINE_TYPE_CODE',661) and ql.lookup_type = 'ARITHMETIC_OPERATOR' and ( (ql.lookup_code = 'UNIT_PRICE' and :$column$.line_application_method != xxen_util.meaning('BLOCK_PRICE','ARITHMETIC_OPERATOR',661) ) or (ql.lookup_code in ('BLOCK_PRICE','BREAKUNIT_PRICE') and :$column$.line_price_break_type = xxen_util.meaning('RANGE','PRICE_BREAK_TYPE_CODE',661) ) or (ql.lookup_code = 'BLOCK_PRICE' and :$column$.line_application_method = xxen_util.meaning('BLOCK_PRICE','ARITHMETIC_OPERATOR',661) and :$column$.line_price_break_type = xxen_util.meaning('POINT','PRICE_BREAK_TYPE_CODE',661) ) or (xxen_qp_upload.get_context_code(:$column$.pte_code,'PRODUCT',:$column$.line_product_context) = 'ITEM' and xxen_qp_upload.get_attribute_code(:$column$.pte_code,'PRODUCT',:$column$.line_product_context,:$column$.line_product_attribute) = 'PRICING_ATTRIBUTE1' and (select msiv.service_item_flag from mtl_system_items_vl msiv where msiv.organization_id = qp_util.get_item_validation_org and msiv.concatenated_segments = :$column$.line_product_value) = 'Y' and ((:$column$.line_application_method = xxen_util.meaning('BLOCK_PRICE','ARITHMETIC_OPERATOR',661) and ql.lookup_code in ('BLOCK_PRICE','BREAKUNIT_PRICE', 'PERCENT_PRICE')) or (:$column$.line_application_method != xxen_util.meaning('BLOCK_PRICE','ARITHMETIC_OPERATOR',661) and ql.lookup_code in ('UNIT_PRICE', 'PERCENT_PRICE')) ) ) ) order by value select ql.lookup_code id, ql.meaning value from qp_lookups ql where ql.lookup_type = 'ARITHMETIC_OPERATOR' 78 PRICE_BREAK_FORMULA LOV custom varchar2 Y select qpfv.price_formula_id id, qpfv.name value, qpfv.description from qp_price_formulas_vl qpfv where :$column$.line_type = xxen_util.meaning('PBH','LIST_LINE_TYPE_CODE',661) and trunc(sysdate) between nvl(qpfv.start_date_active, trunc(sysdate)) and nvl(qpfv.end_date_active, trunc(sysdate)) order by value select qpfv.price_formula_id id, qpfv.name value from qp_price_formulas_vl qpfv where trunc(sysdate) between nvl(qpfv.start_date_active, trunc(sysdate)) and nvl(qpfv.end_date_active, trunc(sysdate)) 79 PRICE_BREAK_RECURRING_VALUE Number number 80 DELETE_PRICE_BREAK 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' 81 PRICING_ATTRIBUTE_ORIG_SYS_REF Char varchar2 50 Y Y 82 PRICING_ATTRIBUTE_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 = 'PRICING_ATTRIBUTE' 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 = 'PRICING_ATTRIBUTE' 83 PRICING_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 = 'PRICING_ATTRIBUTE' and x.context_value = :$column$.pricing_attribute_context and x.enabled = 'Y' and nvl(x.segment_level,'LINE') = 'LINE' 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 = 'PRICING_ATTRIBUTE' and x.context_value = :$column$.pricing_attribute_context and x.enabled = 'Y' and nvl(x.segment_level,'LINE') = 'LINE' 84 PRICING_ATTRIBUTE_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 85 PRICING_ATTRIBUTE_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 => 'PRICING_ATTRIBUTE' , p_context_value => :$column$.pricing_attribute_context , p_attribute_value => :$column$.pricing_attribute , p_entered_value => :$column$.pricing_attribute_value_from , p_operator => :$column$.pricing_attribute_operator , p_delimiter => '^' ) ) lov order by value select regexp_substr(lov.column_value,'[^^]+',1,2) id, regexp_substr(lov.column_value,'[^^]+',1,2) value from table( xxen_qp_upload.attribute_value_lov ( p_pte_code => :$column$.pte_code , p_context_type => 'PRICING_ATTRIBUTE' , p_context_value => :$column$.pricing_attribute_context , p_attribute_value => :$column$.pricing_attribute , p_entered_value => :$column$.pricing_attribute_value_from , p_operator => :$column$.pricing_attribute_operator , p_delimiter => '^' , p_exact_match => 'Y' ) ) lov 86 PRICING_ATTRIBUTE_VAL_FR_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 => 'PRICING_ATTRIBUTE' , p_context_value => :$column$.pricing_attribute_context , p_attribute_value => :$column$.pricing_attribute , p_entered_value => :$column$.pricing_attribute_value_from , p_operator => :$column$.pricing_attribute_operator , p_delimiter => '^' , p_exact_match => 'Y' ) ) lov where :$column$.pricing_attribute_value_from is not null order by value select regexp_substr(lov.column_value,'[^^]+',1,3) id, 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 => 'PRICING_ATTRIBUTE' , p_context_value => :$column$.pricing_attribute_context , p_attribute_value => :$column$.pricing_attribute , p_entered_value => :$column$.pricing_attribute_value_from , p_operator => :$column$.pricing_attribute_operator , p_delimiter => '^' , p_exact_match => 'Y' ) ) lov where :$column$.pricing_attribute_value_from is not null select regexp_substr(lov.column_value,'[^^]+',1,3) from table( xxen_qp_upload.attribute_value_lov ( p_pte_code => :$column$.pte_code , p_context_type => 'PRICING_ATTRIBUTE' , p_context_value => :$column$.pricing_attribute_context , p_attribute_value => :$column$.pricing_attribute , p_entered_value => :$column$.pricing_attribute_value_from , p_operator => :$column$.pricing_attribute_operator , p_delimiter => '^' , p_exact_match => 'Y' ) ) lov where :$column$.pricing_attribute_value_from is not null 87 PRICING_ATTRIBUTE_VALUE_TO Char varchar2 88 DELETE_PRICING_ATTRIBUTE 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' 89 LIST_LINE_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_LIST_LINES' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 90 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE1' 91 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE2' 92 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE3' 93 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE4' 94 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE5' 95 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE6' 96 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE7' 97 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE8' 98 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE9' 99 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE10' 100 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE11' 101 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE12' 102 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE13' 103 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE14' 104 LIST_LINE_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_LIST_LINES', p_context_name => :$column$.list_line_dff_context, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.list_line_attribute1, p_attribute2 => :$column$.list_line_attribute2, p_attribute3 => :$column$.list_line_attribute3, p_attribute4 => :$column$.list_line_attribute4, p_attribute5 => :$column$.list_line_attribute5, p_attribute6 => :$column$.list_line_attribute6, p_attribute7 => :$column$.list_line_attribute7, p_attribute8 => :$column$.list_line_attribute8, p_attribute9 => :$column$.list_line_attribute9, p_attribute10 => :$column$.list_line_attribute10, p_attribute11 => :$column$.list_line_attribute11, p_attribute12 => :$column$.list_line_attribute12, p_attribute13 => :$column$.list_line_attribute13, p_attribute14 => :$column$.list_line_attribute14, p_attribute15 => :$column$.list_line_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_LIST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE15' 105 QUALIFIER_ORIG_SYS_REF Char varchar2 Y Y 106 QUALIFIER_GROUP LOV custom varchar2 240 Y select qqr.qualifier_rule_id id, qqr.name value, qqr.description from qp_qualifier_rules qqr order by value select qqr.qualifier_rule_id id, qqr.name value from qp_qualifier_rules qqr Optionally select the Qualifier Group to copy to the Price List. If you only specify the Qualifier Group, and leave all other qualifier columns blank, the upload will copy all the qualifiers from the Qualifier Group to the Price List. Note: this only works when entering new qualifiers on a row which does not already have qualifier details (downloaded). 107 QUALIFIER_GROUP_QUALIFIER_ID LOV custom number Y select distinct qqv.qualifier_id value, '(' || qqv.qualifier_grouping_no || ') ' || qp_util.get_context('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context) || ': ' || qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context,qqv.qualifier_attribute) || ' ' || qqv.comparision_operator_code || ' ' || 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)) || nvl2(qqv.qualifier_attr_value_to,' AND ' || 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),null) description from qp_qualifier_rules qqr, qp_qualifiers_v qqv where qqr.qualifier_rule_id = qqv.qualifier_rule_id and qqr.name = :$column$.qualifier_group order by description Optionally select the Qualifier Group Qualifier to copy to the Price List. You can optionally choose to copy the details of a specific Qualifier from the Qualifier Group. In this scenario you must individually select, on separate rows, each qualifier from the Qualifier Group that you want to include on the Price List. 108 QUALIFIER_GROUPING_NUMBER Number number select distinct qq.qualifier_grouping_no from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 109 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' select 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' and x.id in (select qq.qualifier_context from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id ) 110 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') select x.value from qp_qualifier_rules qqr, qp_qualifiers qq, 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 qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id and x.context_type = 'QUALIFIER' and qq.qualifier_context = x.context_code and qq.qualifier_attribute = x.id and x.enabled = 'Y' and nvl(x.segment_level,'LINE') in ('LINE','BOTH') 111 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' 112 QUALIFIER_PRECEDENCE Number number xxen_qp_upload.get_attribute_info(:$column$.pte_code,'QUALIFIER',:$column$.qualifier_context,:$column$.qualifier_attribute,'PRECEDENCE') 113 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 select qq.comparison_operator_code from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 114 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 select regexp_substr(lov.column_value,'[^^]+',1,2) id, regexp_substr(lov.column_value,'[^^]+',1,2) 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 select (select regexp_substr(lov.column_value,'[^^]+',1,2) from table( xxen_qp_upload.attribute_value_lov ( p_pte_code => :$column$.pte_code , p_context_type => 'QUALIFIER' , p_context_value => qp_util.get_context('QP_ATTR_DEFNS_QUALIFIER',qq.qualifier_context) , p_attribute_value => qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_QUALIFIER',qq.qualifier_context,qq.qualifier_attribute) , p_entered_value => rtrim(replace(qp_util.get_attribute_value('QP_ATTR_DEFNS_QUALIFIER',qq.qualifier_context,qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qq.qualifier_context,qq.qualifier_attribute),qq.qualifier_attr_value,qq.comparison_operator_code),chr(0),null)) , p_operator => qq.comparison_operator_code , p_delimiter => '^' , p_exact_match => 'Y' ) ) lov where rownum <= 1 ) value from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 115 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) id, 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 select x.value from ( select (select regexp_substr(lov.column_value,'[^^]+',1,3) from table( xxen_qp_upload.attribute_value_lov ( p_pte_code => :$column$.pte_code , p_context_type => 'QUALIFIER' , p_context_value => qp_util.get_context('QP_ATTR_DEFNS_QUALIFIER',qq.qualifier_context) , p_attribute_value => qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_QUALIFIER',qq.qualifier_context,qq.qualifier_attribute) , p_entered_value => rtrim(replace(qp_util.get_attribute_value('QP_ATTR_DEFNS_QUALIFIER',qq.qualifier_context,qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qq.qualifier_context,qq.qualifier_attribute),qq.qualifier_attr_value,qq.comparison_operator_code),chr(0),null)) , p_operator => qq.comparison_operator_code , p_delimiter => '^' , p_exact_match => 'Y' ) ) lov where rownum <= 1 ) value from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id union 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 and :$column$.qualifier_group_qualifier_id is null ) x 116 QUALIFIER_VALUE_TO Char varchar2 select qq.qualifier_attr_value_to from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 117 QUALIFIER_START_DATE Date date select qq.start_date_active from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 118 QUALIFIER_END_DATE Date date select qq.end_date_active from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 119 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' 120 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 select xxen_util.display_flexfield_context(661,'QP_QUALIFIERS',qq.context) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 121 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE1',qq.rowid,qq.attribute1) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 122 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE2',qq.rowid,qq.attribute2) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 123 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE3',qq.rowid,qq.attribute3) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 124 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE4',qq.rowid,qq.attribute4) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 125 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE5',qq.rowid,qq.attribute5) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 126 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE6',qq.rowid,qq.attribute6) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 127 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE7',qq.rowid,qq.attribute7) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 128 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE8',qq.rowid,qq.attribute8) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 129 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE9',qq.rowid,qq.attribute9) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 130 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE10',qq.rowid,qq.attribute10) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 131 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE11',qq.rowid,qq.attribute11) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 132 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE12',qq.rowid,qq.attribute12) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 133 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE13',qq.rowid,qq.attribute13) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 134 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE14',qq.rowid,qq.attribute14) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 135 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 xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qq.context,'ATTRIBUTE15',qq.rowid,qq.attribute15) from qp_qualifier_rules qqr, qp_qualifiers qq where qqr.qualifier_rule_id = qq.qualifier_rule_id and qqr.name = :$column$.qualifier_group and qq.qualifier_id = :$column$.qualifier_group_qualifier_id 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' 136 SEC_PRICE_LIST_ORIG_SYS_REF Char varchar2 Y Y 137 SECONDARY_PRICE_LIST LOV custom varchar2 240 select qslhv.list_header_id id, qslhv.name value, qslhv.description from qp_secu_list_headers_v qslhv where qslhv.name != :$column$.name and qslhv.currency_code = :$column$.currency and nvl(qslhv.pte_code,'ORDFUL') <> 'LOGSTX' and qslhv.view_flag = 'Y' and nvl(qslhv.list_source_code,'X') <> 'BSO' and (nvl(xxen_util.lookup_code(:$column$.global,'YES_NO',0),'N') = 'Y' or (nvl(xxen_util.lookup_code(:$column$.global,'YES_NO',0),'N') = 'N' and (nvl(qslhv.global_flag, 'N') = 'Y' or nvl(qslhv.orig_org_id,-9999) = nvl((select hou.organization_id from hr_operating_units hou where hou.name = :$column$.operating_unit), -9999) ) ) ) and qslhv.list_header_id not in (select qsplv2.list_header_id from qp_secu_list_headers_v qslhv2, qp_secondary_price_lists_v qsplv2 where qslhv2.name = :$column$.name and qsplv2.parent_price_list_id = qslhv2.list_header_id ) order by value 138 SECONDARY_PRICE_LIST_PRECEDENC Number number case when :$column$.secondary_price_list is not null then xxen_qp_upload.get_attribute_info(:$column$.pte_code,'QUALIFIER','MODLIST','QUALIFIER_ATTRIBUTE4','PRECEDENCE') end 139 DELETE_SECONDARY_PRICE_LIST 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' 140 PRICE_LIST_ID Number number Y 141 QUALIFIER_ID Number number Y 142 SEC_PRICE_LIST_QUALIFIER_ID Number number Y 143 PRICE_LIST_LINE_ID Number number Y 144 PRICE_BREAK_LINE_ID Number number Y 145 PRICING_ATTRIBUTE_ID Number number Y 146 ROW_TYPE Char varchar2 20 Y 147 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 override_list_line_ in Char OVERRIDE_LIST_LINE_ U 7 p_price_list_row_id out Number PRICE_LIST_ROW_ID U 8 p_qualifier_group_row_id out Number QUALIFIER_GROUP_ROW_ID U 9 p_qualifier_row_id out Number QUALIFIER_ROW_ID U 10 p_secondary_price_list_row_id out Number SECONDARY_PRICE_LIST_ROW_ID U 11 p_price_list_line_row_id out Number PRICE_LIST_LINE_ROW_ID U 12 p_price_break_line_row_id out Number PRICE_BREAK_LINE_ROW_ID U 13 p_pricing_attribute_row_id out Number PRICING_ATTRIBUTE_ROW_ID U 14 p_pte_code in Char PTE_CODE U 15 p_source_system_code in Char SOURCE_SYSTEM_CODE U 16 p_type in Char TYPE U 17 p_list_orig_sys_ref in Char LIST_ORIG_SYS_REF U 18 p_name in Char NAME value U 19 p_description in Char DESCRIPTION U 20 p_global in Char GLOBAL U 21 p_org_id in Number OPERATING_UNIT U 22 p_currency in Char CURRENCY U 23 p_currency_header_id in Number MULTI_CURRENCY_CONVERSION U 24 p_round_to in Number ROUND_TO U 25 p_active in Char ACTIVE U 26 p_effective_from in Date EFFECTIVE_FROM U 27 p_effective_to in Date EFFECTIVE_TO U 28 p_freight_terms_code in Char FREIGHT_TERMS U 29 p_ship_method_code in Char SHIP_METHOD U 30 p_payment_terms_id in Number PAYMENT_TERM U 31 p_mobile_download in Char MOBILE_DOWNLOAD U 32 p_comments in Char COMMENTS U 33 p_list_source_code in Char U 34 p_sold_to_org_id in Number U 35 p_shareable in Char U 36 p_list_dff_context in Char LIST_HEADER_DFF_CONTEXT U 37 p_list_attribute1 in Char LIST_HEADER_ATTRIBUTE1 U 38 p_list_attribute2 in Char LIST_HEADER_ATTRIBUTE2 U 39 p_list_attribute3 in Char LIST_HEADER_ATTRIBUTE3 U 40 p_list_attribute4 in Char LIST_HEADER_ATTRIBUTE4 U 41 p_list_attribute5 in Char LIST_HEADER_ATTRIBUTE5 U 42 p_list_attribute6 in Char LIST_HEADER_ATTRIBUTE6 U 43 p_list_attribute7 in Char LIST_HEADER_ATTRIBUTE7 U 44 p_list_attribute8 in Char LIST_HEADER_ATTRIBUTE8 U 45 p_list_attribute9 in Char LIST_HEADER_ATTRIBUTE9 U 46 p_list_attribute10 in Char LIST_HEADER_ATTRIBUTE10 U 47 p_list_attribute11 in Char LIST_HEADER_ATTRIBUTE11 U 48 p_list_attribute12 in Char LIST_HEADER_ATTRIBUTE12 U 49 p_list_attribute13 in Char LIST_HEADER_ATTRIBUTE13 U 50 p_list_attribute14 in Char LIST_HEADER_ATTRIBUTE14 U 51 p_list_attribute15 in Char LIST_HEADER_ATTRIBUTE15 U 52 p_qualifier_orig_sys_ref in Char QUALIFIER_ORIG_SYS_REF U 53 p_qualifier_rule_id in Number QUALIFIER_GROUP U 55 p_qualifier_grouping_number in Number QUALIFIER_GROUPING_NUMBER U 56 p_qualifier_context in Char QUALIFIER_CONTEXT U 57 p_qualifier_attribute in Char QUALIFIER_ATTRIBUTE U 58 p_qualifier_applies_party_hier in Char QUALIFIER_APPLIES_PARTY_HIER U 59 p_qualifier_precedence in Number QUALIFIER_PRECEDENCE U 60 p_qualifier_operator in Char QUALIFIER_OPERATOR U 61 p_qualifier_value_from in Char QUALIFIER_VALUE_FROM U 62 p_qualifier_value_from_mng in Char QUALIFIER_VALUE_FROM_DESC U 63 p_qualifier_value_to in Char QUALIFIER_VALUE_TO U 64 p_qualifier_start_date in Date QUALIFIER_START_DATE U 65 p_qualifier_end_date in Date QUALIFIER_END_DATE U 66 p_delete_qualifier in Char DELETE_QUALIFIER U 67 p_qualifier_dff_context in Char QUALIFIER_DFF_CONTEXT U 68 p_qualifier_attribute1 in Char QUALIFIER_ATTRIBUTE1 U 69 p_qualifier_attribute2 in Char QUALIFIER_ATTRIBUTE2 U 70 p_qualifier_attribute3 in Char QUALIFIER_ATTRIBUTE3 U 71 p_qualifier_attribute4 in Char QUALIFIER_ATTRIBUTE4 U 72 p_qualifier_attribute5 in Char QUALIFIER_ATTRIBUTE5 U 73 p_qualifier_attribute6 in Char QUALIFIER_ATTRIBUTE6 U 74 p_qualifier_attribute7 in Char QUALIFIER_ATTRIBUTE7 U 75 p_qualifier_attribute8 in Char QUALIFIER_ATTRIBUTE8 U 76 p_qualifier_attribute9 in Char QUALIFIER_ATTRIBUTE9 U 77 p_qualifier_attribute10 in Char QUALIFIER_ATTRIBUTE10 U 78 p_qualifier_attribute11 in Char QUALIFIER_ATTRIBUTE11 U 79 p_qualifier_attribute12 in Char QUALIFIER_ATTRIBUTE12 U 80 p_qualifier_attribute13 in Char QUALIFIER_ATTRIBUTE13 U 81 p_qualifier_attribute14 in Char QUALIFIER_ATTRIBUTE14 U 82 p_qualifier_attribute15 in Char QUALIFIER_ATTRIBUTE15 U 83 p_sec_price_list_orig_sys_ref in Char SEC_PRICE_LIST_ORIG_SYS_REF U 84 p_secondary_price_list in Char SECONDARY_PRICE_LIST value U 85 p_secondary_price_list_precede in Number SECONDARY_PRICE_LIST_PRECEDENC U 86 p_delete_secondary_price_list in Char DELETE_SECONDARY_PRICE_LIST U 87 p_line_orig_sys_ref in Char LINE_ORIG_SYS_REF U 88 p_list_line_no in Char LINE_NO U 89 p_line_product_context in Char LINE_PRODUCT_CONTEXT U 90 p_line_product_attribute in Char LINE_PRODUCT_ATTRIBUTE U 91 p_line_product_value in Char LINE_PRODUCT_VALUE U 92 p_line_product_attribute_desc in Char LINE_PRODUCT_ATTRIBUTE_DESC U 93 p_line_product_uom_code in Char LINE_PRODUCT_UOM U 94 p_line_primary_uom_flag in Char LINE_PRIMARY_UOM_FLAG U 95 p_line_type_code in Char LINE_TYPE U 96 p_line_price_break_type in Char LINE_PRICE_BREAK_TYPE U 97 p_line_application_method in Char LINE_APPLICATION_METHOD U 98 p_line_accumulation_attribute in Char LINE_ACCUMULATION_ATTRIBUTE U 99 p_line_break_uom in Char LINE_BREAK_UOM value U 100 p_line_break_uom_attribute in Char LINE_BREAK_UOM_ATTRIBUTE U 101 p_line_operand in Number LINE_VALUE U 102 p_line_dynamic_formula_id in Number LINE_DYNAMIC_FORMULA U 103 p_line_static_formula_id in Number LINE_STATIC_FORMULA U 104 p_line_start_date in Date LINE_START_DATE U 105 p_line_end_date in Date LINE_END_DATE U 106 p_line_precedence in Number LINE_PRECEDENCE U 107 p_delete_line in Char DELETE_LINE U 108 p_line_dff_context in Char LIST_LINE_DFF_CONTEXT U 109 p_line_attribute1 in Char LIST_LINE_ATTRIBUTE1 U 110 p_line_attribute2 in Char LIST_LINE_ATTRIBUTE2 U 111 p_line_attribute3 in Char LIST_LINE_ATTRIBUTE3 U 112 p_line_attribute4 in Char LIST_LINE_ATTRIBUTE4 U 113 p_line_attribute5 in Char LIST_LINE_ATTRIBUTE5 U 114 p_line_attribute6 in Char LIST_LINE_ATTRIBUTE6 U 115 p_line_attribute7 in Char LIST_LINE_ATTRIBUTE7 U 116 p_line_attribute8 in Char LIST_LINE_ATTRIBUTE8 U 117 p_line_attribute9 in Char LIST_LINE_ATTRIBUTE9 U 118 p_line_attribute10 in Char LIST_LINE_ATTRIBUTE10 U 119 p_line_attribute11 in Char LIST_LINE_ATTRIBUTE11 U 120 p_line_attribute12 in Char LIST_LINE_ATTRIBUTE12 U 121 p_line_attribute13 in Char LIST_LINE_ATTRIBUTE13 U 122 p_line_attribute14 in Char LIST_LINE_ATTRIBUTE14 U 123 p_line_attribute15 in Char LIST_LINE_ATTRIBUTE15 U 124 p_price_break_orig_sys_ref in Char PRICE_BREAK_ORIG_SYS_REF U 125 p_price_break_pricing_context in Char PRICE_BREAK_PRICING_CONTEXT U 126 p_price_break_pricing_attribut in Char PRICE_BREAK_PRICING_ATTRIBUTE U 127 p_price_break_value_from in Char PRICE_BREAK_VALUE_FROM U 128 p_price_break_value_to in Char PRICE_BREAK_VALUE_TO U 129 p_price_break_price in Number PRICE_BREAK_PRICE U 130 p_price_break_application_meth in Char PRICE_BREAK_APPLICATION_METHOD U 131 p_price_break_formula_id in Number PRICE_BREAK_FORMULA U 132 p_price_break_recurring_value in Number PRICE_BREAK_RECURRING_VALUE U 133 p_delete_price_break in Char DELETE_PRICE_BREAK U 134 p_pricing_attrib_orig_sys_ref in Char PRICING_ATTRIBUTE_ORIG_SYS_REF U 135 p_pricing_attribute_context in Char PRICING_ATTRIBUTE_CONTEXT U 136 p_pricing_attribute in Char PRICING_ATTRIBUTE U 137 p_pricing_attribute_operator in Char PRICING_ATTRIBUTE_OPERATOR U 138 p_pricing_attribute_value_from in Char PRICING_ATTRIBUTE_VALUE_FROM U 139 p_pricing_attribute_val_fr_mng in Char PRICING_ATTRIBUTE_VAL_FR_DESC U 140 p_pricing_attribute_value_to in Char PRICING_ATTRIBUTE_VALUE_TO U 141 p_delete_pricing_attribute in Char DELETE_PRICING_ATTRIBUTE U 142 p_price_list_id in Number PRICE_LIST_ID U 143 p_qualifier_id in Number QUALIFIER_ID U 144 p_sec_price_list_qualifier_id in Number SEC_PRICE_LIST_QUALIFIER_ID U 145 p_price_list_line_id in Number PRICE_LIST_LINE_ID U 146 p_price_break_line_id in Number PRICE_BREAK_LINE_ID U 147 p_pricing_attribute_id in Number PRICING_ATTRIBUTE_ID Error SQL Order By x.name, x.upload_row, x.secondary_price_list_precedenc, x.secondary_price_list, x.qualifier_grouping_number, x.qualifier_precedence, x.qualifier_context, x.qualifier_attribute, x.line_start_date desc, x.line_product_context, x.line_product_attribute, x.line_product_value, x.price_list_line_id, nvl2(x.pricing_attribute_id,1,2), x.pricing_attribute_id, x.price_break_value_from, x.price_break_line_id Success SQL select xu.action_, xu.status_, xu. message_, xu.request_id_, xu.modified_columns_, xu.upload_mode_, xu.override_list_line_, xu.price_list_row_id, xu.qualifier_group_row_id, xu.qualifier_row_id, xu.secondary_price_list_row_id, xu.price_list_line_row_id, xu.price_break_line_row_id, xu.pricing_attribute_row_id, -- Price List Header qslhv.pte_code pte_code, qslhv.source_system_code source_system_code, xxen_util.meaning(qslhv.list_type_code,'LIST_TYPE_CODE',661) type, qslhv.orig_system_header_ref list_orig_sys_ref, qslhv.name name, qslhv.description description, xxen_util.meaning(nvl(qslhv.global_flag,'Y'),'YES_NO',0) global, qp_util.get_ou_name(qslhv.orig_org_id) operating_unit, qslhv.currency_code currency, (select qclv.name from qp_currency_lists_vl qclv where qslhv.currency_header_id=qclv.currency_header_id) multi_currency_conversion, qslhv.rounding_factor round_to, xxen_util.meaning(nvl(qslhv.active_flag,'N'),'YES_NO',0) active, qslhv.start_date_active effective_from, qslhv.end_date_active effective_to, xxen_util.meaning(qslhv.freight_terms_code,'FREIGHT_TERMS',660) freight_terms, qslhv.ship_method_code ship_method, (select rtt.name from ra_terms_tl rtt where qslhv.terms_id=rtt.term_id and rtt.language(+)=userenv('lang'))payment_term, xxen_util.meaning(qslhv.mobile_download,'YES_NO',0) mobile_download, qslhv.comments comments, -- Price List DFF Attributes xxen_util.display_flexfield_context(661,'QP_LIST_HEADERS',qslhv.context) list_header_dff_context, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE1',qslhv.row_id,qslhv.attribute1) list_header_attribute1, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE2',qslhv.row_id,qslhv.attribute2) list_header_attribute2, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE3',qslhv.row_id,qslhv.attribute3) list_header_attribute3, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE4',qslhv.row_id,qslhv.attribute4) list_header_attribute4, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE5',qslhv.row_id,qslhv.attribute5) list_header_attribute5, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE6',qslhv.row_id,qslhv.attribute6) list_header_attribute6, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE7',qslhv.row_id,qslhv.attribute7) list_header_attribute7, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE8',qslhv.row_id,qslhv.attribute8) list_header_attribute8, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE9',qslhv.row_id,qslhv.attribute9) list_header_attribute9, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE10',qslhv.row_id,qslhv.attribute10) list_header_attribute10, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE11',qslhv.row_id,qslhv.attribute11) list_header_attribute11, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE12',qslhv.row_id,qslhv.attribute12) list_header_attribute12, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE13',qslhv.row_id,qslhv.attribute13) list_header_attribute13, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE14',qslhv.row_id,qslhv.attribute14) list_header_attribute14, xxen_util.display_flexfield_value(661,'QP_LIST_HEADERS',qslhv.context,'ATTRIBUTE15',qslhv.row_id,qslhv.attribute15) list_header_attribute15, -- Price List Lines nvl(xxen_qp_upload.get_orig_sys_ref('LINE',qllv.list_line_id), case when xu.delete_line is not null then xu.line_orig_sys_ref end) line_orig_sys_ref, nvl(qllv.list_line_no, case when xu.delete_line is not null then xu.line_no end) line_no, nvl(qp_util.get_context('QP_ATTR_DEFNS_PRICING',qllv.product_attribute_context), case when xu.delete_line is not null then xu.line_product_context end) line_product_context, nvl(qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qllv.product_attribute_context, qllv.product_attribute), case when xu.delete_line is not null then xu.line_product_attribute end) line_product_attribute, nvl(qllv.product_attr_val_disp, case when xu.delete_line is not null then xu.line_product_value end) line_product_value, nvl( xxen_qp_upload.get_product_description(qslhv.pte_code,qp_util.get_context('QP_ATTR_DEFNS_PRICING',qllv.product_attribute_context),qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qllv.product_attribute_context,qllv.product_attribute),qllv.product_attr_value,qllv.product_attr_val_disp), case when xu.delete_line is not null then xu.line_product_attribute_desc end ) line_product_attribute_desc, nvl(qllv.product_uom_code, case when xu.delete_line is not null then xu.line_product_uom end) line_product_uom, nvl(xxen_util.meaning(qllv.primary_uom_flag,'YES_NO',0), case when xu.delete_line is not null then xu.line_primary_uom_flag end) line_primary_uom_flag, nvl(xxen_util.meaning(qllv.list_line_type_code,'LIST_LINE_TYPE_CODE',661), case when xu.delete_line is not null then xu.line_type end) line_type, nvl(xxen_util.meaning(qllv.price_break_type_code,'PRICE_BREAK_TYPE_CODE',661), case when xu.delete_line is not null then xu.line_price_break_type end) line_price_break_type, nvl(xxen_util.meaning(qllv.arithmetic_operator,'ARITHMETIC_OPERATOR',661), case when xu.delete_line is not null then xu.line_application_method end) line_application_method, nvl(replace(qllv.accum_attribute,chr(0),''), case when xu.delete_line is not null then xu.line_accumulation_attribute end) line_accumulation_attribute, nvl(qllv.break_uom_code, case when xu.delete_line is not null then xu.line_break_uom end) line_break_uom, nvl(qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qllv.break_uom_context,qllv.break_uom_attribute), case when xu.delete_line is not null then xu.line_break_uom_attribute end) line_break_uom_attribute, nvl(qllv.operand, case when xu.delete_line is not null then xu.line_value end) line_value, nvl(nvl2(qllv.price_by_formula_id,qp_qp_form_pricing_attr.get_formula(qllv.price_by_formula_id),null), case when xu.delete_line is not null then xu.line_dynamic_formula end) line_dynamic_formula, nvl(nvl2(qllv.generate_using_formula_id,qp_qp_form_pricing_attr.get_formula(qllv.generate_using_formula_id),null), case when xu.delete_line is not null then xu.line_static_formula end) line_static_formula, nvl(qllv.start_date_active, case when xu.delete_line is not null then xu.line_start_date end) line_start_date, nvl(qllv.end_date_active, case when xu.delete_line is not null then xu.line_end_date end) line_end_date, nvl(qllv.product_precedence, case when xu.delete_line is not null then xu.line_precedence end) line_precedence, xu.delete_line, -- Price Breaks nvl(xxen_qp_upload.get_orig_sys_ref('LINE',qpbv.list_line_id), case when xu.delete_line || xu.delete_price_break is not null then xu.price_break_orig_sys_ref end) price_break_orig_sys_ref, nvl(qp_util.Get_Context('QP_ATTR_DEFNS_PRICING',qpbv.pricing_attribute_context), case when xu.delete_line || xu.delete_price_break is not null then xu.price_break_pricing_context end) price_break_pricing_context, nvl(qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qpbv.pricing_attribute_context,qpbv.pricing_attribute), case when xu.delete_line || xu.delete_price_break is not null then xu.price_break_pricing_attribute end) price_break_pricing_attribute, nvl(qpbv.pricing_attr_value_from_number, case when xu.delete_line || xu.delete_price_break is not null then xu.price_break_value_from end) price_break_value_from, nvl(qpbv.pricing_attr_value_to_number, case when xu.delete_line || xu.delete_price_break is not null then xu.price_break_value_to end) price_break_value_to, nvl(qpbv.operand, case when xu.delete_line || xu.delete_price_break is not null then xu.price_break_price end) price_break_price, nvl(xxen_util.meaning(qpbv.arithmetic_operator,'ARITHMETIC_OPERATOR',661), case when xu.delete_line || xu.delete_price_break is not null then xu.price_break_application_method end) price_break_application_method, nvl(nvl2(qpbv.price_by_formula_id,qp_qp_form_pricing_attr.get_formula(qpbv.price_by_formula_id),null), case when xu.delete_line || xu.delete_price_break is not null then xu.price_break_formula end) price_break_formula, nvl(qpbv.recurring_value, case when xu.delete_line || xu.delete_price_break is not null then xu.price_break_recurring_value end) price_break_recurring_value, xu.delete_price_break, -- Price List Line Pricing Attributes nvl(qpa.orig_sys_pricing_attr_ref, case when xu.delete_line || xu.delete_pricing_attribute is not null then xu.pricing_attribute_orig_sys_ref end) pricing_attribute_orig_sys_ref, nvl(qp_util.get_context('QP_ATTR_DEFNS_PRICING',qpa.pricing_attribute_context), case when xu.delete_line || xu.delete_pricing_attribute is not null then xu.pricing_attribute_context end) pricing_attribute_context, nvl(qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qpa.pricing_attribute_context, qpa.pricing_attribute), case when xu.delete_line || xu.delete_pricing_attribute is not null then xu.pricing_attribute end) pricing_attribute, nvl(qpa.comparison_operator_code, case when xu.delete_line || xu.delete_pricing_attribute is not null then xu.pricing_attribute_operator end) pricing_attribute_operator, nvl(rtrim(replace(qp_util.get_attribute_value('QP_ATTR_DEFNS_PRICING',qpa.pricing_attribute_context,qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_PRICING',qpa.pricing_attribute_context, qpa.pricing_attribute),qpa.pricing_attr_value_from,qpa.comparison_operator_code),chr(0),null)), case when xu.delete_line || xu.delete_pricing_attribute is not null then xu.pricing_attribute_value_from end )pricing_attribute_value_from, nvl(rtrim(replace(qp_util.get_attribute_value_meaning('QP_ATTR_DEFNS_PRICING',qpa.pricing_attribute_context,qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_PRICING',qpa.pricing_attribute_context, qpa.pricing_attribute),qpa.pricing_attr_value_from,qpa.comparison_operator_code),chr(0),null)), case when xu.delete_line || xu.delete_pricing_attribute is not null then xu.pricing_attribute_val_fr_desc end ) pricing_attribute_val_fr_desc, nvl(qp_util.get_attribute_value('QP_ATTR_DEFNS_PRICING',qpa.pricing_attribute_context,qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_PRICING',qpa.pricing_attribute_context,qpa.pricing_attribute),qpa.pricing_attr_value_to,qpa.comparison_operator_code), case when xu.delete_line || xu.delete_pricing_attribute is not null then xu.pricing_attribute_value_to end ) pricing_attribute_value_to, xu.delete_pricing_attribute, -- Price List Line DFF Attributes xxen_util.display_flexfield_context(661,'QP_LIST_LINES',qllv.context) list_line_dff_context, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE1',qllv.row_id,qllv.attribute1) list_line_attribute1, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE2',qllv.row_id,qllv.attribute2) list_line_attribute2, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE3',qllv.row_id,qllv.attribute3) list_line_attribute3, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE4',qllv.row_id,qllv.attribute4) list_line_attribute4, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE5',qllv.row_id,qllv.attribute5) list_line_attribute5, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE6',qllv.row_id,qllv.attribute6) list_line_attribute6, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE7',qllv.row_id,qllv.attribute7) list_line_attribute7, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE8',qllv.row_id,qllv.attribute8) list_line_attribute8, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE9',qllv.row_id,qllv.attribute9) list_line_attribute9, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE10',qllv.row_id,qllv.attribute10) list_line_attribute10, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE11',qllv.row_id,qllv.attribute11) list_line_attribute11, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE12',qllv.row_id,qllv.attribute12) list_line_attribute12, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE13',qllv.row_id,qllv.attribute13) list_line_attribute13, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE14',qllv.row_id,qllv.attribute14) list_line_attribute14, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qllv.context,'ATTRIBUTE15',qllv.row_id,qllv.attribute15) list_line_attribute15, -- Price List Qualifiers nvl(xxen_qp_upload.get_orig_sys_ref('QUALIFIER',nvl(qqv.qualifier_id,qqv2.qualifier_id)), case when xu.delete_qualifier is not null then xu.qualifier_orig_sys_ref end) qualifier_orig_sys_ref, nvl(nvl(qqv.rule_name,qqv2.rule_name), case when xu.delete_qualifier is not null then xu.qualifier_group end) qualifier_group, xu.qualifier_group_qualifier_id, nvl(nvl(qqv.qualifier_grouping_no,qqv2.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',nvl(qqv.qualifier_context,qqv2.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',nvl(qqv.qualifier_context,qqv2.qualifier_context),nvl(qqv.qualifier_attribute,qqv2.qualifier_attribute)), case when xu.delete_qualifier is not null then xu.qualifier_attribute end) qualifier_attribute, nvl(xxen_util.meaning(nvl(qqv.qualify_hier_descendents_flag,qqv2.qualify_hier_descendents_flag),'YES_NO',0), case when xu.delete_qualifier is not null then xu.qualifier_applies_party_hier end) qualifier_applies_party_hier, nvl(nvl(qqv.qualifier_precedence,qqv2.qualifier_precedence), case when xu.delete_qualifier is not null then xu.qualifier_precedence end) qualifier_precedence, nvl(nvl(qqv.comparision_operator_code,qqv2.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',nvl(qqv.qualifier_context,qqv2.qualifier_context),qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',nvl(qqv.qualifier_context,qqv2.qualifier_context), nvl(qqv.qualifier_attribute,qqv2.qualifier_attribute)),nvl(qqv.qualifier_attr_value,qqv2.qualifier_attr_value),nvl(qqv.comparision_operator_code,qqv2.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',nvl(qqv.qualifier_context,qqv2.qualifier_context),qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',nvl(qqv.qualifier_context,qqv2.qualifier_context), nvl(qqv.qualifier_attribute,qqv2.qualifier_attribute)),nvl(qqv.qualifier_attr_value,qqv2.qualifier_attr_value),nvl(qqv.comparision_operator_code,qqv2.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',nvl(qqv.qualifier_context,qqv2.qualifier_context),qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',nvl(qqv.qualifier_context,qqv2.qualifier_context), nvl(qqv.qualifier_attribute,qqv2.qualifier_attribute)),nvl(qqv.qualifier_attr_value_to,qqv2.qualifier_attr_value_to),nvl(qqv.comparision_operator_code,qqv2.comparision_operator_code)), case when xu.delete_qualifier is not null then xu.qualifier_value_to end ) qualifier_value_to, nvl(nvl(qqv.start_date_active,qqv2.start_date_active),case when xu.delete_qualifier is not null then xu.qualifier_start_date end) qualifier_start_date, nvl(nvl(qqv.end_date_active,qqv2.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',nvl(qqv.context,qqv2.context)) qualifier_dff_context, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE1',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute1,qqv2.attribute1)) qualifier_attribute1, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE2',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute2,qqv2.attribute2)) qualifier_attribute2, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE3',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute3,qqv2.attribute3)) qualifier_attribute3, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE4',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute4,qqv2.attribute4)) qualifier_attribute4, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE5',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute5,qqv2.attribute5)) qualifier_attribute5, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE6',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute6,qqv2.attribute6)) qualifier_attribute6, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE7',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute7,qqv2.attribute7)) qualifier_attribute7, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE8',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute8,qqv2.attribute8)) qualifier_attribute8, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE9',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute9,qqv2.attribute9)) qualifier_attribute9, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE10',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute10,qqv2.attribute10)) qualifier_attribute10, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE11',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute11,qqv2.attribute11)) qualifier_attribute11, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE12',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute12,qqv2.attribute12)) qualifier_attribute12, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE13',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute13,qqv2.attribute13)) qualifier_attribute13, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE14',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute14,qqv2.attribute14)) qualifier_attribute14, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',nvl(qqv.context,qqv2.context),'ATTRIBUTE15',nvl(qqv.row_id,qqv2.row_id),nvl(qqv.attribute15,qqv2.attribute15)) qualifier_attribute15, -- Secondary Price Lists nvl(xxen_qp_upload.get_orig_sys_ref('LIST_HEADER',qsplv.list_header_id), case when xu.delete_secondary_price_list is not null then xu.sec_price_list_orig_sys_ref end) sec_price_list_orig_sys_ref, nvl(qsplv.name, case when xu.delete_secondary_price_list is not null then xu.secondary_price_list end) secondary_price_list, nvl(qsplv.precedence, case when xu.delete_secondary_price_list is not null then xu.secondary_price_list_precedenc end) secondary_price_list_precedenc, xu.delete_secondary_price_list, -- Ids qslhv.list_header_id price_list_id, nvl(qqv.qualifier_id,qqv2.qualifier_id) qualifier_id, qsplv.qualifier_id sec_price_list_qualifier_id, qllv.list_line_id price_list_line_id, qpbv.list_line_id price_break_line_id, qpa.pricing_attribute_id pricing_attribute_id, 'Result' row_type, xu.upload_row from xxen_qp_price_list_uplo_4975_u xu, qp_secu_list_headers_vl qslhv, qp_qualifiers_v qqv, qp_qualifiers_v qqv2, qp_secondary_price_lists_v qsplv, qp_list_lines_v qllv, qp_price_breaks_v qpbv, qp_pricing_attributes qpa where nvl(xu.status_code_,xxen_upload.status_error) = xxen_upload.status_success and xu.price_list_row_id = qslhv.list_header_id and xu.price_list_row_id = qqv.list_header_id (+) and xu.qualifier_row_id = qqv.qualifier_id (+) and xu.price_list_row_id = qqv2.list_header_id (+) and xu.qualifier_group_row_id = qqv2.created_from_rule_id (+) and xu.secondary_price_list_row_id = qsplv.qualifier_id (+) and xu.price_list_row_id = qllv.list_header_id (+) and xu.price_list_line_row_id = qllv.list_line_id (+) and xu.price_list_line_row_id = qpbv.parent_list_line_id (+) and xu.price_break_line_row_id = qpbv.list_line_id (+) and xu.pricing_attribute_row_id = qpa.pricing_attribute_id (+)