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_LIST_LINES

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 92: FROM QP_LIST_LINES qpl, QP_PRICING_ATTRIBUTES qpbl

88: (p_list_line_id NUMBER,p_product_attribute_context VARCHAR2,p_product_attribute VARCHAR2,
89: p_qualifier_context VARCHAR2 , p_qualifier_attribute VARCHAR2 ) IS
90:
91: SELECT 'X'
92: FROM QP_LIST_LINES qpl, QP_PRICING_ATTRIBUTES qpbl
93: WHERE qpl.LIST_LINE_ID = p_list_line_id
94: AND qpl.LIST_LINE_ID = qpbl.LIST_LINE_ID
95: AND qpbl.PRODUCT_ATTRIBUTE_CONTEXT = p_product_attribute_context
96: AND qpbl.PRODUCT_ATTRIBUTE = p_product_attribute

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 118: FROM QP_PRICING_ATTRIBUTES qpbl , QP_RLTD_MODIFIERS qprl, QP_LIST_LINES qpl

114: p_qualifier_context VARCHAR2 , p_qualifier_attribute VARCHAR2 ) IS
115:
116: SELECT qpbl.PRICING_ATTRIBUTE_ID,qpbl.LIST_LINE_ID,qpbl.PRICING_ATTRIBUTE_CONTEXT,qpbl.PRICING_ATTRIBUTE,
117: qpbl.PRICING_ATTR_VALUE_FROM, qpbl.PRICING_ATTR_VALUE_TO,qpl.OPERAND , qpl.ARITHMETIC_OPERATOR
118: FROM QP_PRICING_ATTRIBUTES qpbl , QP_RLTD_MODIFIERS qprl, QP_LIST_LINES qpl
119: WHERE qpl.LIST_LINE_ID = qpbl.LIST_LINE_ID
120: AND qpbl.LIST_LINE_ID = qprl.TO_RLTD_MODIFIER_ID
121: AND qpbl.PRODUCT_ATTRIBUTE_CONTEXT = p_product_attribute_context
122: AND qpbl.PRODUCT_ATTRIBUTE = p_product_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