ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) 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) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 512261F078C90C0AE0630100007F5964Y 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) upload_row, :p_modifier_numbering modifier_numbering, to_number(null) mod_list_row_id, to_number(null) mod_line_row_id, to_number(null) qualifier_group_row_id, to_number(null) qualifier_row_id, to_number(null) price_break_line_row_id, to_number(null) pricing_attribute_row_id, to_number(null) excluder_row_id, to_number(null) buy_line_row_id, to_number(null) get_line_row_id, to_number(null) limit_row_id, to_number(null) limit_att_row_id, qp.* from ( -- -- Q1 List Header Qualifiers -- select -- -- Modifier 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) list_type, qslhv.orig_system_header_ref list_orig_sys_ref, qslhv.name list_number, qslhv.version_no list_version, qslhv.description list_name, qslhv.comments list_description, qslhv.currency_code list_currency, xxen_util.meaning(nvl(qslhv.global_flag,'Y'),'YES_NO',0) global_list, qp_util.get_ou_name(qslhv.orig_org_id) operating_unit, qslhv.start_date_active list_effective_from, qslhv.end_date_active list_effective_to, xxen_util.meaning(nvl(qslhv.active_flag,'N'),'YES_NO',0) list_is_active, xxen_util.meaning(decode(qslhv.automatic_flag,'Y','Y',null),'YES_NO',0) list_is_automatic, xxen_util.meaning(decode(qslhv.gsa_indicator,'Y','Y',null),'YES_NO',0) list_gsa_indicator, -- 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, -- -- Modifier Line -- summary null line_orig_sys_ref, null line_no, null line_modifier_level, null line_modifier_type, to_date(null) line_effective_from, to_date(null) line_effective_to, null line_automatic, null line_allow_override, null line_proration_type, null line_pricing_phase, null line_incompatibility_group, to_number(null) line_bucket, null line_product_attribute, null line_product_value, null line_product_description, to_number(null) line_precedence, null line_product_uom, -- Discounts/Charges null application_method, to_number(null) value, -- 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, -- -- Qualifiers xxen_util.meaning('HEADER','ZX_ROUNDING_LEVEL',0) qualifier_assignment_level, xxen_qp_upload.get_orig_sys_ref('QUALIFIER',qqv.qualifier_id) qualifier_orig_sys_ref, qqv.qualifier_grouping_no qualifier_grouping_number, qp_util.get_context('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context) qualifier_context, qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context,qqv.qualifier_attribute) qualifier_attribute, xxen_util.meaning(decode(qqv.qualify_hier_descendents_flag,'Y','Y',null),'YES_NO',0) qualifier_applies_party_hier, qqv.qualifier_precedence qualifier_precedence, qqv.comparision_operator_code qualifier_operator, rtrim(replace( qp_util.get_attribute_value ('QP_ATTR_DEFNS_QUALIFIER', qqv.qualifier_context, qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context, qqv.qualifier_attribute), qqv.qualifier_attr_value, qqv.comparision_operator_code ),chr(0),null) ) qualifier_value_from, rtrim(replace( qp_util.get_attribute_value_meaning ('QP_ATTR_DEFNS_QUALIFIER', qqv.qualifier_context, qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context, qqv.qualifier_attribute), qqv.qualifier_attr_value, qqv.comparision_operator_code ),chr(0),null) ) qualifier_value_from_desc, qp_util.get_attribute_value ('QP_ATTR_DEFNS_QUALIFIER', qqv.qualifier_context, qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context, qqv.qualifier_attribute), qqv.qualifier_attr_value_to, qqv.comparision_operator_code ) qualifier_value_to, qqv.start_date_active qualifier_start_date, qqv.end_date_active qualifier_end_date, null delete_qualifier, -- xxen_util.display_flexfield_context(661,'QP_QUALIFIERS',qqv.context) qualifier_dff_context, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE1',qqv.row_id,qqv.attribute1) qualifier_attribute1, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE2',qqv.row_id,qqv.attribute2) qualifier_attribute2, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE3',qqv.row_id,qqv.attribute3) qualifier_attribute3, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE4',qqv.row_id,qqv.attribute4) qualifier_attribute4, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE5',qqv.row_id,qqv.attribute5) qualifier_attribute5, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE6',qqv.row_id,qqv.attribute6) qualifier_attribute6, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE7',qqv.row_id,qqv.attribute7) qualifier_attribute7, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE8',qqv.row_id,qqv.attribute8) qualifier_attribute8, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE9',qqv.row_id,qqv.attribute9) qualifier_attribute9, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE10',qqv.row_id,qqv.attribute10) qualifier_attribute10, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE11',qqv.row_id,qqv.attribute11) qualifier_attribute11, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE12',qqv.row_id,qqv.attribute12) qualifier_attribute12, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE13',qqv.row_id,qqv.attribute13) qualifier_attribute13, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE14',qqv.row_id,qqv.attribute14) qualifier_attribute14, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE15',qqv.row_id,qqv.attribute15) qualifier_attribute15, -- -- IDs qslhv.list_header_id modifier_list_id, to_number(null) modifier_line_id, qqv.qualifier_id qualifier_id, 'Modifier List' row_type, 1.0 seq from qp_secu_list_headers_vl qslhv, qp_qualifiers_v qqv where 1=1 and :p_show_header_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 ((nvl(:p_gsa_pricing,'N') = 'N' and nvl(qslhv.gsa_indicator,'N') = 'N' and ((qp_util.get_qp_status = 'I' and qslhv.list_type_code in ('DLT', 'SLT', 'PRO', 'DEL', 'CHARGES')) or (qp_util.get_qp_status = 'S' and qslhv.list_type_code in ('DLT', 'SLT', 'CHARGES')) ) ) or (nvl(:p_gsa_pricing,'N') = 'Y' and nvl(qslhv.gsa_indicator,'N') = 'Y' and qslhv.list_type_code = 'DLT' and qslhv.active_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 (nvl(:p_gsa_pricing,'N') = 'N' or not (qqv.qualifier_context = 'CUSTOMER' and qqv.qualifier_attribute = 'QUALIFIER_ATTRIBUTE15' and qqv.qualifier_attr_value = 'Y') ) and exists (select null from qp_modifier_summary_v qmsv where 2=2 and qslhv.list_header_id = qmsv.list_header_id and (qmsv.pricing_attribute_context is null or qmsv.pricing_attribute_context = 'VOLUME') and nvl(qmsv.excluder_flag,'N') = 'N' ) -- union -- -- Q2 Modifier Lines -- select -- -- Modifier 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) list_type, qslhv.orig_system_header_ref list_orig_sys_ref, qslhv.name list_number, qslhv.version_no list_version, qslhv.description list_name, qslhv.comments list_description, qslhv.currency_code list_currency, xxen_util.meaning(nvl(qslhv.global_flag,'Y'),'YES_NO',0) global_list, qp_util.get_ou_name(qslhv.orig_org_id) operating_unit, qslhv.start_date_active list_effective_from, qslhv.end_date_active list_effective_to, xxen_util.meaning(nvl(qslhv.active_flag,'N'),'YES_NO',0) list_is_active, xxen_util.meaning(decode(qslhv.automatic_flag,'Y','Y',null),'YES_NO',0) list_is_automatic, xxen_util.meaning(decode(qslhv.gsa_indicator,'Y','Y',null),'YES_NO',0) list_gsa_indicator, -- 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, -- -- Modifier Line -- summary xxen_qp_upload.get_orig_sys_ref('LINE',qmsv.list_line_id) line_orig_sys_ref, qmsv.list_line_no line_no, qmsv.modifier_level line_modifier_level, qmsv.list_line_type line_modifier_type, qmsv.start_date_active line_effective_from, qmsv.end_date_active line_effective_to, xxen_util.meaning(decode(qmsv.automatic_flag,'Y','Y',null),'YES_NO',0) line_automatic, xxen_util.meaning(decode(qmsv.override_flag,'Y','Y',null),'YES_NO',0) line_allow_override, qmsv.proration_type line_proration_type, qmsv.pricing_phase line_pricing_phase, qmsv.incompatibility_grp line_incompatibility_group, qmsv.pricing_group_sequence line_bucket, qmsv.product_attribute_type line_product_attribute, qmsv.product_attr_value line_product_value, xxen_qp_upload.get_product_description (qslhv.pte_code, qp_util.get_context('QP_ATTR_DEFNS_PRICING',qmsv.product_attribute_context), qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qmsv.product_attribute_context,qmsv.product_attr), qmsv.product_attr_val, qmsv.product_attr_value ) line_product_description, qmsv.product_precedence line_precedence, qmsv.product_uom_code line_product_uom, -- Discounts/Charges qmsv.arithmetic_operator_type application_method, qmsv.operand value, -- Line DFF Attributes xxen_util.display_flexfield_context(661,'QP_LIST_LINES',qmsv.context) list_line_dff_context, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE1',qmsv.row_id,qmsv.attribute1) list_line_attribute1, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE2',qmsv.row_id,qmsv.attribute2) list_line_attribute2, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE3',qmsv.row_id,qmsv.attribute3) list_line_attribute3, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE4',qmsv.row_id,qmsv.attribute4) list_line_attribute4, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE5',qmsv.row_id,qmsv.attribute5) list_line_attribute5, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE6',qmsv.row_id,qmsv.attribute6) list_line_attribute6, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE7',qmsv.row_id,qmsv.attribute7) list_line_attribute7, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE8',qmsv.row_id,qmsv.attribute8) list_line_attribute8, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE9',qmsv.row_id,qmsv.attribute9) list_line_attribute9, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE10',qmsv.row_id,qmsv.attribute10) list_line_attribute10, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE11',qmsv.row_id,qmsv.attribute11) list_line_attribute11, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE12',qmsv.row_id,qmsv.attribute12) list_line_attribute12, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE13',qmsv.row_id,qmsv.attribute13) list_line_attribute13, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE14',qmsv.row_id,qmsv.attribute14) list_line_attribute14, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE15',qmsv.row_id,qmsv.attribute15) list_line_attribute15, -- -- Qualifiers null qualifier_assignment_level, null qualifier_orig_sys_ref, 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, -- 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, -- -- IDs qslhv.list_header_id modifier_list_id, qmsv.list_line_id modifier_line_id, to_number(null) qualifier_id, 'Modifier Line' row_type, 2.0 seq from qp_secu_list_headers_vl qslhv, qp_modifier_summary_v qmsv where 1=1 and 2=2 and :p_show_modifier_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 ((nvl(:p_gsa_pricing,'N') = 'N' and nvl(qslhv.gsa_indicator,'N') = 'N' and ((qp_util.get_qp_status = 'I' and qslhv.list_type_code in ('DLT', 'SLT', 'PRO', 'DEL', 'CHARGES')) or (qp_util.get_qp_status = 'S' and qslhv.list_type_code in ('DLT', 'SLT', 'CHARGES')) ) ) or (nvl(:p_gsa_pricing,'N') = 'Y' and nvl(qslhv.gsa_indicator,'N') = 'Y' and qslhv.list_type_code = 'DLT' and qslhv.active_flag = 'Y' ) ) and (qslhv.global_flag = 'Y' or mo_global.check_access(qslhv.orig_org_id) = 'Y') and -- modifier lines qslhv.list_header_id = qmsv.list_header_id and (qmsv.pricing_attribute_context is null or qmsv.pricing_attribute_context = 'VOLUME') and nvl(qmsv.excluder_flag,'N') = 'N' ) 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_modifier xxen_qp_upload.validate_modifier_row ( :$column$.pte_code , :$column$.source_system_code , nvl(:$column$.list_type,xxen_util.meaning('DLT','LIST_TYPE_CODE',661)) , :$column$.list_number , :$column$.list_version , :$column$.global_list , :$column$.operating_unit , :$column$.line_no , nvl(:$column$.line_modifier_level,case when :$column$.line_no is not null then xxen_util.meaning('LINE','MODIFIER_LEVEL_CODE',661) end) , nvl(:$column$.line_modifier_type,case when :$column$.line_no is not null then xxen_util.meaning('DIS','LIST_LINE_TYPE_CODE',661) end) , nvl(:$column$.line_pricing_phase,case when :$column$.line_no is not null then 'List Line Adjustment' end) , case when :$column$.line_no is not null then qp_util.get_context('QP_ATTR_DEFNS_PRICING','ITEM') end , nvl(:$column$.line_product_attribute,case when :$column$.line_no is not null then qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING', 'ITEM','PRICING_ATTRIBUTE1') end) , :$column$.line_product_value , :$column$.line_product_uom ) US QP GSA Pricing Upload This upload supports the creation and update of GSA Pricing Setup in Oracle Advanced Pricing. The upload supports creation/update/deletion of the following entities within a GSA Pricing List: - GSA Lists (created as a Modifier List) - GSA List Qualifiers (created as a Modifier List Qualifier) - GSA List Lines (created as Modifier Lines) Notes: When downloading existing GSA Lists into the upload excel; the List level Qualifiers and the List Lines will be downloaded into separate rows in the excel. This is to minimize the duplication of data in the excel. However: When entering List Header qualifiers, these can be added in the same excel row as the List Lines (i.e. You can upload an excel row containing list line details and a list header qualifier). Modifier Line Numbering ==================== The Modifier Numbering report parameter determines if you want the system to automatically generate Modifier Numbers when creating new GSA List Lines or if the line number specified in the Line No column in the upload should be retained. If Automatic is specified, any Line Numbers specified in the upload excel for new GSA List Lines will be replaced by a system generated line number on upload. The Line No column is required when entering list line details. The upload uses the combination of List Number, List Version, and Line No to identify the GSA List Line. If the combination already exists in Oracle the upload will update the existing GSA List Line, otherwise it will create a new GSA List Line. Enginatics R12 only Upload 1=1 2=2 :p_appl_sn :p_category_set_id :p_gsa_pricing :p_modifier_numbering :p_override_list_line :p_pte_code :p_show_header_qualifiers :p_show_modifier_lines :p_upload_mode 1 -50 :p_gsa_pricing LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y Y US GSA Pricing 2 -40 :p_pte_code LOV custom Y select lookup_code id, lookup_code value, null description from qp_lookups where lookup_type = 'QP_PTE_TYPE' order by value select nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'),'ORDFUL') from dual Y US Pricing Transaction Entity 3 -30 :p_appl_sn LOV custom Y select qpss.application_short_name id, qpss.application_short_name value, fav.application_name description from qp_pte_source_systems qpss, fnd_application_vl fav where qpss.application_short_name = fav.application_short_name and qpss.pte_code = :$flex$.Pricing_Transaction_Entity and qpss.enabled_flag = 'Y' order by value select fnd_profile.value('QP_SOURCE_SYSTEM_CODE') from dual Y US Source System Code 4 -20 2=2 qmsv.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 5 -10 2=2 qmsv.product_attr=: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 PRICING_ATTRIBUTE1 US Product Attribute 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 Y US Upload Mode 7 20 :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 Modifiers? Set this parameter to Yes to automatically end date any active matching modifier line on upload. 8 30 :p_modifier_numbering LOV custom Y select substr(flvv.lookup_code,1,1) id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'MANUAL OR AUTOMATIC' and flvv.view_application_id = 201 and (flvv.lookup_code = 'AUTOMATIC' or nvl(:$flex$.End_Date_Matching_Modifiers,'N') != 'Y') order by value A Y US Modifier Numbering The Modifier Numbering parameter determines if you want the system to automatically generate Modifier Numbers when creating new Modifiers or if it should retain the Line No specified in the upload excel. 9 40 1=1 qslhv.name=:p_modifier_list_name LOV custom Y select qslhv.name value, qslhv.description || ' (' || decode(qslhv.global_flag,'Y','Global',haouv.name) || ')' || nvl2(qslhv.version_no,' Vn: ' || qslhv.version_no,null) 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 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 (:$flex$.list_type is null or qslhv.list_type_code = :$flex$.list_type) and ((nvl(:$flex$.gsa_pricing,'N') = 'N' and nvl(qslhv.gsa_indicator,'N') = 'N' and qp_util.get_qp_status = 'I' and qslhv.list_type_code in ('DLT','SLT','PRO','CHARGES','DEL')) or (nvl(:$flex$.gsa_pricing,'N') = 'N' and nvl(qslhv.gsa_indicator,'N') = 'N' and qp_util.get_qp_status = 'S' and qslhv.list_type_code in ('DLT','SLT','CHARGES')) or (nvl(:$flex$.gsa_pricing,'N') = 'Y' and qslhv.gsa_indicator = 'Y' and qslhv.list_type_code in ('DLT')) ) order by value US List Number 10 50 1=1 lower(qslhv.name) like lower(:p_mod_list_name_like) || '%' Char US List Number Like 11 60 1=1 qslhv.description=:p_modifier_list_desc LOV custom Y select qslhv.description value, qslhv.name || ' (' || decode(qslhv.global_flag,'Y','Global',haouv.name) || ')' || nvl2(qslhv.version_no,' Vn: ' || qslhv.version_no,null) 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 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 (:$flex$.list_type is null or qslhv.list_type_code = :$flex$.list_type) and ((nvl(:$flex$.gsa_pricing,'N') = 'N' and nvl(qslhv.gsa_indicator,'N') = 'N' and qp_util.get_qp_status = 'I' and qslhv.list_type_code in ('DLT','SLT','PRO','CHARGES','DEL')) or (nvl(:$flex$.gsa_pricing,'N') = 'N' and nvl(qslhv.gsa_indicator,'N') = 'N' and qp_util.get_qp_status = 'S' and qslhv.list_type_code in ('DLT','SLT','CHARGES')) or (nvl(:$flex$.gsa_pricing,'N') = 'Y' and qslhv.gsa_indicator = 'Y' and qslhv.list_type_code in ('DLT')) ) order by value US List Name 12 70 1=1 lower(qslhv.description) like lower(:p_mod_list_desc_like) || '%' Char US List Name Like 13 80 1=1 qslhv.version_no=:p_version_no LOV custom Y select qslhv.version_no value, qslhv.name || ' (' || 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 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 (:$flex$.list_type is null or qslhv.list_type_code = :$flex$.list_type) and (qslhv.name = :$flex$.list_number or qslhv.description = :$flex$.list_name) and ((nvl(:$flex$.gsa_pricing,'N') = 'N' and nvl(qslhv.gsa_indicator,'N') = 'N' and qp_util.get_qp_status = 'I' and qslhv.list_type_code in ('DLT','SLT','PRO','CHARGES','DEL')) or (nvl(:$flex$.gsa_pricing,'N') = 'N' and nvl(qslhv.gsa_indicator,'N') = 'N' and qp_util.get_qp_status = 'S' and qslhv.list_type_code in ('DLT','SLT','CHARGES')) or (nvl(:$flex$.gsa_pricing,'N') = 'Y' and qslhv.gsa_indicator = 'Y' and qslhv.list_type_code in ('DLT')) ) order by value US Version Number 14 90 1=1 nvl(qslhv.global_flag,'N') = :p_global_flag LOV Oracle 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 US Global List 15 100 1=1 qp_util.get_ou_name(qslhv.orig_org_id)=:p_op_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) 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) order by hou.name US Operating Unit 16 110 2=2 qmsv.product_attr_val=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 order by value US Product Value (Item) 17 120 :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 Modifier Lists that are assigned to the specified Item Categories. 18 130 2=2 qmsv.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 Modifier Lists that are assigned to the specified Item Categories. 19 140 2=2 :p_effective_date between nvl(qmsv.start_date_active,:p_effective_date) and nvl(qmsv.end_date_active,:p_effective_date) Date sysdate US Effective Date 20 150 :p_show_modifier_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 Modifier Lines Download the Modifier Lines. 21 160 :p_show_header_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' Y US Download List Qualifiers Download the Modifier Lists assigned Qualifiers. 51815CAD31697176E0630100007FDEA5 Default ERIC.CLEGG 18 APPLICATION_METHOD 31 DELETE_QUALIFIER 6 GLOBAL_LIST 13 LINE_ALLOW_OVERRIDE 11 LINE_EFFECTIVE_FROM 12 LINE_EFFECTIVE_TO 10 LINE_NO 16 LINE_PRECEDENCE 15 LINE_PRODUCT_DESCRIPTION 17 LINE_PRODUCT_UOM 14 LINE_PRODUCT_VALUE 5 LIST_CURRENCY 4 LIST_DESCRIPTION 8 LIST_EFFECTIVE_FROM 9 LIST_EFFECTIVE_TO 3 LIST_NAME 1 LIST_NUMBER 2 LIST_VERSION 7 OPERATING_UNIT 23 QUALIFIER_APPLIES_PARTY_HIER 22 QUALIFIER_ATTRIBUTE 21 QUALIFIER_CONTEXT 30 QUALIFIER_END_DATE 20 QUALIFIER_GROUPING_NUMBER 25 QUALIFIER_OPERATOR 24 QUALIFIER_PRECEDENCE 29 QUALIFIER_START_DATE 26 QUALIFIER_VALUE_FROM 27 QUALIFIER_VALUE_FROM_DESC 28 QUALIFIER_VALUE_TO 19 VALUE S Site ERIC.CLEGG 51815CAD31697176E0630100007FDEA5 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 Y 7 OVERRIDE_LIST_LINE_ Char varchar2 2000 :$flex$.End_Date_Matching_Modifiers Y Y 8 UPLOAD_ROW Number number Y 9 MODIFIER_NUMBERING Char varchar2 2000 :$flex$.list_numbering Y Y 10 MOD_LIST_ROW_ID Number number Y 11 MOD_LINE_ROW_ID Number number Y 12 QUALIFIER_GROUP_ROW_ID Number number Y 13 QUALIFIER_ROW_ID Number number Y 14 PRICE_BREAK_LINE_ROW_ID Number number Y 15 PRICING_ATTRIBUTE_ROW_ID Number number Y 16 EXCLUDER_ROW_ID Number number Y 17 BUY_LINE_ROW_ID Number number Y 18 GET_LINE_ROW_ID Number number Y 19 LIMIT_ROW_ID Number number Y 20 LIMIT_ATT_ROW_ID Number number Y 21 PTE_CODE Char varchar2 30 :$flex$.Pricing_Transaction_Entity Y Y Y 22 SOURCE_SYSTEM_CODE Char varchar2 30 :$flex$.Source_System_Code Y Y Y 23 LIST_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 ((nvl(:$flex$.gsa_pricing,'N') = 'N' and qp_util.get_qp_status = 'I' and ql.lookup_code in ('DLT','SLT','PRO','CHARGES','DEL')) or (nvl(:$flex$.gsa_pricing,'N') = 'N' and qp_util.get_qp_status = 'S' and ql.lookup_code in ('DLT','SLT','CHARGES')) or (nvl(:$flex$.gsa_pricing,'N') = 'Y' and ql.lookup_code in ('DLT')) ) order by value xxen_util.meaning('DLT','LIST_TYPE_CODE',661) Y Y 24 LIST_ORIG_SYS_REF Char varchar2 50 Y Y 25 LIST_NUMBER LOV custom varchar2 240 select qslhv.name value, qslhv.description || ' (' || decode(qslhv.global_flag,'Y','Global',haouv.name) || ')' || nvl2(qslhv.version_no,' (Vn: ' || qslhv.version_no || ')',null) 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 = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') 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 nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') order by qslhv.name, qslhv.version_no Y 26 LIST_VERSION LOV custom varchar2 30 select qslhv.version_no value, null description from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') order by value select qslhv.version_no from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 27 LIST_NAME Char varchar2 2000 select qslhv.description from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.name = :$column$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') Y 28 LIST_DESCRIPTION Char varchar2 2000 select qslhv.comments from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.name = :$column$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 29 LIST_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') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.name = :$column$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 30 GLOBAL_LIST 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') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.name = :$column$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') ), xxen_util.meaning('Y','YES_NO',0) ) from dual Y 31 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_list,'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') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.name = :$column$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 32 LIST_EFFECTIVE_FROM Date date select qslhv.start_date_active from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.name = :$column$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 33 LIST_EFFECTIVE_TO Date date select qslhv.end_date_active from qp_secu_list_headers_vl qslhv where nvl(qslhv.pte_code,'ORDFUL') = :$column$.pte_code and nvl(qslhv.source_system_code,'QP') = :$column$.source_system_code and qslhv.name = :$column$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 34 LIST_IS_ACTIVE 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(:$flex$.gsa_pricing,'N') = 'N' ) order by value xxen_util.meaning('Y','YES_NO',0) Y Y 35 LIST_IS_AUTOMATIC 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' order by value xxen_util.meaning('Y','YES_NO',0) Y Y 36 LIST_GSA_INDICATOR LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual xxen_util.meaning(:$flex$.GSA_Pricing,'YES_NO',0) Y Y Y 37 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 38 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 39 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 40 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 41 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 42 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 43 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 44 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 45 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 46 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 47 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 48 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 49 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 50 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 51 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 52 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 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$.list_number and qslhv.list_type_code = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qslhv.version_no,'?') = nvl(:$column$.list_version,'?') and nvl(qslhv.gsa_indicator,'N') = nvl(:$flex$.gsa_pricing,'N') 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' 53 LINE_ORIG_SYS_REF Char varchar2 Y Y 54 LINE_NO Char varchar2 30 Modifier Line No is required when entering Modifier Lines detail. If Automatic Modifier Numbering is selected, the Line No will be replaced with a system generated line number on upload. The upload uses the List Number, List Version, and Modifier Line No to identify a Modifier Line. If the combination exists in Oracle already the upload will update the existing modifier line, otherwise it will create a new modifier line. Use the same Line No to identify a Modifier Line that is repeated in the upload with multiple associated child records (qualifiers, pricing attributes, price breaks, etc). Y 55 LINE_MODIFIER_LEVEL LOV custom varchar2 Y select ql.lookup_code id, ql.meaning value, null description from qp_lookups ql where ql.lookup_type = 'MODIFIER_LEVEL_CODE' and ( (nvl(:$flex$.gsa_pricing,'N') = 'N' and qp_util.get_qp_status = 'I' and (ql.lookup_code in ('LINE', 'ORDER') or (nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') != 'CHARGES' and ql.lookup_code = 'LINEGROUP') ) ) or (nvl(:$flex$.gsa_pricing,'N') = 'N' and qp_util.get_qp_status = 'S' and ql.lookup_code in ('LINE', 'ORDER') ) or (nvl(:$flex$.gsa_pricing,'N') = 'Y' and ql.lookup_code in ('LINE') ) ) order by value select xxen_util.meaning('LINE','MODIFIER_LEVEL_CODE',661) from dual where :$column$.line_no is not null Y Y 56 LINE_MODIFIER_TYPE LOV custom varchar2 Y select ql.lookup_code id, ql.meaning value, null description from qp_lookups ql where ql.lookup_type = 'LIST_LINE_TYPE_CODE' and ( (nvl(:$flex$.gsa_pricing,'N') = 'N' and nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') = 'DEL' and qp_util.get_qp_status = 'I' and (ql.lookup_code in ('DIS', 'CIE', 'TSN', 'SUR') or (nvl(xxen_util.lookup_code(:$column$.line_modifier_level,'MODIFIER_LEVEL_CODE',661), '*') in ('*', 'LINE', 'LINEGROUP') and ql.lookup_code in ('PBH', 'OID', 'PRG')) or (nvl(xxen_util.lookup_code(:$column$.line_modifier_level,'MODIFIER_LEVEL_CODE',661), '*') in ('*', 'LINE') and ql.lookup_code in ('IUE')) ) ) or (nvl(:$flex$.gsa_pricing,'N') = 'N' and nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') = 'PRO' and qp_util.get_qp_status = 'I' and nvl((select qslhv.limit_exists_flag from qp_secu_list_headers_vl qslhv where qslhv.name = :$column$.list_number and nvl(qslhv.version_no,'#null#') = nvl(:$column$.list_version,'#null#')),'N') = 'N' and (ql.lookup_code in ('DIS', 'CIE', 'TSN', 'SUR') or (nvl(xxen_util.lookup_code(:$column$.line_modifier_level,'MODIFIER_LEVEL_CODE',661), '*') in ('*', 'LINE', 'LINEGROUP') and ql.lookup_code in ('PBH', 'OID', 'PRG')) or (nvl(xxen_util.lookup_code(:$column$.line_modifier_level,'MODIFIER_LEVEL_CODE',661), '*') in ('*', 'LINE') and ql.lookup_code in ('IUE')) ) ) or (nvl(:$flex$.gsa_pricing,'N') = 'N' and nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') = 'PRO' and qp_util.get_qp_status = 'I' and nvl((select qslhv.limit_exists_flag from qp_secu_list_headers_vl qslhv where qslhv.name = :$column$.list_number and nvl(qslhv.version_no,'#null#') = nvl(:$column$.list_version,'#null#')),'N') = 'Y' and (ql.lookup_code in ('DIS', 'SUR') or (nvl(xxen_util.lookup_code(:$column$.line_modifier_level,'MODIFIER_LEVEL_CODE',661), '*') in ('*', 'LINE', 'LINEGROUP') and ql.lookup_code in ('PBH')) ) ) or (nvl(:$flex$.gsa_pricing,'N') = 'N' and nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') = 'DLT' and (ql.lookup_code in ('DIS', 'SUR') or (nvl(xxen_util.lookup_code(:$column$.line_modifier_level,'MODIFIER_LEVEL_CODE',661), '*') in ('*', 'LINE', 'LINEGROUP') and ql.lookup_code in ('PBH')) ) ) or (nvl(:$flex$.gsa_pricing,'N') = 'N' and nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') = 'SLT' and (ql.lookup_code in ('SUR') or (nvl(xxen_util.lookup_code(:$column$.line_modifier_level,'MODIFIER_LEVEL_CODE',661), '*') in ('*', 'LINE', 'LINEGROUP') and ql.lookup_code in ('PBH')) ) ) or (nvl(:$flex$.gsa_pricing,'N') = 'N' and nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') = 'CHARGES' and ql.lookup_code in ('FREIGHT_CHARGE') ) or (nvl(:$flex$.gsa_pricing,'N') = 'Y' and ql.lookup_code in ('DIS') ) ) order by value select xxen_util.meaning('DIS','LIST_LINE_TYPE_CODE',661) from dual where :$column$.line_no is not null Y Y 57 LINE_EFFECTIVE_FROM Date date 58 LINE_EFFECTIVE_TO Date date 59 LINE_AUTOMATIC 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' order by value select xxen_util.meaning('Y','YES_NO',0) from dual where :$column$.line_no is not null Y Y 60 LINE_ALLOW_OVERRIDE 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' order by value 61 LINE_PRORATION_TYPE LOV custom varchar2 Y select lookup_code id, meaning value, null description from qp_lookups where lookup_type = 'PRORATION_TYPE' and lookup_code like decode(nvl(:$flex$.gsa_pricing,'N'),'Y','N','N','%') order by value select meaning from qp_lookups where lookup_type = 'PRORATION_TYPE' and lookup_code = 'N' and :$column$.line_no is not null Y Y 62 LINE_PRICING_PHASE LOV custom varchar2 Y select qpp.pricing_phase_id id, qpp.name value, null description from qp_pricing_phases qpp where nvl(qpp.modifier_level_code,xxen_util.lookup_code(:$column$.line_modifier_level,'MODIFIER_LEVEL_CODE',661)) = xxen_util.lookup_code(:$column$.line_modifier_level,'MODIFIER_LEVEL_CODE',661) and nvl(qpp.list_type_code, nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT')) = nvl(xxen_util.lookup_code(:$column$.list_type,'LIST_TYPE_CODE',661),'DLT') and nvl(qpp.list_line_type_code,xxen_util.lookup_code(:$column$.line_modifier_type,'LIST_LINE_TYPE_CODE',661)) = xxen_util.lookup_code(:$column$.line_modifier_type,'LIST_LINE_TYPE_CODE',661) and qpp.phase_sequence in decode(nvl(:$flex$.gsa_pricing,'N'),'Y',10,'N',qpp.phase_sequence) and ((xxen_util.lookup_code(:$column$.line_modifier_type,'LIST_LINE_TYPE_CODE',661) = 'OID' and nvl(qpp.modifier_level_code, '*') <> 'LINE') or (xxen_util.lookup_code(:$column$.line_modifier_type,'LIST_LINE_TYPE_CODE',661) <> 'OID') ) and qpp.phase_sequence != 0 order by value select qpp.name from qp_pricing_phases qpp where qpp.pricing_phase_id = 2 and :$column$.line_no is not null Y Y 63 LINE_INCOMPATIBILITY_GROUP LOV custom varchar2 Y select lookup_code id, meaning value, null description from qp_lookups where lookup_type = 'INCOMPATIBILITY_GROUPS' and lookup_code like decode(nvl(:$flex$.gsa_pricing,'N'),'Y','LVL 1','N','%') and ((:$column$.line_pricing_phase = 'Across All Phases' and lookup_code = 'EXCL') or (:$column$.line_pricing_phase != 'Across All Phases') ) order by value select xxen_util.meaning('LVL 1','INCOMPATIBILITY_GROUPS',661) from dual where :$column$.line_no is not null Y Y 64 LINE_BUCKET LOV custom number Y select lookup_code id, lookup_code value, meaning description from qp_lookups where lookup_type = 'PRICING_GROUP_SEQUENCE' and lookup_code != 0 and lookup_code = decode(nvl(:$flex$.gsa_pricing,'N'),'Y',1,'N',lookup_code) and xxen_util.lookup_code(:$column$.line_modifier_level,'MODIFIER_LEVEL_CODE',661) != 'ORDER' order by value select 1 from dual where :$column$.line_no is not null Y Y 65 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_code = 'ITEM' and (nvl(:$flex$.gsa_pricing,'N') = 'N' or x.id = 'PRICING_ATTRIBUTE1') and x.enabled = 'Y' and nvl(x.segment_level,'LINE') = 'LINE' and :$column$.line_no is not null order by value 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(10) path 'SEGMENT_LEVEL' ) x where x.context_type = 'PRODUCT' and x.context_code = 'ITEM' and x.id = 'PRICING_ATTRIBUTE1' and x.enabled = 'Y' and nvl(x.segment_level,'LINE') = 'LINE' and :$column$.line_no is not null Y Y 66 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 => qp_util.get_context('QP_ATTR_DEFNS_PRICING','ITEM') , p_attribute_value => nvl(:$column$.line_product_attribute,qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING', 'ITEM','PRICING_ATTRIBUTE1')) , p_entered_value => :$column$.line_product_value , p_operator => '=' , p_delimiter => '^' ) ) lov where :$column$.line_no is not null order by value Y 67 LINE_PRODUCT_DESCRIPTION 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 => qp_util.get_context('QP_ATTR_DEFNS_PRICING','ITEM') , p_attribute_value => nvl(:$column$.line_product_attribute,qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING', 'ITEM','PRICING_ATTRIBUTE1')) , 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) from table( xxen_qp_upload.attribute_value_lov ( p_pte_code => :$column$.pte_code , p_context_type => 'PRODUCT' , p_context_value => qp_util.get_context('QP_ATTR_DEFNS_PRICING','ITEM') , p_attribute_value => nvl(:$column$.line_product_attribute,qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING', 'ITEM','PRICING_ATTRIBUTE1')) , 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 68 LINE_PRECEDENCE Number number xxen_qp_upload.get_attribute_info (:$column$.pte_code, 'PRODUCT', qp_util.get_context('QP_ATTR_DEFNS_PRICING','ITEM'), nvl(:$column$.line_product_attribute,qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING', 'ITEM','PRICING_ATTRIBUTE1')), 'PRECEDENCE') 69 LINE_PRODUCT_UOM LOV custom varchar2 3 Y select id, value, description from ( 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_attribute_code (:$column$.pte_code,'PRODUCT',qp_util.get_context('QP_ATTR_DEFNS_PRICING','ITEM'),nvl(:$column$.line_product_attribute,qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING', 'ITEM','PRICING_ATTRIBUTE1'))) = 'PRICING_ATTRIBUTE1' and msiv.organization_id = qp_util.get_item_validation_org and msiv.concatenated_segments = :$column$.line_product_value ) where :$column$.line_no is not null order by value select msiv.primary_uom_code from mtl_system_items_vl msiv where xxen_qp_upload.get_attribute_code(:$column$.pte_code,'PRODUCT',qp_util.get_context('QP_ATTR_DEFNS_PRICING','ITEM'),nvl(:$column$.line_product_attribute,qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING', 'ITEM','PRICING_ATTRIBUTE1'))) = 'PRICING_ATTRIBUTE1' and msiv.organization_id = qp_util.get_item_validation_org and msiv.concatenated_segments = :$column$.line_product_value 70 APPLICATION_METHOD LOV custom varchar2 Y select lookup_code id, meaning value, null description from qp_lookups where lookup_type = 'ARITHMETIC_OPERATOR' and lookup_code = 'NEWPRICE' and :$column$.line_no is not null order by value select xxen_util.meaning('NEWPRICE','ARITHMETIC_OPERATOR',661) from dual where :$column$.line_no is not null Y 71 VALUE Number number 72 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' and :$column$.line_no is not null order by fdfcv.descriptive_flex_context_name 73 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 where :$column$.line_no is not null 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' 74 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 where :$column$.line_no is not null 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' 75 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 where :$column$.line_no is not null 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' 76 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 where :$column$.line_no is not null 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' 77 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 where :$column$.line_no is not null 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' 78 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 where :$column$.line_no is not null 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' 79 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 where :$column$.line_no is not null 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' 80 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 where :$column$.line_no is not null 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' 81 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 where :$column$.line_no is not null 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' 82 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 where :$column$.line_no is not null 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' 83 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 where :$column$.line_no is not null 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' 84 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 where :$column$.line_no is not null 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' 85 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 where :$column$.line_no is not null 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' 86 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 where :$column$.line_no is not null 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' 87 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 where :$column$.line_no is not null 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' 88 QUALIFIER_ASSIGNMENT_LEVEL LOV custom varchar2 Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type = 'ZX_ROUNDING_LEVEL' and lookup_code in ('HEADER','LINE') and (lookup_code = 'HEADER' or (:$column$.line_modifier_type is not null and nvl(:$flex$.gsa_pricing,'N') != 'Y') ) order by value select xxen_util.meaning('HEADER','ZX_ROUNDING_LEVEL',0) from dual where :$column$.qualifier_context is not null Y Y 89 QUALIFIER_ORIG_SYS_REF Char varchar2 Y Y 90 QUALIFIER_GROUPING_NUMBER Number number 91 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' and (nvl(:$flex$.gsa_pricing,'N') = 'N' or x.id in ('MODLIST','CUSTOMER')) order by value 92 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 (nvl(:$flex$.gsa_pricing,'N') = 'N' or (xxen_qp_upload.get_context_code(:$column$.pte_code,'QUALIFIER',:$column$.qualifier_context) = 'CUSTOMER' and x.id in ('QUALIFIER_ATTRIBUTE2','QUALIFIER_ATTRIBUTE5')) or (xxen_qp_upload.get_context_code(:$column$.pte_code,'QUALIFIER',:$column$.qualifier_context) = 'MODLIST' and x.id in ('QUALIFIER_ATTRIBUTE4')) ) and x.enabled = 'Y' and nvl(x.segment_level,'LINE') in ('LINE','BOTH') order by value 93 QUALIFIER_APPLIES_PARTY_HIER LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 94 QUALIFIER_PRECEDENCE Number number xxen_qp_upload.get_attribute_info(:$column$.pte_code,'QUALIFIER',:$column$.qualifier_context,:$column$.qualifier_attribute,'PRECEDENCE') 95 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 96 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 where nvl(:$flex$.gsa_pricing,'N') = 'N' or (:$flex$.gsa_pricing = 'Y' and xxen_qp_upload.get_context_code(:$column$.pte_code,'QUALIFIER',:$column$.qualifier_context) = 'MODLIST' and xxen_qp_upload.get_attribute_code(:$column$.pte_code,'QUALIFIER',:$column$.qualifier_context,:$column$.qualifier_attribute) = 'QUALIFIER_ATTRIBUTE4' ) or (:$flex$.gsa_pricing = 'Y' and xxen_qp_upload.get_context_code(:$column$.pte_code,'QUALIFIER',:$column$.qualifier_context) = 'CUSTOMER' and ((xxen_qp_upload.get_attribute_code(:$column$.pte_code,'QUALIFIER',:$column$.qualifier_context,:$column$.qualifier_attribute) = 'QUALIFIER_ATTRIBUTE2' and exists (select null from hz_cust_accounts hca, hz_parties hp where hca.cust_account_id = to_number(regexp_substr(lov.column_value,'[^^]+',1,1)) and hca.party_id = hp.party_id and hca.status='A' and hp.gsa_indicator_flag = 'Y' ) ) or (xxen_qp_upload.get_attribute_code(:$column$.pte_code,'QUALIFIER',:$column$.qualifier_context,:$column$.qualifier_attribute) = 'QUALIFIER_ATTRIBUTE5' and exists (select null from hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_cust_accounts hca, hz_parties hp where hcsua.site_use_id = to_number(regexp_substr(lov.column_value,'[^^]+',1,1)) and hcsua.cust_acct_site_id = hcasa.cust_acct_site_id and hcasa.cust_account_id = hca.cust_account_id and hca.party_id = hp.party_id and hca.status='A' and hp.gsa_indicator_flag = 'Y' ) ) ) ) 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 97 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 98 QUALIFIER_VALUE_TO Char varchar2 99 QUALIFIER_START_DATE Date date 100 QUALIFIER_END_DATE Date date 101 DELETE_QUALIFIER LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 102 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 103 QUALIFIER_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 104 QUALIFIER_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 105 QUALIFIER_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 106 QUALIFIER_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 107 QUALIFIER_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 108 QUALIFIER_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 109 QUALIFIER_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 110 QUALIFIER_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 111 QUALIFIER_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 112 QUALIFIER_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 113 QUALIFIER_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 114 QUALIFIER_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 115 QUALIFIER_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 116 QUALIFIER_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 117 QUALIFIER_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 661, p_descriptive_flexfield_name => 'QP_QUALIFIERS', p_context_name => :$column$.qualifier_dff_context, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.qualifier_attribute1, p_attribute2 => :$column$.qualifier_attribute2, p_attribute3 => :$column$.qualifier_attribute3, p_attribute4 => :$column$.qualifier_attribute4, p_attribute5 => :$column$.qualifier_attribute5, p_attribute6 => :$column$.qualifier_attribute6, p_attribute7 => :$column$.qualifier_attribute7, p_attribute8 => :$column$.qualifier_attribute8, p_attribute9 => :$column$.qualifier_attribute9, p_attribute10 => :$column$.qualifier_attribute10, p_attribute11 => :$column$.qualifier_attribute11, p_attribute12 => :$column$.qualifier_attribute12, p_attribute13 => :$column$.qualifier_attribute13, p_attribute14 => :$column$.qualifier_attribute14, p_attribute15 => :$column$.qualifier_attribute15 ) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 661 and fdfv.descriptive_flexfield_name = 'QP_QUALIFIERS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 118 MODIFIER_LIST_ID Number number Y Y 119 MODIFIER_LINE_ID Number number Y Y 120 QUALIFIER_ID Number number Y Y 121 ROW_TYPE Char varchar2 Y 122 SEQ Number number Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 request_id_ out Char REQUEST_ID_ U 5 override_list_line_ in Char OVERRIDE_LIST_LINE_ U 6 p_modifier_numbering in Char MODIFIER_NUMBERING U 7 p_mod_list_row_id out Number MOD_LIST_ROW_ID U 8 p_mod_line_row_id out Number MOD_LINE_ROW_ID U 9 p_qualifier_group_row_id out Number QUALIFIER_GROUP_ROW_ID U 10 p_qualifier_row_id out Number QUALIFIER_ROW_ID U 11 p_price_break_line_row_id out Number PRICE_BREAK_LINE_ROW_ID U 12 p_buy_line_row_id out Number BUY_LINE_ROW_ID U 13 p_get_line_row_id out Number GET_LINE_ROW_ID U 14 p_pricing_attribute_row_id out Number PRICING_ATTRIBUTE_ROW_ID U 15 p_excluder_row_id out Number EXCLUDER_ROW_ID U 16 p_limit_row_id out Number LIMIT_ROW_ID U 17 p_limit_att_row_id out Number LIMIT_ATT_ROW_ID U 18 p_pte_code in Char PTE_CODE U 19 p_source_system_code in Char SOURCE_SYSTEM_CODE U 20 p_list_type in Char LIST_TYPE U 21 p_list_orig_sys_ref in Char LIST_ORIG_SYS_REF U 22 p_list_name in Char LIST_NUMBER U 23 p_list_description in Char LIST_NAME U 24 p_list_comments in Char LIST_DESCRIPTION U 25 p_list_version in Char LIST_VERSION U 26 p_list_currency in Char LIST_CURRENCY U 27 p_global_list in Char GLOBAL_LIST U 28 p_org_id in Number OPERATING_UNIT U 29 p_list_effective_from in Date LIST_EFFECTIVE_FROM U 30 p_list_effective_to in Date LIST_EFFECTIVE_TO U 31 p_list_is_active in Char LIST_IS_ACTIVE U 32 p_list_is_automatic in Char LIST_IS_AUTOMATIC U 33 p_list_parent_number in Char value U 34 p_list_parent_version in Char U 35 p_list_is_ask_for in Char U 36 p_list_date_type1 in Char U 37 p_list_date_type1_effective_fr in Date U 38 p_list_date_type1_effective_to in Date U 39 p_list_date_type2 in Char U 40 p_list_date_type2_effective_fr in Date U 41 p_list_date_type2_effective_to in Date U 42 p_list_gsa_indicator in Char LIST_GSA_INDICATOR U 43 p_list_dff_context in Char LIST_HEADER_DFF_CONTEXT U 44 p_list_attribute1 in Char LIST_HEADER_ATTRIBUTE1 U 45 p_list_attribute2 in Char LIST_HEADER_ATTRIBUTE2 U 46 p_list_attribute3 in Char LIST_HEADER_ATTRIBUTE3 U 47 p_list_attribute4 in Char LIST_HEADER_ATTRIBUTE4 U 48 p_list_attribute5 in Char LIST_HEADER_ATTRIBUTE5 U 49 p_list_attribute6 in Char LIST_HEADER_ATTRIBUTE6 U 50 p_list_attribute7 in Char LIST_HEADER_ATTRIBUTE7 U 51 p_list_attribute8 in Char LIST_HEADER_ATTRIBUTE8 U 52 p_list_attribute9 in Char LIST_HEADER_ATTRIBUTE9 U 53 p_list_attribute10 in Char LIST_HEADER_ATTRIBUTE10 U 54 p_list_attribute11 in Char LIST_HEADER_ATTRIBUTE11 U 55 p_list_attribute12 in Char LIST_HEADER_ATTRIBUTE12 U 56 p_list_attribute13 in Char LIST_HEADER_ATTRIBUTE13 U 57 p_list_attribute14 in Char LIST_HEADER_ATTRIBUTE14 U 58 p_list_attribute15 in Char LIST_HEADER_ATTRIBUTE15 U 59 p_line_orig_sys_ref in Char LINE_ORIG_SYS_REF U 60 p_line_no in Char LINE_NO U 61 p_line_modifier_level in Char LINE_MODIFIER_LEVEL U 62 p_line_modifier_type in Char LINE_MODIFIER_TYPE U 63 p_line_effective_from in Date LINE_EFFECTIVE_FROM U 64 p_line_effective_to in Date LINE_EFFECTIVE_TO U 65 p_delete_modifier_line in Char U 66 p_line_automatic in Char LINE_AUTOMATIC U 67 p_line_allow_override in Char LINE_ALLOW_OVERRIDE U 68 p_line_pricing_phase in Char LINE_PRICING_PHASE U 69 p_line_incompatibility_group in Char LINE_INCOMPATIBILITY_GROUP U 70 p_line_bucket in Number LINE_BUCKET U 71 p_line_proration_type in Char LINE_PRORATION_TYPE U 72 p_line_comparison_value in Number U 73 p_line_product_context in Char U 74 p_line_product_attribute in Char LINE_PRODUCT_ATTRIBUTE U 75 p_line_product_value in Char LINE_PRODUCT_VALUE value U 76 p_line_product_description in Char LINE_PRODUCT_DESCRIPTION value U 77 p_line_product_uom in Char LINE_PRODUCT_UOM U 78 p_line_precedence in Number LINE_PRECEDENCE U 79 p_line_volume_type in Char U 80 p_line_price_break_type in Char U 81 p_line_operator in Char U 82 p_line_value_from in Char U 83 p_line_value_to in Char U 84 p_charge_name in Char U 85 p_include_on_returns in Char U 86 p_formula_id in Number U 87 p_application_method in Char APPLICATION_METHOD U 88 p_value in Number VALUE U 89 p_upgrade_item in Char U 90 p_terms_attribute in Char U 91 p_terms_value in Char U 92 p_coupon_modifier_no in Char U 93 p_pbh_adjustment_type in Char U 94 p_pbh_accumulation_attribute in Char U 95 p_pbh_net_amount_calculation in Char U 96 p_accrue in Char U 97 p_benefit_qty in Number U 98 p_benefit_uom in Char U 99 p_expiration_date in Date U 100 p_expiration_period_start_date in Date U 101 p_expiration_periods in Number U 102 p_expiration_period_type in Char U 103 p_accrual_redemption_rate in Number U 104 p_accrual_conversion_rate in Number U 105 p_rebate_transaction_type in Char U 106 p_line_dff_context in Char LIST_LINE_DFF_CONTEXT U 107 p_line_attribute1 in Char LIST_LINE_ATTRIBUTE1 U 108 p_line_attribute2 in Char LIST_LINE_ATTRIBUTE2 U 109 p_line_attribute3 in Char LIST_LINE_ATTRIBUTE3 U 110 p_line_attribute4 in Char LIST_LINE_ATTRIBUTE4 U 111 p_line_attribute5 in Char LIST_LINE_ATTRIBUTE5 U 112 p_line_attribute6 in Char LIST_LINE_ATTRIBUTE6 U 113 p_line_attribute7 in Char LIST_LINE_ATTRIBUTE7 U 114 p_line_attribute8 in Char LIST_LINE_ATTRIBUTE8 U 115 p_line_attribute9 in Char LIST_LINE_ATTRIBUTE9 U 116 p_line_attribute10 in Char LIST_LINE_ATTRIBUTE10 U 117 p_line_attribute11 in Char LIST_LINE_ATTRIBUTE11 U 118 p_line_attribute12 in Char LIST_LINE_ATTRIBUTE12 U 119 p_line_attribute13 in Char LIST_LINE_ATTRIBUTE13 U 120 p_line_attribute14 in Char LIST_LINE_ATTRIBUTE14 U 121 p_line_attribute15 in Char LIST_LINE_ATTRIBUTE15 U 122 p_price_break_orig_sys_ref in Char U 123 p_price_break_value_from in Char U 124 p_price_break_value_to in Char U 125 p_price_break_application_meth in Char U 126 p_price_break_value in Number U 127 p_price_break_formula_id in Number U 128 p_price_break_benefit_quantity in Number U 129 p_price_break_benefit_uom in Char U 130 p_price_break_accrual_conv_rat in Number U 131 p_delete_price_break in Char U 132 p_buy_orig_sys_ref in Char U 133 p_buy_group_no in Number U 134 p_buy_product_attribute in Char U 135 p_buy_product_attribute_value in Char U 136 p_buy_pricing_attribute in Char U 137 p_buy_operator in Char U 138 p_buy_value_from in Char U 139 p_buy_value_to in Char U 140 p_buy_uom in Char U 141 p_delete_buy_item in Char U 142 p_get_orig_sys_ref in Char U 143 p_get_product_attribute in Char U 144 p_get_product_attribute_value in Char U 145 p_get_product_attribute_uom in Char U 146 p_get_quantity in Number U 147 p_get_uom in Char U 148 p_get_price_list in Char U 149 p_get_price in Number U 150 p_get_formula_id in Number U 151 p_get_application_method in Char U 152 p_get_value in Number U 153 p_pricing_attrib_orig_sys_ref in Char U 154 p_pricing_attribute_context in Char U 155 p_pricing_attribute in Char U 156 p_pricing_attribute_operator in Char U 157 p_pricing_attribute_value_from in Char U 158 p_pricing_attribute_val_fr_mng in Char U 159 p_pricing_attribute_value_to in Char U 160 p_delete_pricing_attribute in Char U 161 p_excluder_orig_sys_ref in Char U 162 p_excluder_flag in Char U 163 p_excluder_product_attribute in Char U 164 p_excluder_product_value in Char value U 165 p_excluder_product_description in Char value U 166 p_delete_excluder in Char U 167 p_qualifier_assignment_level in Char QUALIFIER_ASSIGNMENT_LEVEL U 168 p_qualifier_orig_sys_ref in Char QUALIFIER_ORIG_SYS_REF U 169 p_qualifier_rule_id in Number U 170 p_qualifier_grouping_number in Number QUALIFIER_GROUPING_NUMBER U 171 p_qualifier_context in Char QUALIFIER_CONTEXT U 172 p_qualifier_attribute in Char QUALIFIER_ATTRIBUTE U 173 p_qualifier_applies_party_hier in Char QUALIFIER_APPLIES_PARTY_HIER U 174 p_qualifier_precedence in Number QUALIFIER_PRECEDENCE U 175 p_qualifier_operator in Char QUALIFIER_OPERATOR U 176 p_qualifier_value_from in Char QUALIFIER_VALUE_FROM U 177 p_qualifier_value_from_mng in Char QUALIFIER_VALUE_FROM_DESC U 178 p_qualifier_value_to in Char QUALIFIER_VALUE_TO U 179 p_qualifier_start_date in Date QUALIFIER_START_DATE U 180 p_qualifier_end_date in Date QUALIFIER_END_DATE U 181 p_delete_qualifier in Char DELETE_QUALIFIER U 182 p_qualifier_dff_context in Char QUALIFIER_DFF_CONTEXT U 183 p_qualifier_attribute1 in Char QUALIFIER_ATTRIBUTE1 U 184 p_qualifier_attribute2 in Char QUALIFIER_ATTRIBUTE2 U 185 p_qualifier_attribute3 in Char QUALIFIER_ATTRIBUTE3 U 186 p_qualifier_attribute4 in Char QUALIFIER_ATTRIBUTE4 U 187 p_qualifier_attribute5 in Char QUALIFIER_ATTRIBUTE5 U 188 p_qualifier_attribute6 in Char QUALIFIER_ATTRIBUTE6 U 189 p_qualifier_attribute7 in Char QUALIFIER_ATTRIBUTE7 U 190 p_qualifier_attribute8 in Char QUALIFIER_ATTRIBUTE8 U 191 p_qualifier_attribute9 in Char QUALIFIER_ATTRIBUTE9 U 192 p_qualifier_attribute10 in Char QUALIFIER_ATTRIBUTE10 U 193 p_qualifier_attribute11 in Char QUALIFIER_ATTRIBUTE11 U 194 p_qualifier_attribute12 in Char QUALIFIER_ATTRIBUTE12 U 195 p_qualifier_attribute13 in Char QUALIFIER_ATTRIBUTE13 U 196 p_qualifier_attribute14 in Char QUALIFIER_ATTRIBUTE14 U 197 p_qualifier_attribute15 in Char QUALIFIER_ATTRIBUTE15 U 198 p_limit_assignment_level in Char U 199 p_limit_no in Number U 200 p_limit_basis in Char U 201 p_limit_enforced in Char U 202 p_limit_amount in Number U 203 p_limit_by_organization in Char U 204 p_limit_constraint_1 in Char U 205 p_limit_context_1 in Char U 206 p_limit_attribute_1 in Char U 207 p_limit_constraint_2 in Char U 208 p_limit_context_2 in Char U 209 p_limit_attribute_2 in Char U 210 p_limit_when_exceeded in Char U 211 p_limit_hold in Char U 212 p_delete_limit in Char U 213 p_limit_oth_att_constraint in Char U 214 p_limit_oth_att_context in Char U 215 p_limit_oth_att_attribute in Char U 216 p_limit_oth_att_value in Char U 217 p_limit_other_att_meaning in Char U 218 p_delete_limit_oth_att in Char U 219 p_modifier_list_id in Number MODIFIER_LIST_ID U 220 p_modifier_line_id in Number MODIFIER_LINE_ID U 221 p_price_break_line_id in Number U 222 p_buy_line_id in Number U 223 p_get_line_id in Number U 224 p_pricing_attribute_id in Number U 225 p_excluder_id in Number U 226 p_qualifier_id in Number QUALIFIER_ID U 227 p_limit_id in Number U 228 p_limit_attribute_id in Number Error SQL Order By x.upload_row, x.list_number, x.list_version, nvl(x.line_no,-1), nvl(x.modifier_line_id,-1), x.seq, x.qualifier_grouping_number, x.qualifier_precedence, x.qualifier_context, x.qualifier_attribute Success SQL select xu.action_, xu.status_, xu.message_, xu.request_id_, xu.modified_columns_, xu.upload_mode_, xu.override_list_line_, xu.upload_row, xu.modifier_numbering, xu.mod_list_row_id, xu.mod_line_row_id, xu.qualifier_group_row_id, xu.qualifier_row_id, xu.price_break_line_row_id, xu.pricing_attribute_row_id, xu.excluder_row_id, xu.buy_line_row_id, xu.get_line_row_id, xu.limit_row_id, xu.limit_att_row_id, -- -- Modifier 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) list_type, qslhv.orig_system_header_ref list_orig_sys_ref, qslhv.name list_number, qslhv.version_no list_version, qslhv.description list_name, qslhv.comments list_description, qslhv.currency_code list_currency, xxen_util.meaning(nvl(qslhv.global_flag,'Y'),'YES_NO',0) global_list, qp_util.get_ou_name(qslhv.orig_org_id) operating_unit, qslhv.start_date_active list_effective_from, qslhv.end_date_active list_effective_to, xxen_util.meaning(nvl(qslhv.active_flag,'N'),'YES_NO',0) list_is_active, xxen_util.meaning(decode(qslhv.automatic_flag,'Y','Y',null),'YES_NO',0) list_is_automatic, xxen_util.meaning(decode(qslhv.gsa_indicator,'Y','Y',null),'YES_NO',0) list_gsa_indicator, -- 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, -- -- Modifier Line -- summary xxen_qp_upload.get_orig_sys_ref('LINE',qmsv.list_line_id) line_orig_sys_ref, qmsv.list_line_no line_no, qmsv.modifier_level line_modifier_level, qmsv.list_line_type line_modifier_type, qmsv.start_date_active line_effective_from, qmsv.end_date_active line_effective_to, xxen_util.meaning(decode(qmsv.automatic_flag,'Y','Y',null),'YES_NO',0) line_automatic, xxen_util.meaning(decode(qmsv.override_flag,'Y','Y',null),'YES_NO',0) line_allow_override, qmsv.proration_type line_proration_type, qmsv.pricing_phase line_pricing_phase, qmsv.incompatibility_grp line_incompatibility_group, qmsv.pricing_group_sequence line_bucket, qmsv.product_attribute_type line_product_attribute, qmsv.product_attr_value line_product_value, xxen_qp_upload.get_product_description(qslhv.pte_code,qp_util.get_context('QP_ATTR_DEFNS_PRICING',qmsv.product_attribute_context),qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING',qmsv.product_attribute_context,qmsv.product_attr),qmsv.product_attr_val,qmsv.product_attr_value) line_product_description, qmsv.product_precedence line_precedence, qmsv.product_uom_code line_product_uom, -- Discounts/Charges qmsv.arithmetic_operator_type application_method, qmsv.operand value, -- Line DFF Attributes xxen_util.display_flexfield_context(661,'QP_LIST_LINES',qmsv.context) list_line_dff_context, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE1',qmsv.row_id,qmsv.attribute1) list_line_attribute1, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE2',qmsv.row_id,qmsv.attribute2) list_line_attribute2, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE3',qmsv.row_id,qmsv.attribute3) list_line_attribute3, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE4',qmsv.row_id,qmsv.attribute4) list_line_attribute4, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE5',qmsv.row_id,qmsv.attribute5) list_line_attribute5, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE6',qmsv.row_id,qmsv.attribute6) list_line_attribute6, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE7',qmsv.row_id,qmsv.attribute7) list_line_attribute7, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE8',qmsv.row_id,qmsv.attribute8) list_line_attribute8, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE9',qmsv.row_id,qmsv.attribute9) list_line_attribute9, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE10',qmsv.row_id,qmsv.attribute10) list_line_attribute10, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE11',qmsv.row_id,qmsv.attribute11) list_line_attribute11, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE12',qmsv.row_id,qmsv.attribute12) list_line_attribute12, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE13',qmsv.row_id,qmsv.attribute13) list_line_attribute13, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE14',qmsv.row_id,qmsv.attribute14) list_line_attribute14, xxen_util.display_flexfield_value(661,'QP_LIST_LINES',qmsv.context,'ATTRIBUTE15',qmsv.row_id,qmsv.attribute15) list_line_attribute15, -- -- Qualifiers nvl(nvl2(qqv.qualifier_id,xxen_util.meaning(decode(nvl(qqv.list_line_id,-1),-1,'HEADER','LINE'),'ZX_ROUNDING_LEVEL',0),null), case when xu.delete_qualifier is not null then xu.qualifier_assignment_level end) qualifier_assignment_level, nvl(xxen_qp_upload.get_orig_sys_ref('QUALIFIER',qqv.qualifier_id), case when xu.delete_qualifier is not null then xu.qualifier_orig_sys_ref end) qualifier_orig_sys_ref, nvl(qqv.qualifier_grouping_no, case when xu.delete_qualifier is not null then xu.qualifier_grouping_number end) qualifier_grouping_number, nvl(qp_util.get_context('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context), case when xu.delete_qualifier is not null then xu.qualifier_context end) qualifier_context, nvl(qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context,qqv.qualifier_attribute), case when xu.delete_qualifier is not null then xu.qualifier_attribute end) qualifier_attribute, nvl(xxen_util.meaning(decode(qqv.qualify_hier_descendents_flag,'Y','Y',null),'YES_NO',0), case when xu.delete_qualifier is not null then xu.qualifier_applies_party_hier end) qualifier_applies_party_hier, nvl(qqv.qualifier_precedence, case when xu.delete_qualifier is not null then xu.qualifier_precedence end) qualifier_precedence, nvl(qqv.comparision_operator_code, case when xu.delete_qualifier is not null then xu.qualifier_operator end) qualifier_operator, nvl(rtrim(replace(qp_util.get_attribute_value('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context,qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context, qqv.qualifier_attribute),qqv.qualifier_attr_value,qqv.comparision_operator_code),chr(0),null)), case when xu.delete_qualifier is not null then xu.qualifier_value_from end ) qualifier_value_from, nvl(rtrim(replace(qp_util.get_attribute_value_meaning('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context,qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context, qqv.qualifier_attribute),qqv.qualifier_attr_value,qqv.comparision_operator_code),chr(0),null)), case when xu.delete_qualifier is not null then xu.qualifier_value_from_desc end ) qualifier_value_from_desc, nvl(qp_util.get_attribute_value('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context,qp_qp_form_pricing_attr.get_segment_name('QP_ATTR_DEFNS_QUALIFIER',qqv.qualifier_context, qqv.qualifier_attribute),qqv.qualifier_attr_value_to,qqv.comparision_operator_code), case when xu.delete_qualifier is not null then xu.qualifier_value_to end ) qualifier_value_to, nvl(qqv.start_date_active,case when xu.delete_qualifier is not null then xu.qualifier_start_date end) qualifier_start_date, nvl(qqv.end_date_active,case when xu.delete_qualifier is not null then xu.qualifier_end_date end) qualifier_end_date, xu.delete_qualifier, -- xxen_util.display_flexfield_context(661,'QP_QUALIFIERS',qqv.context) qualifier_dff_context, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE1',qqv.row_id,qqv.attribute1) qualifier_attribute1, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE2',qqv.row_id,qqv.attribute2) qualifier_attribute2, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE3',qqv.row_id,qqv.attribute3) qualifier_attribute3, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE4',qqv.row_id,qqv.attribute4) qualifier_attribute4, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE5',qqv.row_id,qqv.attribute5) qualifier_attribute5, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE6',qqv.row_id,qqv.attribute6) qualifier_attribute6, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE7',qqv.row_id,qqv.attribute7) qualifier_attribute7, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE8',qqv.row_id,qqv.attribute8) qualifier_attribute8, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE9',qqv.row_id,qqv.attribute9) qualifier_attribute9, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE10',qqv.row_id,qqv.attribute10) qualifier_attribute10, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE11',qqv.row_id,qqv.attribute11) qualifier_attribute11, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE12',qqv.row_id,qqv.attribute12) qualifier_attribute12, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE13',qqv.row_id,qqv.attribute13) qualifier_attribute13, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE14',qqv.row_id,qqv.attribute14) qualifier_attribute14, xxen_util.display_flexfield_value(661,'QP_QUALIFIERS',qqv.context,'ATTRIBUTE15',qqv.row_id,qqv.attribute15) qualifier_attribute15, -- -- IDs qslhv.list_header_id modifier_list_id, qmsv.list_line_id modifier_line_id, qqv.qualifier_id, 'Result' row_type, xu.seq from xxen_qp_gsa_pricing_upl_1991_u xu, qp_secu_list_headers_vl qslhv, qp_modifier_summary_v qmsv, qp_qualifiers_v qqv where nvl(xu.status_code_,xxen_upload.status_error) = xxen_upload.status_success and xu.mod_list_row_id = qslhv.list_header_id and xu.mod_list_row_id = qmsv.list_header_id(+) and xu.mod_line_row_id = qmsv.list_line_id(+) and nvl(qmsv.excluder_flag(+),'N')='N' and xu.mod_list_row_id = qqv.list_header_id(+) and xu.qualifier_row_id = qqv.qualifier_id(+)