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_VIEW_UTIL dependencies on QP_QUALIFIERS

Line 23: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

19: ) RETURN VARCHAR2 IS
20:
21: x_return VARCHAR2(30) :=FND_API.G_MISS_CHAR;
22:
23: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
24: l_order_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
25: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
26: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
27: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

Line 24: l_order_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

20:
21: x_return VARCHAR2(30) :=FND_API.G_MISS_CHAR;
22:
23: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
24: l_order_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
25: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
26: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
27: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
28: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

Line 25: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

21: x_return VARCHAR2(30) :=FND_API.G_MISS_CHAR;
22:
23: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
24: l_order_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
25: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
26: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
27: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
28: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
29: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

Line 26: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

22:
23: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
24: l_order_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
25: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
26: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
27: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
28: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
29: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
30: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

Line 27: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

23: v_qualifier_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
24: l_order_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
25: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
26: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
27: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
28: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
29: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
30: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
31: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

Line 28: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

24: l_order_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
25: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
26: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
27: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
28: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
29: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
30: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
31: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
32: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

Line 29: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

25: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
26: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
27: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
28: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
29: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
30: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
31: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
32: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
33:

Line 30: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

26: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
27: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
28: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
29: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
30: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
31: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
32: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
33:
34: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;

Line 31: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

27: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
28: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
29: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
30: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
31: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
32: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
33:
34: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
35: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;

Line 32: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

28: v_qualifier_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
29: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
30: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
31: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
32: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
33:
34: v_product_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
35: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
36: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;

Line 54: from QP_QUALIFIERS

50: BEGIN
51:
52: select QUALIFIER_CONTEXT, QUALIFIER_ATTRIBUTE
53: into v_qualifier_context, v_qualifier_attribute
54: from QP_QUALIFIERS
55: where LIST_LINE_ID = p_list_line_id
56: and ( (QUALIFIER_CONTEXT = l_order_type_context
57: and QUALIFIER_ATTRIBUTE = l_order_type_attribute)
58: or (QUALIFIER_CONTEXT = l_customer_po_context

Line 109: l_order_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

105: ) RETURN VARCHAR2 IS
106:
107: x_return VARCHAR2(240) :=FND_API.G_MISS_CHAR;
108:
109: l_order_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
110: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
111: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
112: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
113: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

Line 110: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

106:
107: x_return VARCHAR2(240) :=FND_API.G_MISS_CHAR;
108:
109: l_order_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
110: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
111: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
112: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
113: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
114: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

Line 111: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

107: x_return VARCHAR2(240) :=FND_API.G_MISS_CHAR;
108:
109: l_order_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
110: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
111: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
112: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
113: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
114: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
115: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

Line 112: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

108:
109: l_order_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
110: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
111: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
112: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
113: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
114: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
115: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
116: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

Line 113: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

109: l_order_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
110: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
111: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
112: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
113: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
114: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
115: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
116: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
117:

Line 114: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

110: l_customer_po_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
111: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
112: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
113: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
114: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
115: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
116: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
117:
118: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;

Line 115: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

111: l_agreement_type_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
112: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
113: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
114: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
115: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
116: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
117:
118: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
119: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;

Line 116: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

112: l_agreement_name_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
113: l_order_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
114: l_customer_po_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
115: l_agreement_type_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
116: l_agreement_name_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
117:
118: l_item_no_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
119: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
120: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;

Line 123: v_qualifier_attr_value QP_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE;

119: l_item_category_attribute QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE%TYPE;
120: l_item_no_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
121: l_item_category_context QP_PRICING_ATTRIBUTES.PRODUCT_ATTRIBUTE_CONTEXT%TYPE;
122:
123: v_qualifier_attr_value QP_QUALIFIERS.QUALIFIER_ATTR_VALUE%TYPE;
124: v_product_attr_value QP_PRICING_ATTRIBUTES.PRODUCT_ATTR_VALUE%TYPE;
125:
126:
127: BEGIN

Line 137: from QP_QUALIFIERS

133:
134:
135: select QUALIFIER_ATTR_VALUE
136: into v_qualifier_attr_value
137: from QP_QUALIFIERS
138: where LIST_LINE_ID = p_list_line_id
139: and ( (QUALIFIER_CONTEXT = l_order_type_context
140: and QUALIFIER_ATTRIBUTE = l_order_type_attribute)
141: or (QUALIFIER_CONTEXT = l_customer_po_context

Line 230: l_price_list_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

226: FUNCTION Get_Price_List_Attribute RETURN VARCHAR2 IS
227:
228: x_return VARCHAR2(30) :=FND_API.G_MISS_CHAR;
229:
230: l_price_list_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
231: l_price_list_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
232:
233:
234: BEGIN

Line 231: l_price_list_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

227:
228: x_return VARCHAR2(30) :=FND_API.G_MISS_CHAR;
229:
230: l_price_list_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
231: l_price_list_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
232:
233:
234: BEGIN
235:

Line 248: l_price_list_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;

244: FUNCTION Get_Price_List_Context RETURN VARCHAR2 IS
245:
246: x_return VARCHAR2(30) :=FND_API.G_MISS_CHAR;
247:
248: l_price_list_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
249: l_price_list_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
250:
251:
252: BEGIN

Line 249: l_price_list_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;

245:
246: x_return VARCHAR2(30) :=FND_API.G_MISS_CHAR;
247:
248: l_price_list_context QP_QUALIFIERS.QUALIFIER_CONTEXT%TYPE;
249: l_price_list_attribute QP_QUALIFIERS.QUALIFIER_ATTRIBUTE%TYPE;
250:
251:
252: BEGIN
253: