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.OE_CONFIG_PRICE_UTIL dependencies on OE_ORDER_LINES

Line 42: do not update using old pricing data from oe_order_lines.

38:
39: Change Record:
40: bug fix: if in an existing configuration. qty of options modified,
41: selling price will be affected (list price we always get per unit.)
42: do not update using old pricing data from oe_order_lines.
43: oe_debug_pub.add('updating selling prices of already saved options', 1);
44:
45: bug 2211600 : operationis set to CREATE on the line records.
46:

Line 173: FROM OE_ORDER_LINES ol

169:
170: UPDATE CZ_PRICING_STRUCTURES cz
171: SET cz.list_price =
172: ( SELECT ol.unit_list_price
173: FROM OE_ORDER_LINES ol
174: WHERE ol.top_model_line_id = l_top_model_line_id
175: AND ol.component_code =
176: SUBSTR( cz.item_key, 1, INSTR(cz.item_key, ':') - 1)
177: --commented this check as for the first time when pricing call back is done the configuration_id

Line 178: --is not present in OE_ORDER_LINES table hence the query fails and price for the model is not

174: WHERE ol.top_model_line_id = l_top_model_line_id
175: AND ol.component_code =
176: SUBSTR( cz.item_key, 1, INSTR(cz.item_key, ':') - 1)
177: --commented this check as for the first time when pricing call back is done the configuration_id
178: --is not present in OE_ORDER_LINES table hence the query fails and price for the model is not
179: --displayed.
180: --AND ol.configuration_id = cz.config_item_id--bug#7595079
181: )
182: WHERE cz.configurator_session_key = p_config_session_key;

Line 187: FROM OE_ORDER_LINES ol

183:
184: UPDATE CZ_PRICING_STRUCTURES cz
185: SET cz.selling_price =
186: ( SELECT ol.unit_selling_price
187: FROM OE_ORDER_LINES ol
188: WHERE ol.top_model_line_id = l_top_model_line_id
189: AND ol.ordered_quantity = cz.quantity -- only if no change in qty
190: AND ol.component_code =
191: SUBSTR( cz.item_key, 1, INSTR(cz.item_key, ':') - 1)

Line 193: --is not present in OE_ORDER_LINES table hence the query fails and price for the model is not

189: AND ol.ordered_quantity = cz.quantity -- only if no change in qty
190: AND ol.component_code =
191: SUBSTR( cz.item_key, 1, INSTR(cz.item_key, ':') - 1)
192: --commented this check as for the first time when pricing call back is done the configuration_id
193: --is not present in OE_ORDER_LINES table hence the query fails and price for the model is not
194: --displayed.
195: --AND ol.configuration_id = cz.config_item_id--bug#7595079
196: )
197: WHERE cz.configurator_session_key = p_config_session_key;

Line 204: FROM OE_ORDER_LINES ol

200:
201: UPDATE CZ_PRICING_STRUCTURES cz
202: SET cz.list_price =
203: ( SELECT ol.unit_list_price
204: FROM OE_ORDER_LINES ol
205: WHERE ol.top_model_line_id = l_top_model_line_id
206: AND ol.component_code =
207: SUBSTR( cz.item_key, 1, INSTR(cz.item_key, ':') - 1)
208: )

Line 214: FROM OE_ORDER_LINES ol

210:
211: UPDATE CZ_PRICING_STRUCTURES cz
212: SET cz.selling_price =
213: ( SELECT ol.unit_selling_price
214: FROM OE_ORDER_LINES ol
215: WHERE ol.top_model_line_id = l_top_model_line_id
216: AND ol.ordered_quantity = cz.quantity -- only if no change in qty
217: AND ol.component_code =
218: SUBSTR( cz.item_key, 1, INSTR(cz.item_key, ':') - 1))