eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PRICING_ENGINE_PVT dependencies on QP_QUALIFIERS

Line 36: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

32: err_msg VARCHAR2(100);
33:
34: v_product_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
35: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
36: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
37: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
38: v_customer_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
39: v_customer_class_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
40: v_sold_to_org_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

Line 37: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

33:
34: v_product_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
35: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
36: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
37: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
38: v_customer_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
39: v_customer_class_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
40: v_sold_to_org_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
41: v_site_org_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

Line 38: v_customer_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

34: v_product_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
35: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
36: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
37: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
38: v_customer_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
39: v_customer_class_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
40: v_sold_to_org_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
41: v_site_org_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
42: v_lines_flag VARCHAR2(1);

Line 39: v_customer_class_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

35: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
36: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
37: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
38: v_customer_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
39: v_customer_class_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
40: v_sold_to_org_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
41: v_site_org_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
42: v_lines_flag VARCHAR2(1);
43:

Line 40: v_sold_to_org_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

36: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
37: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
38: v_customer_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
39: v_customer_class_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
40: v_sold_to_org_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
41: v_site_org_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
42: v_lines_flag VARCHAR2(1);
43:
44:

Line 41: v_site_org_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

37: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
38: v_customer_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
39: v_customer_class_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
40: v_sold_to_org_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
41: v_site_org_attr QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
42: v_lines_flag VARCHAR2(1);
43:
44:
45: CURSOR get_discount_headers(p_context VARCHAR2,p_attribute VARCHAR2,p_attr_value VARCHAR2,

Line 51: FROM QP_LIST_HEADERS qph , QP_LIST_LINES qpl,QP_QUALIFIERS qpq

47: p_sold_to_org_attr VARCHAR2, p_site_org_attr VARCHAR2) IS
48:
49: SELECT qph.list_header_id,qph.name,qpl.list_line_id,qpl.list_line_type_code,
50: qpl.operand, qpl.arithmetic_operator,qph.discount_lines_flag
51: FROM QP_LIST_HEADERS qph , QP_LIST_LINES qpl,QP_QUALIFIERS qpq
52: WHERE qph.LIST_HEADER_ID = qpl.LIST_HEADER_ID
53: AND qpl.LIST_LINE_TYPE_CODE IN ('DIS','PBH')
54: AND qph.LIST_HEADER_ID = qpq.LIST_HEADER_ID
55: AND qph.AUTOMATIC_FLAG = 'Y'

Line 63: from qp_qualifiers qpq

59: AND qpq.QUALIFIER_ATTR_VALUE = p_attr_value
60: AND trunc(p_pricing_date) BETWEEN nvl(qpl.START_DATE_ACTIVE,trunc(p_pricing_date))
61: AND nvl(qpl.END_DATE_ACTIVE,trunc(p_pricing_date))
62: AND ( not exists (select null
63: from qp_qualifiers qpq
64: where qpq.list_header_id = qph.list_header_id
65: and qpq.qualifier_context = p_customer_context
66: and qpq.qualifier_attribute in (p_customer_class_attr , p_sold_to_org_attr, p_site_org_attr))
67: or

Line 69: from qp_qualifiers qpq

65: and qpq.qualifier_context = p_customer_context
66: and qpq.qualifier_attribute in (p_customer_class_attr , p_sold_to_org_attr, p_site_org_attr))
67: or
68: ( exists(select null
69: from qp_qualifiers qpq
70: where qpq.list_header_id = qph.list_header_id
71: and (qpq.qualifier_context = p_customer_context
72: and qpq.qualifier_attribute = p_sold_to_org_attr
73: and nvl(qpq.qualifier_attr_value,p_sold_to_org_id) = p_sold_to_org_id))

Line 75: from qp_qualifiers qpq

71: and (qpq.qualifier_context = p_customer_context
72: and qpq.qualifier_attribute = p_sold_to_org_attr
73: and nvl(qpq.qualifier_attr_value,p_sold_to_org_id) = p_sold_to_org_id))
74: or exists(select null
75: from qp_qualifiers qpq
76: where qpq.list_header_id = qph.list_header_id
77: and (qpq.qualifier_context = p_customer_context
78: and qpq.qualifier_attribute = p_customer_class_attr
79: and nvl(qpq.qualifier_attr_value,p_customer_class_code) = p_customer_class_code))

Line 81: from qp_qualifiers qpq

77: and (qpq.qualifier_context = p_customer_context
78: and qpq.qualifier_attribute = p_customer_class_attr
79: and nvl(qpq.qualifier_attr_value,p_customer_class_code) = p_customer_class_code))
80: and exists(select null
81: from qp_qualifiers qpq
82: where (qpq.qualifier_context = p_customer_context
83: and qpq.qualifier_attribute = p_site_org_attr
84: and (nvl(qpq.qualifier_attr_value,p_ship_to_id) = p_ship_to_id
85: or nvl(qpq.qualifier_attr_value,p_invoice_to_id) = p_invoice_to_id)))));

Line 103: FROM QP_LIST_LINES qpl, QP_QUALIFIERS qpq

99: AND trunc(p_pricing_date) BETWEEN nvl(qpl.START_DATE_ACTIVE,trunc(p_pricing_date))
100: AND nvl(qpl.END_DATE_ACTIVE,trunc(p_pricing_date))
101: UNION
102: SELECT 'Y'
103: FROM QP_LIST_LINES qpl, QP_QUALIFIERS qpq
104: WHERE qpl.LIST_LINE_ID = p_list_line_id
105: AND qpl.LIST_LINE_ID = qpq.LIST_LINE_ID
106: AND qpq.QUALIFIER_CONTEXT = p_qualifier_context
107: AND qpq.QUALIFIER_ATTRIBUTE = p_qualifier_attribute

Line 131: FROM QP_PRICING_ATTRIBUTES qpbl , QP_LIST_LINES qpl, QP_QUALIFIERS qpq, QP_RLTD_MODIFIERS qprl

127: AND nvl(qpl.END_DATE_ACTIVE,trunc(p_pricing_date))
128: UNION
129: SELECT qpbl.PRICING_ATTRIBUTE_ID,qpbl.LIST_LINE_ID,qpbl.PRICING_ATTRIBUTE_CONTEXT,qpbl.PRICING_ATTRIBUTE,
130: qpbl.PRICING_ATTR_VALUE_FROM, qpbl.PRICING_ATTR_VALUE_TO,qpl.OPERAND , qpl.ARITHMETIC_OPERATOR
131: FROM QP_PRICING_ATTRIBUTES qpbl , QP_LIST_LINES qpl, QP_QUALIFIERS qpq, QP_RLTD_MODIFIERS qprl
132: WHERE qpq.LIST_LINE_ID = p_list_line_id
133: AND qpq.QUALIFIER_CONTEXT = p_qualifier_context
134: AND qpq.QUALIFIER_ATTRIBUTE = p_qualifier_attribute
135: AND qpq.QUALIFIER_ATTR_VALUE = p_attribute_value