QP Modifier Details
Description
Categories: BI Publisher
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
Description: Modifier Details Report for QP
Application: Advanced Pricing
Source: Modifier Details (XML)
Short Name: QPXPRMLS_XML
DB package: QP_QPXPRMLS_XMLP_PKG
SELECT a.list_line_id,a.list_header_id list_header_id2,a.list_line_type_code,a.list_line_type,a.start_date_active,a.end_date_active, a.automatic_flag,a.modifier_level,a.price_break_type,a.arithmetic_operator_type, a.override_flag,a.print_on_invoice_flag,a.formula,a.incompatibility_grp, a.list_line_no,a.pricing_phase,a.estim_gl_value,a.proration_type, a.pricing_group_sequence,a.operand,a.accrual_flag,a.charge_name,a.include_on_returns_flag, a.related_item,a.substitution_attribute,a.substitution_value,a.charge_subtype_code, a.expiration_date,a.expiration_period_start_date,a.number_expiration_periods, a.expiration_period_uom,a.benefit_qty,a.benefit_uom_code,a.estim_accrual_rate, a.accrual_conversion_rate,a.product_precedence,product_attribute_type,product_attr_value, a.pricing_attr_value_from,a.pricing_attr_value_to,a.pricing_attribute,a.product_uom_code, a.comparison_operator_code ,a.net_amount_flag, a.accum_attribute, QP_QPXPRMLS_XMLP_PKG.cf_net_amount_calcformula(a.net_amount_flag) CF_NET_AMOUNT_CALC, QP_QPXPRMLS_XMLP_PKG.cf_coup_list_lineformula(a.list_line_id) CF_coup_list_line FROM qp_modifier_summary_v a WHERE 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 ) &LP_ACTIVE_MODIFIER_LINES_ONLY and a.list_header_id = :list_header_id10 ORDER BY a.list_line_no |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Modifier Number From |
|
LOV Oracle | |
Modifier Number To |
|
LOV Oracle | |
Modifier Name From |
|
LOV Oracle | |
Modifier Name To |
|
LOV Oracle | |
Modifier Version From |
|
LOV Oracle | |
Modifier Version To |
|
LOV Oracle | |
Start Date Active |
|
Date | |
End Date Active |
|
Date | |
Active Modifier Only |
|
LOV Oracle | |
Active Modifier Lines Only |
|
LOV Oracle | |
Qualifier Context |
|
LOV Oracle | |
Qualifier Attibute Value From |
|
LOV Oracle | |
Qualifier Attibute Value To |
|
LOV Oracle | |
Item Name |
|
LOV Oracle | |
Item Category |
|
LOV Oracle | |
Customer Name |
|
LOV Oracle | |
Customer Class |
|
LOV Oracle | |
Price List |
|
LOV Oracle |