APPS.OE_DELAYED_REQUESTS_UTIL dependencies on OE_ORDER_LINES_ALL

Line 185: FROM OE_ORDER_LINES_ALL

181: SELECT Line_id, item_type_code,line_set_id,
182: Service_reference_line_id,
183: inventory_item_id,
184: service_reference_type_code --Bug 4946843
185: FROM OE_ORDER_LINES_ALL
186: WHERE Line_id = l_line_id;
187:
188: CURSOR MODEL_SERVICES IS
189: SELECT /* MOAC_SQL_CHANGE */ line_id, header_id

Line 193: FROM oe_order_lines_all

189: SELECT /* MOAC_SQL_CHANGE */ line_id, header_id
190: FROM OE_ORDER_LINES
191: WHERE service_reference_line_id
192: in (SELECT line_id
193: FROM oe_order_lines_all
194: WHERE top_model_line_id = l_line_id1)
195: AND line_id <> l_line_id and
196: inventory_item_id = l_temp_inv_item_id;
197:

Line 2385: FROM oe_order_lines_all

2381:
2382: BEGIN
2383: SELECT header_id
2384: INTO l_header_id
2385: FROM oe_order_lines_all
2386: WHERE line_id = p_entity_id;
2387: EXCEPTION
2388: WHEN OTHERS THEN
2389: RAISE;

Line 2468: FROM oe_order_lines_all

2464:
2465: BEGIN
2466: SELECT header_id
2467: INTO l_header_id
2468: FROM oe_order_lines_all
2469: WHERE line_id = p_entity_id;
2470: EXCEPTION
2471: WHEN OTHERS THEN
2472: RAISE;

Line 4687: FROM oe_order_lines_all

4683: -- schedule the whole ATO model.
4684: BEGIN
4685: SELECT ship_set_id,arrival_set_id
4686: INTO l_ship_set_id,l_arrival_set_id
4687: FROM oe_order_lines_all
4688: WHERE line_id = l_line_rec.ato_line_id;
4689: EXCEPTION
4690: WHEN OTHERS THEN
4691: l_ship_set_id := null;

Line 4883: UPDATE OE_ORDER_LINES_ALL

4879:
4880: IF p_sch_set_tbl(I).request_type = OE_GLOBALS.G_SCHEDULE_LINE
4881: THEN
4882:
4883: UPDATE OE_ORDER_LINES_ALL
4884: SET
4885: (SCHEDULE_SHIP_DATE,
4886: SCHEDULE_ARRIVAL_DATE,
4887: SHIP_FROM_ORG_ID,

Line 4895: FROM OE_ORDER_LINES_ALL

4891: null,
4892: decode(re_source_flag,'Y',ship_from_org_id,null),
4893: null,
4894: null
4895: FROM OE_ORDER_LINES_ALL
4896: WHERE line_id=l_line_rec.line_id)
4897: WHERE line_id = l_line_rec.line_id;
4898:
4899: ELSE

Line 4900: UPDATE OE_ORDER_LINES_ALL

4896: WHERE line_id=l_line_rec.line_id)
4897: WHERE line_id = l_line_rec.line_id;
4898:
4899: ELSE
4900: UPDATE OE_ORDER_LINES_ALL
4901: SET
4902: SCHEDULE_SHIP_DATE = l_old_line_rec.schedule_ship_date,
4903: SCHEDULE_ARRIVAL_DATE = l_old_line_rec.schedule_arrival_date,
4904: SHIP_FROM_ORG_ID = l_old_line_rec.ship_from_org_id,

Line 5158: OE_ORDER_LINES_all l

5154: l_order_quantity_uom,
5155: l_user_item_description,
5156: l_global_attribute_category
5157: FROM OE_ORDER_HEADERS h,
5158: OE_ORDER_LINES_all l
5159: WHERE l.HEADER_ID = h.HEADER_ID
5160: AND l.LINE_ID = l_line_id;
5161: -- incl. 3 parameters l_orig_sys_doc_ref,l_orig_sys_line_ref,l_order_src_id
5162: -- below to fix bug 2610630 and 2508851

Line 5280: UPDATE OE_ORDER_LINES_ALL

5276: else
5277: IF l_debug_level > 0 THEN
5278: oe_debug_pub.add('Updateing tax value from '||to_char(l_tax_value)|| ' To ' ||to_char(new_tax_value) ,2);
5279: END IF;
5280: UPDATE OE_ORDER_LINES_ALL
5281: SET TAX_VALUE = new_tax_value
5282: WHERE line_id = l_line_id;
5283:
5284: -- lkxu, if tax_value changes, log delayed request for commitment.

Line 5870: l_cons_price_request_code OE_ORDER_LINES_ALL.price_request_code%TYPE;

5866: l_parent_line_id NUMBER;
5867: l_header_id NUMBER;
5868: --bug#7491829
5869:
5870: l_cons_price_request_code OE_ORDER_LINES_ALL.price_request_code%TYPE;
5871: l_ret_price_request_code OE_ORDER_LINES_ALL.price_request_code%TYPE;
5872:
5873: CURSOR REFERENCED_LINE is
5874: SELECT return.price_request_code,

Line 5871: l_ret_price_request_code OE_ORDER_LINES_ALL.price_request_code%TYPE;

5867: l_header_id NUMBER;
5868: --bug#7491829
5869:
5870: l_cons_price_request_code OE_ORDER_LINES_ALL.price_request_code%TYPE;
5871: l_ret_price_request_code OE_ORDER_LINES_ALL.price_request_code%TYPE;
5872:
5873: CURSOR REFERENCED_LINE is
5874: SELECT return.price_request_code,
5875: referenced.pricing_quantity,

Line 5877: FROM OE_ORDER_LINES_ALL return , OE_ORDER_LINES_ALL referenced

5873: CURSOR REFERENCED_LINE is
5874: SELECT return.price_request_code,
5875: referenced.pricing_quantity,
5876: referenced.price_request_code
5877: FROM OE_ORDER_LINES_ALL return , OE_ORDER_LINES_ALL referenced
5878: WHERE return.line_id = p_line_id
5879: and referenced.line_id = return.reference_line_id;
5880:
5881: --bug #7491829

Line 5886: FROM OE_ORDER_LINES_ALL child, OE_ORDER_LINES_ALL parent

5882: CURSOR SPLIT_LINE IS
5883: SELECT parent.header_id,
5884: parent.pricing_quantity,
5885: parent.line_id
5886: FROM OE_ORDER_LINES_ALL child, OE_ORDER_LINES_ALL parent
5887: WHERE child.line_id = p_line_id
5888: and parent.line_id = child.split_from_line_id;
5889: --bug #7491829
5890:

Line 5984: update oe_order_lines_All

5980: END IF;
5981:
5982: --bug 7491829
5983: IF p_action_code = 'SPLIT_NEW' THEN
5984: update oe_order_lines_All
5985: set price_request_code = l_ret_price_request_code
5986: where line_id = p_line_id;
5987: END IF;
5988: --bug 7491829

Line 6569: from oe_order_lines_all

6565: END IF;
6566: Begin
6567: select nvl(ordered_quantity,0)
6568: into l_new_ord_quantity
6569: from oe_order_lines_all
6570: where line_id = p_line_id;
6571: End;
6572: IF l_new_ord_quantity = 0 THEN
6573: IF l_debug_level > 0 THEN