ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4720F51A9E05362FB09050512 with q1 as ( select a.name modifier_number, a.description modifier_name, a.version_no version, a.comments description, a.currency_code currency, a.start_date_active modifier_effective_from, a.end_date_active modifier_effective_to, QP_QPXPRMLS_XMLP_PKG.cf_line_type_codeformula(a.list_type_code) type, a.automatic_flag modifier_automatc_flag, a.active_flag modifier_active_flag, a.ask_for_flag ask_for, a.global_flag, QP_QPXPRMLS_XMLP_PKG.cf_parent_numberformula(a.parent_list_header_id) parent_number, QP_QPXPRMLS_XMLP_PKG.cf_parent_versionformula(a.parent_list_header_id) parent_version, a.active_date_first_type data_type_1, a.start_date_active_first data_type_1_effective_from, a.end_date_active_first data_type_1_effective_to, a.active_date_second_type data_type_2, a.start_date_active_second data_type_2_effective_from, a.end_date_active_second data_type_2_effective_to, -- --a.list_type_code, --a.gsa_indicator, a.parent_list_header_id parent_list_header_id1, a.list_header_id list_header_id1, xxen_util.client_time(a.creation_date) creation_date, xxen_util.user_name(a.created_by,'N') created_by, xxen_util.client_time(a.last_update_date) last_update_date, xxen_util.user_name(a.last_updated_by,'N') last_updated_by, xxen_util.meaning(a.pte_code,'QP_PTE_TYPE',661) pricing_transaction_entity, (select fav.application_name from fnd_application_vl fav where fav.application_short_name = a.source_system_code) source_application from qp_secu_list_headers_vl a where 1=1 and a.list_type_code not in ('PRL','AGR') and nvl(a.pte_code, 'ORDFUL') = nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'),'ORDFUL') ), -- -- q2 as ( select a.rule_name qualifier_group, a.qualifier_grouping_no qualifier_grouping_number, a.start_date_active qualifier_start_date, a.end_date_active qualifier_end_date, a.qualifier_context, QP_QPXPRMLS_XMLP_PKG.cf_qualifier_attributeformula(a.qualifier_context, a.qualifier_attribute) qualifier_attribute, qualify_hier_descendents_flag applies_to_party_hierarchy, a.qualifier_precedence, a.comparision_operator_code qualifier_operator_code, qp_util.Get_Attribute_Value ('QP_ATTR_DEFNS_QUALIFIER', a.qualifier_context, (select qsb.segment_code from qp_segments_b qsb,qp_prc_contexts_b qpcb where qsb.prc_context_id = qpcb.prc_context_id and qpcb.prc_context_type = 'QUALIFIER' and qpcb.prc_context_code = a.qualifier_context and qsb.segment_mapping_column = a.qualifier_attribute), a.qualifier_attr_value, a.comparision_operator_code ) qualifier_value_from, qp_util.Get_Attribute_Value_Meaning ('QP_ATTR_DEFNS_QUALIFIER', a.qualifier_context, (select qsb.segment_code from qp_segments_b qsb,qp_prc_contexts_b qpcb where qsb.prc_context_id = qpcb.prc_context_id and qpcb.prc_context_type = 'QUALIFIER' and qpcb.prc_context_code = a.qualifier_context and qsb.segment_mapping_column = a.qualifier_attribute), a.qualifier_attr_value, a.comparision_operator_code ) qualifier_value_from_meaning, QP_QPXPRMLS_XMLP_PKG.cf_attr_value_toformula(a.qualifier_context, a.qualifier_attribute, a.qualifier_attr_value_to, a.comparision_operator_code,qualifier_datatype,a.comparision_operator_code,a.qualifier_attr_value) qualifier_value_to, -- --a.qualifier_attribute, --a.qualifier_attr_value, --a.qualifier_attr_value_to, --a.qualifier_datatype, a.list_header_id list_header_id2, a.list_line_id list_line_id2, xxen_util.client_time(a.creation_date) creation_date, xxen_util.user_name(a.created_by,'N') created_by, xxen_util.client_time(a.last_update_date) last_update_date, xxen_util.user_name(a.last_updated_by,'N') last_updated_by from qp_qualifiers_v a order by a.qualifier_grouping_no ), -- -- q3 as ( select a.list_line_no list_line_no, a.modifier_level, a.start_date_active line_effective_from, a.end_date_active line_effective_to, a.list_line_type, a.print_on_invoice_flag, a.automatic_flag line_automatic_flag, a.override_flag line_override_flag, a.pricing_phase line_phase, a.pricing_group_sequence line_bucket, a.proration_type line_proration_type, a.estim_gl_value comparison_value, (select ql.meaning from qp_lookups ql where ql.lookup_type = 'QP_NET_AMOUNT_CALCULATION' and ql.lookup_code = a.net_amount_flag) net_amount_calculation, a.incompatibility_grp line_incompatibility_group, a.product_attribute_type line_product_attribute_type, a.comparison_operator_code line_comparison_operator_code, a.product_attr_value line_product_value, a.product_precedence line_precedence, a.product_uom_code line_uom, a.pricing_attribute line_volume_type, a.pricing_attr_value_from line_value_from, a.pricing_attr_value_to line_value_to, a.price_break_type line_price_break_type, a.accum_attribute accumulation_attribute, a.charge_name, a.formula line_formula, a.arithmetic_operator_type line_appl_method, a.operand line_value, a.include_on_returns_flag, a.accrual_flag, -- a.related_item upgrade_item, -- a.substitution_attribute terms_attribute, a.substitution_value terms_value, -- decode(a.list_line_type_code,'CIE',a.expiration_date,null) coupon_expire_date, decode(a.list_line_type_code,'CIE',a.expiration_period_start_date,null) coupon_expire_prd_start_date, decode(a.list_line_type_code,'CIE',a.number_expiration_periods,null) coupon_expire_periods, decode(a.list_line_type_code,'CIE',a.expiration_period_uom,null) expire_period_type, decode(a.list_line_type_code,'CIE',a.benefit_qty,null) coupon_benefit_qty, decode(a.list_line_type_code,'CIE',a.benefit_uom_code,null) coupon_benefit_uom, decode(a.list_line_type_code,'CIE',a.estim_accrual_rate,null) estimated_benefit_rate, decode(a.list_line_type_code,'CIE',a.accrual_conversion_rate,null) coupon_conversion_rate, case when a.list_line_type_code = 'CIE' then (select qll.list_line_no from qp_list_lines qll where qll.list_line_id = (select qr.to_rltd_modifier_id from qp_rltd_modifiers qr, qp_list_lines ql where qr.from_rltd_modifier_id = ql.list_line_id and qr.from_rltd_modifier_id = a.list_line_id and qr.rltd_modifier_grp_type = 'COUPON' ) ) else null end coupon_modifier_number, -- -- a.list_line_type_code, -- a.charge_subtype_code, -- a.net_amount_flag, a.list_line_id list_line_id3, a.list_header_id list_header_id3, xxen_util.client_time(a.creation_date) creation_date, xxen_util.user_name(a.created_by,'N') created_by, xxen_util.client_time(a.last_update_date) last_update_date, xxen_util.user_name(a.last_updated_by,'N') last_updated_by from qp_modifier_summary_v a where 2=2 and a.list_line_type_code IN ('DIS', 'OID', 'TSN', 'CIE', 'PBH', 'IUE', 'SUR', 'FREIGHT_CHARGE', 'PRG') and not exists (select null from qp_rltd_modifiers q where a.list_line_id = q.to_rltd_modifier_id ) ), -- -- q4 as ( select b.pricing_attr_value_from price_break_attr_value_from, b.pricing_attr_value_to price_break_attr_value_to, QP_QP_Form_Pricing_Attr.Get_Formula(b.price_by_formula_id) formula, QP_QP_Form_Pricing_Attr.Get_Meaning (b.arithmetic_operator, 'ARITHMETIC_OPERATOR') application_method, b.operand value, b.benefit_qty, b.benefit_uom_code benefit_uom, b.accrual_conversion_rate, -- -- b.price_by_formula_id, -- b.arithmetic_operator, -- b.pricing_attribute_datatype, -- b.accrual_flag, -- b.pricing_attribute_context, -- b.pricing_attribute, -- b.pricing_attribute_id, b.list_line_id list_line_id4, b.list_header_id list_header_id4, b.parent_list_line_id parent_list_line_id4, xxen_util.client_time(b.creation_date) creation_date, xxen_util.user_name(b.created_by,'N') created_by, xxen_util.client_time(b.last_update_date) last_update_date, xxen_util.user_name(b.last_updated_by,'N') last_updated_by from qp_price_breaks_v b ), -- -- q5 as ( select a.rltd_modifier_grp_no related_modifier_group_number, QP_QP_Form_Pricing_Attr.Get_Attribute ('QP_ATTR_DEFNS_PRICING', a.product_attribute_context, a.product_attribute) product_attribute, QP_Price_List_Line_Util.Get_Product_Value ('QP_ATTR_DEFNS_PRICING', a.product_attribute_context, a.product_attribute, a.product_attr_value) product_attribute_value, QP_QP_Form_Pricing_Attr.Get_Attribute ('QP_ATTR_DEFNS_PRICING',a.pricing_attribute_context,a.pricing_attribute) pricing_attribute, a.comparison_operator_code operator, a.pricing_attr_value_from value_from, a.pricing_attr_value_to value_to, a.product_uom_code buy_uom, -- -- a.product_attribute, -- a.product_attr_value, -- a.pricing_attribute, -- a.product_attribute_context, -- a.pricing_attribute_context, -- a.product_attribute_datatype, -- a.pricing_attribute_datatype, -- a.pricing_attribute_id, a.list_line_id list_line_id5, a.list_header_id list_header_id5, a.parent_list_line_id parent_list_line_id5, xxen_util.client_time(a.creation_date) creation_date, xxen_util.user_name(a.created_by,'N') created_by, xxen_util.client_time(a.last_update_date) last_update_date, xxen_util.user_name(a.last_updated_by,'N') last_updated_by from qp_pricing_attr_v a ), -- -- q6 as ( select QP_QP_Form_Pricing_Attr.Get_Attribute ('QP_ATTR_DEFNS_PRICING', g.product_attribute_context, g.product_attribute) product_attribute, QP_Price_List_Line_Util.Get_Product_Value ('QP_ATTR_DEFNS_PRICING', g.product_attribute_context, g.product_attribute, g.product_attr_value) product_attribute_value, g.product_uom_code product_attribute_uom, g.benefit_qty get_quantity, g.benefit_uom_code get_uom, (select qll.operand from qp_list_lines qll where qll.list_line_id = g.benefit_price_list_line_id) get_price, QP_QP_Form_Pricing_Attr.Get_Formula(g.price_by_formula_id) formula, QP_QP_Form_Pricing_Attr.Get_Meaning(g.arithmetic_operator, 'ARITHMETIC_OPERATOR') application_method, g.operand value, -- -- g.product_attribute, -- g.product_attr_value, -- g.benefit_price_list_line_id, -- g.price_by_formula_id, -- g.arithmetic_operator, -- g.product_attribute_context, -- g.pricing_attribute_context, -- g.product_attribute_datatype, -- g.pricing_attribute_datatype, -- g.pricing_attribute_id, g.list_line_id list_line_id6, g.list_header_id list_header_id6, g.parent_list_line_id parent_list_line_id6, xxen_util.client_time(g.creation_date) creation_date, xxen_util.user_name(g.created_by,'N') created_by, xxen_util.client_time(g.last_update_date) last_update_date, xxen_util.user_name(g.last_updated_by,'N') last_updated_by from qp_pricing_attr_get_v g ) ------------------------------------ -- Main Query starts here ------------------------------------ select x.* from ( -- List Header Qualifiers -- Q1, Q2 select /*+ push_pred(q2) push_pred(q3) push_pred(q4) push_pred(q5) push_pred(q6) */ q1.modifier_number, q1.modifier_name, q1.version, q1.description, q1.currency, q1.modifier_effective_from, q1.modifier_effective_to, q1.type, q1.modifier_automatc_flag, q1.modifier_active_flag, q1.ask_for, q1.global_flag, q1.parent_number, q1.parent_version, q1.data_type_1, q1.data_type_1_effective_from, q1.data_type_1_effective_to, q1.data_type_2, q1.data_type_2_effective_from, q1.data_type_2_effective_to, -- 'Qualifier' record_type, -- q2.qualifier_group, q2.qualifier_grouping_number, q2.qualifier_start_date, q2.qualifier_end_date, q2.qualifier_context, q2.qualifier_attribute, q2.applies_to_party_hierarchy, q2.qualifier_precedence, q2.qualifier_operator_code, q2.qualifier_value_from, q2.qualifier_value_from_meaning, q2.qualifier_value_to, -- q3.list_line_no, q3.modifier_level, q3.line_effective_from, q3.line_effective_to, q3.list_line_type, q3.print_on_invoice_flag, q3.line_automatic_flag, q3.line_override_flag, q3.line_phase, q3.line_bucket, q3.line_proration_type, q3.comparison_value, q3.net_amount_calculation, q3.line_incompatibility_group, q3.line_product_attribute_type, q3.line_comparison_operator_code, q3.line_product_value, q3.line_precedence, q3.line_uom, q3.line_volume_type, q3.line_value_from, q3.line_value_to, q3.line_price_break_type, q3.accumulation_attribute, q3.charge_name, q3.line_formula, q3.line_appl_method, q3.line_value, q3.include_on_returns_flag, q3.accrual_flag, q3.upgrade_item, q3.terms_attribute, q3.terms_value, q3.coupon_expire_date, q3.coupon_expire_prd_start_date, q3.coupon_expire_periods, q3.expire_period_type, q3.coupon_benefit_qty, q3.coupon_benefit_uom, q3.estimated_benefit_rate, q3.coupon_conversion_rate, q3.coupon_modifier_number, -- q5.related_modifier_group_number, q4.price_break_attr_value_from, q4.price_break_attr_value_to, q5.product_attribute, q5.product_attribute_value, q6.product_attribute_uom, q5.pricing_attribute, q5.operator, q4.formula, q4.application_method, q4.value, q5.value_from, q5.value_to, q4.benefit_qty, q4.benefit_uom, q4.accrual_conversion_rate, q5.buy_uom, q6.get_quantity, q6.get_uom, q6.get_price, -- q2.creation_date, q2.created_by, q2.last_update_date, q2.last_updated_by, -- q1.pricing_transaction_entity, q1.source_application, 1 sort_order from q1, q2, q3, q4, q5, q6 where q1.list_header_id1 = q2.list_header_id2 and q2.list_line_id2 = -1 and nvl2(q1.list_header_id1,-1,-1) = q3.list_header_id3 (+) and nvl2(q3.list_line_id3,-1,-1) = q4.parent_list_line_id4 (+) and nvl2(q3.list_line_id3,-1,-1) = q5.parent_list_line_id5 (+) and nvl2(q3.list_line_id3,-1,-1) = q6.parent_list_line_id6 (+) -- union -- List Lines -- Q1, Q3 select /*+ push_pred(q2) push_pred(q3) push_pred(q4) push_pred(q5) push_pred(q6) */ q1.modifier_number, q1.modifier_name, q1.version, q1.description, q1.currency, q1.modifier_effective_from, q1.modifier_effective_to, q1.type, q1.modifier_automatc_flag, q1.modifier_active_flag, q1.ask_for, q1.global_flag, q1.parent_number, q1.parent_version, q1.data_type_1, q1.data_type_1_effective_from, q1.data_type_1_effective_to, q1.data_type_2, q1.data_type_2_effective_from, q1.data_type_2_effective_to, -- 'List Line' record_type, -- q2.qualifier_group, q2.qualifier_grouping_number, q2.qualifier_start_date, q2.qualifier_end_date, q2.qualifier_context, q2.qualifier_attribute, q2.applies_to_party_hierarchy, q2.qualifier_precedence, q2.qualifier_operator_code, q2.qualifier_value_from, q2.qualifier_value_from_meaning, q2.qualifier_value_to, -- q3.list_line_no, q3.modifier_level, q3.line_effective_from, q3.line_effective_to, q3.list_line_type, q3.print_on_invoice_flag, q3.line_automatic_flag, q3.line_override_flag, q3.line_phase, q3.line_bucket, q3.line_proration_type, q3.comparison_value, q3.net_amount_calculation, q3.line_incompatibility_group, q3.line_product_attribute_type, q3.line_comparison_operator_code, q3.line_product_value, q3.line_precedence, q3.line_uom, q3.line_volume_type, q3.line_value_from, q3.line_value_to, q3.line_price_break_type, q3.accumulation_attribute, q3.charge_name, q3.line_formula, q3.line_appl_method, q3.line_value, q3.include_on_returns_flag, q3.accrual_flag, q3.upgrade_item, q3.terms_attribute, q3.terms_value, q3.coupon_expire_date, q3.coupon_expire_prd_start_date, q3.coupon_expire_periods, q3.expire_period_type, q3.coupon_benefit_qty, q3.coupon_benefit_uom, q3.estimated_benefit_rate, q3.coupon_conversion_rate, q3.coupon_modifier_number, -- q5.related_modifier_group_number, q4.price_break_attr_value_from, q4.price_break_attr_value_to, q5.product_attribute, q5.product_attribute_value, q6.product_attribute_uom, q5.pricing_attribute, q5.operator, q4.formula, q4.application_method, q4.value, q5.value_from, q5.value_to, q4.benefit_qty, q4.benefit_uom, q4.accrual_conversion_rate, q5.buy_uom, q6.get_quantity, q6.get_uom, q6.get_price, -- q3.creation_date, q3.created_by, q3.last_update_date, q3.last_updated_by, -- q1.pricing_transaction_entity, q1.source_application, 2 sort_order from q1, q2, q3, q4, q5, q6 where nvl2(q1.list_header_id1,-1,-1) = q2.list_header_id2 (+) and q1.list_header_id1 = q3.list_header_id3 and nvl2(q3.list_line_id3,-1,-1) = q4.parent_list_line_id4 (+) and nvl2(q3.list_line_id3,-1,-1) = q5.parent_list_line_id5 (+) and nvl2(q3.list_line_id3,-1,-1) = q6.parent_list_line_id6 (+) --and --not exists --(select 'X' from q2 where q3.list_line_id3 = q2.list_line_id2 -- union --(select 'X' from q4 where q3.list_line_id3 = q4.parent_list_line_id4 -- union -- select 'X' from q5 where q3.list_line_id3 = q5.parent_list_line_id5 -- union -- select 'X' from q6 where q3.list_line_id3 = q6.parent_list_line_id6 --) -- union -- List Line Qualifiers -- Q1, Q3, Q2 select /*+ push_pred(q2) push_pred(q3) push_pred(q4) push_pred(q5) push_pred(q6) */ q1.modifier_number, q1.modifier_name, q1.version, q1.description, q1.currency, q1.modifier_effective_from, q1.modifier_effective_to, q1.type, q1.modifier_automatc_flag, q1.modifier_active_flag, q1.ask_for, q1.global_flag, q1.parent_number, q1.parent_version, q1.data_type_1, q1.data_type_1_effective_from, q1.data_type_1_effective_to, q1.data_type_2, q1.data_type_2_effective_from, q1.data_type_2_effective_to, -- 'List Line - Qualifier' record_type, -- q2.qualifier_group, q2.qualifier_grouping_number, q2.qualifier_start_date, q2.qualifier_end_date, q2.qualifier_context, q2.qualifier_attribute, q2.applies_to_party_hierarchy, q2.qualifier_precedence, q2.qualifier_operator_code, q2.qualifier_value_from, q2.qualifier_value_from_meaning, q2.qualifier_value_to, -- q3.list_line_no, q3.modifier_level, q3.line_effective_from, q3.line_effective_to, q3.list_line_type, q3.print_on_invoice_flag, q3.line_automatic_flag, q3.line_override_flag, q3.line_phase, q3.line_bucket, q3.line_proration_type, q3.comparison_value, q3.net_amount_calculation, q3.line_incompatibility_group, q3.line_product_attribute_type, q3.line_comparison_operator_code, q3.line_product_value, q3.line_precedence, q3.line_uom, q3.line_volume_type, q3.line_value_from, q3.line_value_to, q3.line_price_break_type, q3.accumulation_attribute, q3.charge_name, q3.line_formula, q3.line_appl_method, q3.line_value, q3.include_on_returns_flag, q3.accrual_flag, q3.upgrade_item, q3.terms_attribute, q3.terms_value, q3.coupon_expire_date, q3.coupon_expire_prd_start_date, q3.coupon_expire_periods, q3.expire_period_type, q3.coupon_benefit_qty, q3.coupon_benefit_uom, q3.estimated_benefit_rate, q3.coupon_conversion_rate, q3.coupon_modifier_number, -- q5.related_modifier_group_number, q4.price_break_attr_value_from, q4.price_break_attr_value_to, q5.product_attribute, q5.product_attribute_value, q6.product_attribute_uom, q5.pricing_attribute, q5.operator, q4.formula, q4.application_method, q4.value, q5.value_from, q5.value_to, q4.benefit_qty, q4.benefit_uom, q4.accrual_conversion_rate, q5.buy_uom, q6.get_quantity, q6.get_uom, q6.get_price, -- q2.creation_date, q2.created_by, q2.last_update_date, q2.last_updated_by, -- q1.pricing_transaction_entity, q1.source_application, 3 sort_order from q1, q2, q3, q4, q5, q6 where q1.list_header_id1 = q3.list_header_id3 and q3.list_header_id3 = q2.list_header_id2 and q3.list_line_id3 = q2.list_line_id2 and nvl2(q3.list_line_id3,-1,-1) = q4.parent_list_line_id4 (+) and nvl2(q3.list_line_id3,-1,-1) = q5.parent_list_line_id5 (+) and nvl2(q3.list_line_id3,-1,-1) = q6.parent_list_line_id6 (+) -- union -- Price Breaks -- Q1, Q3, Q4 select /*+ push_pred(q2) push_pred(q3) push_pred(q4) push_pred(q5) push_pred(q6) */ q1.modifier_number, q1.modifier_name, q1.version, q1.description, q1.currency, q1.modifier_effective_from, q1.modifier_effective_to, q1.type, q1.modifier_automatc_flag, q1.modifier_active_flag, q1.ask_for, q1.global_flag, q1.parent_number, q1.parent_version, q1.data_type_1, q1.data_type_1_effective_from, q1.data_type_1_effective_to, q1.data_type_2, q1.data_type_2_effective_from, q1.data_type_2_effective_to, -- 'List Line - Price Break' record_type, -- q2.qualifier_group, q2.qualifier_grouping_number, q2.qualifier_start_date, q2.qualifier_end_date, q2.qualifier_context, q2.qualifier_attribute, q2.applies_to_party_hierarchy, q2.qualifier_precedence, q2.qualifier_operator_code, q2.qualifier_value_from, q2.qualifier_value_from_meaning, q2.qualifier_value_to, -- q3.list_line_no, q3.modifier_level, q3.line_effective_from, q3.line_effective_to, q3.list_line_type, q3.print_on_invoice_flag, q3.line_automatic_flag, q3.line_override_flag, q3.line_phase, q3.line_bucket, q3.line_proration_type, q3.comparison_value, q3.net_amount_calculation, q3.line_incompatibility_group, q3.line_product_attribute_type, q3.line_comparison_operator_code, q3.line_product_value, q3.line_precedence, q3.line_uom, q3.line_volume_type, q3.line_value_from, q3.line_value_to, q3.line_price_break_type, q3.accumulation_attribute, q3.charge_name, q3.line_formula, q3.line_appl_method, q3.line_value, q3.include_on_returns_flag, q3.accrual_flag, q3.upgrade_item, q3.terms_attribute, q3.terms_value, q3.coupon_expire_date, q3.coupon_expire_prd_start_date, q3.coupon_expire_periods, q3.expire_period_type, q3.coupon_benefit_qty, q3.coupon_benefit_uom, q3.estimated_benefit_rate, q3.coupon_conversion_rate, q3.coupon_modifier_number, -- q5.related_modifier_group_number, q4.price_break_attr_value_from, q4.price_break_attr_value_to, q5.product_attribute, q5.product_attribute_value, q6.product_attribute_uom, q5.pricing_attribute, q5.operator, q4.formula, q4.application_method, q4.value, q5.value_from, q5.value_to, q4.benefit_qty, q4.benefit_uom, q4.accrual_conversion_rate, q5.buy_uom, q6.get_quantity, q6.get_uom, q6.get_price, -- q4.creation_date, q4.created_by, q4.last_update_date, q4.last_updated_by, -- q1.pricing_transaction_entity, q1.source_application, 4 sort_order from q1, q2, q3, q4, q5, q6 where nvl2(q1.list_header_id1,-1,-1) = q2.list_header_id2 (+) and q1.list_header_id1 = q3.list_header_id3 and q3.list_line_id3 = q4.parent_list_line_id4 and nvl2(q3.list_line_id3,-1,-1) = q5.parent_list_line_id5 (+) and nvl2(q3.list_line_id3,-1,-1) = q6.parent_list_line_id6 (+) -- union -- Pricing Attributes -- Q1, Q3, Q5 select /*+ push_pred(q2) push_pred(q3) push_pred(q4) push_pred(q5) push_pred(q6) */ q1.modifier_number, q1.modifier_name, q1.version, q1.description, q1.currency, q1.modifier_effective_from, q1.modifier_effective_to, q1.type, q1.modifier_automatc_flag, q1.modifier_active_flag, q1.ask_for, q1.global_flag, q1.parent_number, q1.parent_version, q1.data_type_1, q1.data_type_1_effective_from, q1.data_type_1_effective_to, q1.data_type_2, q1.data_type_2_effective_from, q1.data_type_2_effective_to, -- 'List Line - Pricing Attribute' record_type, -- q2.qualifier_group, q2.qualifier_grouping_number, q2.qualifier_start_date, q2.qualifier_end_date, q2.qualifier_context, q2.qualifier_attribute, q2.applies_to_party_hierarchy, q2.qualifier_precedence, q2.qualifier_operator_code, q2.qualifier_value_from, q2.qualifier_value_from_meaning, q2.qualifier_value_to, -- q3.list_line_no, q3.modifier_level, q3.line_effective_from, q3.line_effective_to, q3.list_line_type, q3.print_on_invoice_flag, q3.line_automatic_flag, q3.line_override_flag, q3.line_phase, q3.line_bucket, q3.line_proration_type, q3.comparison_value, q3.net_amount_calculation, q3.line_incompatibility_group, q3.line_product_attribute_type, q3.line_comparison_operator_code, q3.line_product_value, q3.line_precedence, q3.line_uom, q3.line_volume_type, q3.line_value_from, q3.line_value_to, q3.line_price_break_type, q3.accumulation_attribute, q3.charge_name, q3.line_formula, q3.line_appl_method, q3.line_value, q3.include_on_returns_flag, q3.accrual_flag, q3.upgrade_item, q3.terms_attribute, q3.terms_value, q3.coupon_expire_date, q3.coupon_expire_prd_start_date, q3.coupon_expire_periods, q3.expire_period_type, q3.coupon_benefit_qty, q3.coupon_benefit_uom, q3.estimated_benefit_rate, q3.coupon_conversion_rate, q3.coupon_modifier_number, -- q5.related_modifier_group_number, q4.price_break_attr_value_from, q4.price_break_attr_value_to, q5.product_attribute, q5.product_attribute_value, q6.product_attribute_uom, q5.pricing_attribute, q5.operator, q4.formula, q4.application_method, q4.value, q5.value_from, q5.value_to, q4.benefit_qty, q4.benefit_uom, q4.accrual_conversion_rate, q5.buy_uom, q6.get_quantity, q6.get_uom, q6.get_price, -- q5.creation_date, q5.created_by, q5.last_update_date, q5.last_updated_by, -- q1.pricing_transaction_entity, q1.source_application, 5 sort_order from q1, q2, q3, q4, q5, q6 where nvl2(q1.list_header_id1,-1,-1) = q2.list_header_id2 (+) and q1.list_header_id1 = q3.list_header_id3 and nvl2(q3.list_line_id3,-1,-1) = q4.parent_list_line_id4 (+) and q3.list_line_id3 = q5.parent_list_line_id5 and nvl2(q3.list_line_id3,-1,-1) = q6.parent_list_line_id6 (+) -- union -- Get Pricing Attributes -- Q1, Q3, Q6 select /*+ push_pred(q2) push_pred(q3) push_pred(q4) push_pred(q5) push_pred(q6) */ q1.modifier_number, q1.modifier_name, q1.version, q1.description, q1.currency, q1.modifier_effective_from, q1.modifier_effective_to, q1.type, q1.modifier_automatc_flag, q1.modifier_active_flag, q1.ask_for, q1.global_flag, q1.parent_number, q1.parent_version, q1.data_type_1, q1.data_type_1_effective_from, q1.data_type_1_effective_to, q1.data_type_2, q1.data_type_2_effective_from, q1.data_type_2_effective_to, -- 'List Line - Pricing Attribute' record_type, -- q2.qualifier_group, q2.qualifier_grouping_number, q2.qualifier_start_date, q2.qualifier_end_date, q2.qualifier_context, q2.qualifier_attribute, q2.applies_to_party_hierarchy, q2.qualifier_precedence, q2.qualifier_operator_code, q2.qualifier_value_from, q2.qualifier_value_from_meaning, q2.qualifier_value_to, -- q3.list_line_no, q3.modifier_level, q3.line_effective_from, q3.line_effective_to, q3.list_line_type, q3.print_on_invoice_flag, q3.line_automatic_flag, q3.line_override_flag, q3.line_phase, q3.line_bucket, q3.line_proration_type, q3.comparison_value, q3.net_amount_calculation, q3.line_incompatibility_group, q3.line_product_attribute_type, q3.line_comparison_operator_code, q3.line_product_value, q3.line_precedence, q3.line_uom, q3.line_volume_type, q3.line_value_from, q3.line_value_to, q3.line_price_break_type, q3.accumulation_attribute, q3.charge_name, q3.line_formula, q3.line_appl_method, q3.line_value, q3.include_on_returns_flag, q3.accrual_flag, q3.upgrade_item, q3.terms_attribute, q3.terms_value, q3.coupon_expire_date, q3.coupon_expire_prd_start_date, q3.coupon_expire_periods, q3.expire_period_type, q3.coupon_benefit_qty, q3.coupon_benefit_uom, q3.estimated_benefit_rate, q3.coupon_conversion_rate, q3.coupon_modifier_number, -- q5.related_modifier_group_number, q4.price_break_attr_value_from, q4.price_break_attr_value_to, q6.product_attribute, q6.product_attribute_value, q6.product_attribute_uom, q5.pricing_attribute, q5.operator, q6.formula, q6.application_method, q6.value, q5.value_from, q5.value_to, q4.benefit_qty, q4.benefit_uom, q4.accrual_conversion_rate, q5.buy_uom, q6.get_quantity, q6.get_uom, q6.get_price, -- q6.creation_date, q6.created_by, q6.last_update_date, q6.last_updated_by, -- q1.pricing_transaction_entity, q1.source_application, 6 sort_order from q1, q2, q3, q4, q5, q6 where nvl2(q1.list_header_id1,-1,-1) = q2.list_header_id2 (+) and q1.list_header_id1 = q3.list_header_id3 and nvl2(q3.list_line_id3,-1,-1) = q4.parent_list_line_id4 (+) and nvl2(q3.list_line_id3,-1,-1) = q5.parent_list_line_id5 (+) and q3.list_line_id3 = q6.parent_list_line_id6 ) x order by x.modifier_number, decode(x.sort_order,1,1,2), x.list_line_no, x.sort_order, x.qualifier_group, x.qualifier_grouping_number Y QP QPXPRMLS_XML AR QP تفاصيل المعامل Imported from BI Publisher Description: تقرير تفاصيل المعامل للقط الطلب Application: التسعير المتقدم Source: تفاصيل المعامل (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG D QP Modifikatordetails Imported from BI Publisher Description: Auswertung "Modifikatordetails" in Oracle QP Application: Advanced Pricing Source: Modifikatordetails (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG E QP Detalles de Modificador Imported from BI Publisher Description: Informe Detalles de Modificador para QP Application: Advanced Pricing Source: Detalles de Modificador (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG F QP Détails des conditions commerciales Imported from BI Publisher Description: Etat Détails des conditions commerciales pour QP Application: Advanced Pricing Source: Détails des conditions commerciales (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG I QP Dettagli modificatore Imported from BI Publisher Description: Rapporto Dettagli modificatore per QP Application: Advanced Pricing Source: Dettagli modificatore (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG JA QP モディファイア詳細 Imported from BI Publisher Description: QPモディファイア詳細レポート Application: Advanced Pricing Source: モディファイア詳細(XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG KO QP 수정자 상세내역 Imported from BI Publisher Description: QP 수정자 상세내역 보고서 Application: Advanced Pricing Source: 수정자 상세내역(XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG PTB QP Detalhes do Modificador Imported from BI Publisher Description: Relatório de Detalhes do Modificador para QP Application: Advanced Pricing Source: Detalhes do Modificador (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG RU QP Сведения о модификаторе Imported from BI Publisher Description: Подробный отчет о модификаторах для ДЦ Application: Диспетчер цен Source: Сведения о модификаторе (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG S QP Modifierardetaljer Imported from BI Publisher Description: Modifierardetaljrapport för QP Application: Advanced Pricing Source: Modifierardetaljer (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG TR QP Değiştirici Detayları Imported from BI Publisher Description: QP için Değiştirici Detayları Raporu Application: İleri Düzey Fiyatlandırma Source: Değiştirici Detayları (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG US QP Modifier Details Imported from BI Publisher Description: Modifier Details Report for QP Application: Advanced Pricing Source: Modifier Details (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG he Modifier Details (columns) are repeated across all rows pertaining to the Modifier The List Line Details (columns) are repeated across all rows pertaining to the List Line For a given modifier the row sequence is: - Modifier Level Qualifiers (sorted by qualifier group, qualifier grouping number) - Modifier List Lines (sorted by list line number) For each Modifier List the row sequence is: - List Line record type - List Line - Qualifiers (sorted by qualifier group, qualifier grouping number) - List Line - Price Breaks - List Line - Pricing Attributes You can filter on the Record Type column to restrict the data based on what you want to review (e.g just the Modifier Qualifiers, or just the Modifier Lines, or just the Line Level Qualifiers etc). ZHS QP 修改量详细信息 Imported from BI Publisher Description: QP 修改量明细报表 Application: 高级定价 Source: 修改量详细信息 (XML) Short Name: QPXPRMLS_XML DB package: QP_QPXPRMLS_XMLP_PKG Enginatics R12 only 1=1 2=2 :lp_active_date :lp_active_lines_only :lp_active_modifier_lines_only :lp_active_modifier_only :lp_active_only :lp_customer_class_id :lp_customer_id :lp_item_category_id :lp_item_id :lp_modifier_name :lp_modifier_number :lp_modifier_version :lp_price_list_id :p_active_modifier_lines :p_active_modifier_only :p_conc_request_id :p_customer_class_id :p_customer_id :p_enable_trace :p_end_date_active :p_item_category_id :p_item_id :p_modifier_name_from :p_modifier_name_to :p_modifier_number_from :p_modifier_number_to :p_modifier_version_from :p_modifier_version_to :p_price_list_id :p_qualifier_attribute_from :p_qualifier_attribute_to :p_qualifier_context :p_resp_id :p_sob_id :p_start_date_active :p_user_name :rp_company_name :rp_report_name 1 -130 :p_qualifier_attribute_to LOV Oracle QP_QUALIFIER_ATTRIBUTE_TO Y select qualifier_attr_value id, qualifier_attr_value value, null description from qp_qualifiers_v where qualifier_context=:$flex$.qp_qualifier_context and rowid in (select max(rowid) from qp_qualifiers_v group by qualifier_attr_value) order by value,description AR قيمة سمة المعيار إلى قيمة سمة المعيار إلى D Bis Kriterienattributwert Bis Kriterienattributwert E A Valor de Atributo de Cualificador A Valor de Atributo de Cualificador F Valeur de l'attribut du qualificatif - A Valeur de l'attribut du qualificatif - A I Valore attributo qualificatore - A Valore attributo qualificatore - A JA クオリファイア属性値:至 クオリファイア属性値:至 KO 구분자 속성 값: 까지 구분자 속성 값: 까지 PTB Valor do Atributo do Qualificador - Até Valor do Atributo do Qualificador - Até RU Значение атрибута описателя по Значение атрибута описателя по S Till kvalificerarevärde Till kvalificerarevärde TR Son Niteleyici Değeri Son Niteleyici Değeri US Qualifier Attibute Value To Qualifier Attibute Value To ZHS 限定词属性值至 限定词属性值至 2 -120 :p_qualifier_attribute_from LOV Oracle QP_QUALIFIER_ATTRIBUTE_FROM Y select qualifier_attr_value id, qualifier_attr_value value, null description from qp_qualifiers_v where qualifier_context=:$flex$.qp_qualifier_context and rowid in (select max(rowid) from qp_qualifiers_v group by qualifier_attr_value) order by value,description AR قيمة سمة المعيار من قيمة سمة المعيار من D Von Kriterienattributwert Von Kriterienattributwert E De Valor de Atributo de Cualificador De Valor de Atributo de Cualificador F Valeur de l'attribut du qualificatif - De Valeur de l'attribut du qualificatif - De I Valore attributo qualificatore - Da Valore attributo qualificatore - Da JA クオリファイア属性値:自 クオリファイア属性値:自 KO 구분자 속성 값: 부터 구분자 속성 값: 부터 PTB Valor do Atributo do Qualificador - De Valor do Atributo do Qualificador - De RU Значение атрибута описателя с Значение атрибута описателя с S Från kvalificerarevärde Från kvalificerarevärde TR İlk Niteleyici Değeri İlk Niteleyici Değeri US Qualifier Attibute Value From Qualifier Attibute Value From ZHS 限定词属性值自 限定词属性值自 3 -110 :p_qualifier_context LOV Oracle QP_QUALIFIER_CONTEXT Y select context id, context value, description description from qp_qualifier_context_v order by value,description AR سياق المعيار سياق المعيار D Kriterienkontext Kriterienkontext E Contexto de Cualificador Contexto de Cualificador F Contexte du qualificatif Contexte du qualificatif I Contesto qualificatore Contesto del qualificatore JA クオリファイア・コンテキスト クオリファイア・コンテキスト KO 구분자 컨텍스트 구분자 컨텍스트 PTB Contexto do Qualificador Contexto do Qualificador RU Контекст описателя Контекст описателя S Kvalificerarekontext Kvalificerarekontext TR Niteleyici İçeriği Niteleyici İçeriği US Qualifier Context Qualifier Context ZHS 限定词上下文 限定词上下文 4 -30 :p_user_name Char select fnd_global.user_name from dual AR اسم المستخدم اسم المستخدم D Benutzername Benutzername E Nombre del usuario Nombre del usuario F Nom utilisateur Nom utilisateur I Nome utente Nome utente JA ユーザー名 ユーザー名 KO 사용자명 사용자명 PTB Nome do Usuário Nome do Usuário RU Имя пользователя Имя пользователя S Användare Användare TR Kullanıcı Adı Kullanıcı Adı US User Name User Name ZHS 用户名 用户名 5 -20 :p_resp_id Number select fnd_global.resp_id from dual AR معرف المسئولية معرف المسئولية D Zuständigkeitskennung Zuständigkeitskennung E Id Responsabilidad Id Responsabilidad F ID responsabilité ID responsabilité I Id responsabilità Id responsabilità JA 職責ID 職責ID KO 권한 ID 권한 ID PTB Id da Responsabilidade Id da Responsabilidade RU Идент. полномочий Идент. полномочий S Behörighets-id Behörighets-id TR Sorumluluk No Sorumluluk No US Responsibility Id Responsibility Id ZHS 责任标识 责任标识 6 10 1=1 a.name >=:p_modifier_number_from LOV Oracle QP_MODIFIER_NUMBER Y select name id, name value, null description from qp_secu_list_headers_vl where list_type_code not in ('PRL','AGR','PML') and nvl(pte_code,'ORDFUL')<>'LOGSTX' and view_flag='Y' order by name AR رقم المعامل من رقم المعامل من D Von Modifikatornummer Von Modifikatornummer E De Número de Modificador De Número de Modificador F Numéro des conditions commerciales - De Numéro des conditions commerciales - De I Numero modificatore - Da Numero modificatore - Da JA モディファイア番号:自 モディファイア番号:自 KO 수정자 번호: 부터 수정자 번호: 부터 PTB Número do Modificador - De Número do Modificador - De RU Номер модификатора с Номер модификатора с S Från modifierarnummer Från modifierarnummer TR Değiştiren Numarası İlk Değiştiren Numarası İlk US Modifier Number From Modifier Number From ZHS 修改量编号自 修改量编号自 7 20 1=1 a.name <=:p_modifier_number_to LOV Oracle QP_MODIFIER_NUMBER Y select name id, name value, null description from qp_secu_list_headers_vl where list_type_code not in ('PRL','AGR','PML') and nvl(pte_code,'ORDFUL')<>'LOGSTX' and view_flag='Y' order by name :$flex$.Modifier_Number_From AR رقم المعامل إلى رقم المعامل إلى D Bis Modifikatornummer Bis Modifikatornummer E A Número de Modificador A Número de Modificador F Numéro des conditions commerciales - A Numéro des conditions commerciales - A I Numero modificatore - A Numero modificatore - A JA モディファイア番号:至 モディファイア番号:至 KO 수정자 번호: 까지 수정자 번호: 까지 PTB Número do Modificador - Até Número do Modificador - Até RU Номер модификатора по Номер модификатора по S Till modifierarnummer Till modifierarnummer TR Değiştiren Numarası Son Değiştiren Numarası Son US Modifier Number To Modifier Number To ZHS 修改量编号至 修改量编号至 8 30 1=1 a.description >= :p_modifier_name_from LOV Oracle QP_MODIFIER_NAME Y select description id, description value, null description from qp_secu_list_headers_vl d where list_type_code not in ('PRL','AGR','PML') and view_flag='Y' and nvl(pte_code,'ORDFUL')<>'LOGSTX' order by d.description AR اسم المعامل من اسم المعامل من D Von Modifikator Von Modifikator E De Nombre de Modificador De Nombre de Modificador F Nom des conditions commerciales - De Nom des conditions commerciales - De I Nome modificatore - Da Nome modificatore - Da JA モディファイア名:自 モディファイア名:自 KO 수정자명: 부터 수정자명: 부터 PTB Nome do Modificador - De Nome do Modificador - De RU Имя модификатора с Имя модификатора с S Från modifierarnamn Från modifierarnamn TR Değiştiren Adı İlk Değiştiren Adı İlk US Modifier Name From Modifier Name From ZHS 修改量名称自 修改量名称自 9 40 1=1 a.description <= :p_modifier_name_to LOV Oracle QP_MODIFIER_NAME Y select description id, description value, null description from qp_secu_list_headers_vl d where list_type_code not in ('PRL','AGR','PML') and view_flag='Y' and nvl(pte_code,'ORDFUL')<>'LOGSTX' order by d.description :$flex$.Modifier_Name_From AR اسم المعامل إلى اسم المعامل إلى D Bis Modifikator Bis Modifikator E A Nombre de Modificador A Nombre de Modificador F Nom des conditions commerciales - A Nom des conditions commerciales - A I Nome modificatore - A Nome modificatore - A JA モディファイア名:至 モディファイア名:至 KO 수정자명: 까지 수정자명: 까지 PTB Nome do Modificador - Até Nome do Modificador - Até RU Имя модификатора по Имя модификатора по S Till modifierarnamn Till modifierarnamn TR Değiştiren Adı Son Değiştiren Adı Son US Modifier Name To Modifier Name To ZHS 修改量名称至 修改量名称至 10 50 1=1 a.version_no >= :p_modifier_version_from LOV Oracle QP_VERSION_NUMBER Y select version_no id, version_no value, null description from qp_list_headers_vl where view_flag='Y' and row_id in (select max(row_id) from qp_list_headers_vl group by version_no) order by value,description AR نسخة المعامل من نسخة المعامل من D Von Modifikatorversion Von Modifikatorversion E De Versión de Modificador De Versión de Modificador F Version des conditions commerciales - De Version des conditions commerciales - De I Versione modificatore - Da Versione modificatore - Da JA モディファイア・バージョン:自 モディファイア・バージョン:自 KO 수정자 버전: 부터 수정자 버전: 부터 PTB Versão do Modificador - De Versão do Modificador - De RU Версия модификатора c Версия модификатора c S Från modifierarversion Från modifierarversion TR Değiştiren Sürümü İlk Değiştiren Sürümü İlk US Modifier Version From Modifier Version From ZHS 修改量版本自 修改量版本自 11 60 1=1 a.version_no <= :p_modifier_version_to LOV Oracle QP_VERSION_NUMBER Y select version_no id, version_no value, null description from qp_list_headers_vl where view_flag='Y' and row_id in (select max(row_id) from qp_list_headers_vl group by version_no) order by value,description :$flex$.Modifier_Version_From AR نسخة المعامل إلى نسخة المعامل إلى D Bis Modifikatorversion Bis Modifikatorversion E A Versión de Modificador A Versión de Modificador F Version des conditions commerciales - A Version des conditions commerciales - A I Versione modificatore - A Versione modificatore - A JA モディファイア・バージョン:至 モディファイア・バージョン:至 KO 수정자 버전: 까지 수정자 버전: 까지 PTB Versão do Modificador - Até Versão do Modificador - Até RU Версия модификатора по Версия модификатора по S Till modifierarversion Till modifierarversion TR Değiştiren Sürümü Son Değiştiren Sürümü Son US Modifier Version To Modifier Version To ZHS 修改量版本至 修改量版本至 12 70 1=1 a.start_date_active >= :p_start_date_active Date AR تاريخ بداية الفعالية تاريخ بداية الفعالية D Gültig von Gültig von E Fecha de Inicio Activa Fecha de Inicio Activa F Date de début de validité Date de début de validité I Data inizio validità Data inizio validità JA 開始有効日 開始有効日 KO 유효 시작 일자 유효 시작 일자 PTB Data Inicial de Ativação Data Inicial de Ativação RU Начало срока действия Начало срока действия S Startdatum för aktivering Startdatum för aktivering TR Etkin Başlangıç Tarihi Etkin Başlangıç Tarihi US Start Date Active Start Date Active ZHS 有效起始日期 有效起始日期 13 80 1=1 a.end_date_active < (:p_end_date_active+1) Date select fnd_date.date_to_chardate(fnd_date.canonical_to_date(:$flex$.start_date_active),0) from sys.dual AR تاريخ نهاية الفعالية تاريخ نهاية الفعالية D Gültig bis Gültig bis E Fecha de Finalización Activa Fecha de Finalización Activa F Date de fin de validité Date de fin de validité I Data fine validità Data fine validità JA 最終有効日 最終有効日 KO 유효 종료일자 유효 종료일자 PTB Data Final Ativação Data Final Ativação RU Окончание срока действия Окончание срока действия S Slutdatum för aktivering Slutdatum för aktivering TR Etkin Bitiş Tarihi Etkin Bitiş Tarihi US End Date Active End Date Active ZHS 有效终止日期 有效终止日期 14 90 1=1 a.active_flag = :p_active_modifier_only LOV Oracle QP: Yes/No Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning Y AR المعامل الفعال فقط المعامل الفعال فقط D Nur gültige Modifikatoren Nur gültige Modifikatoren E Sólo Modificador Activo Sólo Modificador Activo F Conditions commerciales actives uniquement Conditions commerciales actives uniquement I Solo modificatore attivo Solo modificatore attivo JA 有効モディファイアのみ 有効モディファイアのみ KO 유효 수정자만 유효 수정자만 PTB Modificador Ativo Somente Modificador Ativo Somente RU Только активный модификатор Только активный модификатор S Endast aktiv modifierare Endast aktiv modifierare TR Salt Etkin Değiştiren Salt Etkin Değiştiren US Active Modifier Only Active Modifier Only ZHS 仅限于有效修改量 仅限于有效修改量 15 100 2=2 nvl(trunc(a.start_date_active ),trunc(sysdate)) <= trunc(sysdate) and nvl(trunc(a.end_date_active ),trunc(sysdate)) >= trunc(sysdate) LOV Oracle QP: Yes/No Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by meaning Y Y AR سطور المعاملات الفعالة فقط سطور المعامل الفعالة فقط D Nur gültige Modifikatorpositionen Nur gültige Modifikatorpositionen E Sólo Líneas de Modificador Activo Sólo Líneas de Modificador Activo F Lignes actives des conditions commerciales uniquement Lignes actives des conditions commerciales uniquement I Solo linee modificatore attivo Solo linee modificatore attivo JA 有効モディファイア明細のみ 有効モディファイア明細のみ KO 유효 수정자 라인만 유효 수정자 라인만 PTB Linhas do Modificador Ativo Somente Linhas do Modificador Ativo Somente RU Только активные строки модификатора Только активные строки модификатора S Endast aktiva modifierarrader Endast aktiva modifierarrader TR Salt Etkin Değiştiren Satırları Salt Etkin Değiştiren Satırları US Active Modifier Lines Only Active Modifier Lines Only ZHS 仅限于有效修改量行 仅限于有效修改量行 16 140 1=1 exists (select null from qp_pricing_attributes q where q.product_attribute_context = 'ITEM' and a.list_header_id = q.list_header_id and q.product_attribute = 'PRICING_ATTRIBUTE1' and q.product_attr_value = :P_item_id ) LOV Oracle QP_ITEM_ID Y select inventory_item_id id, concatenated_segments value, padded_concatenated_segments description from mtl_system_items_kfv where organization_id=qp_util.get_item_validation_org order by concatenated_segments AR اسم صنف اسم صنف D Artikelbezeichnung Artikelbezeichnung E Nombre de Artículo Nombre de Artículo F Nom de l'article Nom de l'article I Nome articolo Nome articolo JA 品目名 品目名 KO 품목명 품목명 PTB Nome do Item Nome do Item RU Имя позиции Имя позиции S Artikelnamn Artikelnamn TR Kalem Adı Kalem Adı US Item Name Item Name ZHS 项目名称 项目名称 17 150 1=1 exists (select null from qp_pricing_attributes q where q.product_attribute_context = 'ITEM' and a.list_header_id = q.list_header_id and q.product_attribute = 'PRICING_ATTRIBUTE2' and q.product_attr_value = :P_item_category_id ) LOV Oracle ITEM_CATEGORY Y select category_id id, segment1 || '--' || segment2 value, null description from mtl_categories order by segment1,segment2 AR فئة الصنف فئة الصنف D Artikelkategorie Artikelkategorie E Categoría de Artículo Categoría de Artículo F Catégorie d'articles Catégorie d'articles I Categoria articolo Categoria articolo JA 品目カテゴリ 品目カテゴリ KO 품목 범주 품목 범주 PTB Categoria do Item Categoria do Item RU Категория позиции Категория позиции S Artikelkategori Artikelkategori TR Kalem Kategorisi Kalem Kategorisi US Item Category Item Category ZHS 项目类别 项目类别 18 160 1=1 exists (select null from qp_qualifiers q where q.qualifier_context = 'CUSTOMER' and a.list_header_id = q.list_header_id and q.qualifier_attribute = 'QUALIFIER_ATTRIBUTE2' and q.qualifier_attr_value = :P_customer_id ) LOV Oracle QP_CUSTOMERS_CHAR Y select customer_id id, customer_name value, customer_number description from qp_customers_v order by customer_name AR اسم العميل اسم العميل D Kundenname Kundenname E Nombre de Cliente Nombre de Cliente F Nom du client Nom du client I Nome cliente Nome cliente JA 顧客名 顧客名 KO 고객명 고객명 PTB Nome do Cliente Nome do Cliente RU Имя заказчика Имя заказчика S Kund Kund TR Müşteri Adı Müşteri Adı US Customer Name Customer Name ZHS 客户名称 客户名称 19 170 1=1 exists (select null from qp_qualifiers q where q.qualifier_context = 'CUSTOMER' and a.list_header_id = q.list_header_id and q.qualifier_attribute = 'QUALIFIER_ATTRIBUTE1' and q.qualifier_attr_value = :P_customer_class_id ) LOV Oracle QP_CUSTOMER_CLASS Y select lookup_code id, lookup_code value, meaning description from ar_lookups where lookup_type='CUSTOMER CLASS' and enabled_flag='Y' order by value,description AR طبقة العميل طبقة العميل D Kundenklasse Kundenklasse E Clase de Cliente Clase de Cliente F Classe de clients Classe de clients I Classe cliente Classe cliente JA 顧客区分 顧客区分 KO 고객 분류 고객 분류 PTB Classe do Cliente Classe do Cliente RU Класс заказчика Класс заказчика S Kundklass Kundklass TR Müşteri Sınıfı Müşteri Sınıfı US Customer Class Customer Class ZHS 客户分类 客户分类 20 180 1=1 exists (select null from qp_qualifiers q where q.qualifier_context = 'MODLIST' and a.list_header_id = q.list_header_id and q.qualifier_attribute = 'QUALIFIER_ATTRIBUTE4' and q.qualifier_attr_value = :P_price_list_id ) LOV Oracle QP_SRS_PRICE_LIST_NAME_REPORTS Y select list_header_id id, name value, substr(description,0,240) description from qp_secu_list_headers_vl where list_type_code in ('PRL','AGR') and nvl(pte_code,'ORDFUL')<>'LOGSTX' and view_flag='Y' order by name AR قائمة الأسعار قائمة الأسعار D Preisliste Preisliste E Lista de Precios Lista de Precios F Tarif Tarif I Listino prezzi Listino prezzi JA 価格表 価格表 KO 가격 목록 가격 목록 PTB Lista de Preços Lista de Preços RU Прейскурант Прейскурант S Prislista Prislista TR Fiyat Listesi Fiyat Listesi US Price List Price List ZHS 价目表 价目表 :$flex$.Modifier_Name_From Modifier Name From Modifier Name To :$flex$.Modifier_Number_From Modifier Number From Modifier Number To :$flex$.Modifier_Version_From Modifier Version From Modifier Version To :$flex$.qp_qualifier_context Qualifier Context Qualifier Attibute Value From :$flex$.qp_qualifier_context Qualifier Context Qualifier Attibute Value To :$flex$.start_date_active Start Date Active Y End Date Active Default SYSADMIN 89 ACCRUAL_CONVERSION_RATE 61 ACCRUAL_FLAG 55 ACCUMULATION_ATTRIBUTE 83 APPLICATION_METHOD 28 APPLIES_TO_PARTY_HIERARCHY 11 ASK_FOR 87 BENEFIT_QTY 88 BENEFIT_UOM 90 BUY_UOM 56 CHARGE_NAME 43 COMPARISON_VALUE 69 COUPON_BENEFIT_QTY 70 COUPON_BENEFIT_UOM 72 COUPON_CONVERSION_RATE 65 COUPON_EXPIRE_DATE 67 COUPON_EXPIRE_PERIODS 66 COUPON_EXPIRE_PRD_START_DATE 73 COUPON_MODIFIER_NUMBER 5 CURRENCY 15 DATA_TYPE_1 16 DATA_TYPE_1_EFFECTIVE_FROM 17 DATA_TYPE_1_EFFECTIVE_TO 18 DATA_TYPE_2 19 DATA_TYPE_2_EFFECTIVE_FROM 20 DATA_TYPE_2_EFFECTIVE_TO 4 DESCRIPTION 71 ESTIMATED_BENEFIT_RATE 68 EXPIRE_PERIOD_TYPE 82 FORMULA 93 GET_PRICE 91 GET_QUANTITY 92 GET_UOM 12 GLOBAL_FLAG 60 INCLUDE_ON_RETURNS_FLAG 58 LINE_APPL_METHOD 38 LINE_AUTOMATIC_FLAG 41 LINE_BUCKET 47 LINE_COMPARISON_OPERATOR_CODE 34 LINE_EFFECTIVE_FROM 35 LINE_EFFECTIVE_TO 57 LINE_FORMULA 45 LINE_INCOMPATIBILITY_GROUP 39 LINE_OVERRIDE_FLAG 40 LINE_PHASE 49 LINE_PRECEDENCE 54 LINE_PRICE_BREAK_TYPE 46 LINE_PRODUCT_ATTRIBUTE_TYPE 48 LINE_PRODUCT_VALUE 42 LINE_PRORATION_TYPE 50 LINE_UOM 59 LINE_VALUE 52 LINE_VALUE_FROM 53 LINE_VALUE_TO 51 LINE_VOLUME_TYPE 32 LIST_LINE_NO 36 LIST_LINE_TYPE 2 MODIFER_NAME 10 MODIFIER_ACTIVE_FLAG 9 MODIFIER_AUTOMATC_FLAG 6 MODIFIER_EFFECTIVE_FROM 7 MODIFIER_EFFECTIVE_TO 33 MODIFIER_LEVEL 1 MODIFIER_NUMBER 44 NET_AMOUNT_CALCULATION 81 OPERATOR 13 PARENT_NUMBER 14 PARENT_VERSION 75 PRICE_BREAK_ATTR_VALUE_FROM 76 PRICE_BREAK_ATTR_VALUE_TO 80 PRICING_ATTRIBUTE 37 PRINT_ON_INVOICE_FLAG 77 PRODUCT_ATTRIBUTE 79 PRODUCT_ATTRIBUTE_UOM 78 PRODUCT_ATTRIBUTE_VALUE 27 QUALIFIER_ATTRIBUTE 26 QUALIFIER_CONTEXT 25 QUALIFIER_END_DATE 22 QUALIFIER_GROUP 23 QUALIFIER_GROUPING_NUMBER 29 QUALIFIER_OPERATOR_CODE 24 QUALIFIER_START_DATE 30 QUALIFIER_VALUE_FROM 31 QUALIFIER_VALUE_TO 21 RECORD_TYPE 74 RELATED_MODIFIER_GROUP_NUMBER 63 TERMS_ATTRIBUTE 64 TERMS_VALUE 8 TYPE 62 UPGRADE_ITEM 84 VALUE 85 VALUE_FROM 86 VALUE_TO 3 VERSION S Site Default