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_DELAYED_REQUESTS_UTIL dependencies on OE_ORDER_LINES

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 190: FROM OE_ORDER_LINES

186: WHERE Line_id = l_line_id;
187:
188: CURSOR MODEL_SERVICES IS
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)

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 834: oe_order_lines o

830:
831: CURSOR all_adjustments IS
832: SELECT p.price_adjustment_id, Nvl(p.line_id, -1) line_id
833: FROM oe_price_adjustments p,
834: oe_order_lines o
835: WHERE p.header_id = l_header_id
836: AND o.header_id = l_header_id
837: AND (p.line_id = o.line_id
838: OR p.line_id IS NULL)

Line 859: FROM OE_PRICE_ADJUSTMENTS P, OE_ORDER_LINES L

855:
856:
857: CURSOR max_line_adj_total IS
858: SELECT NVL( MAX(SUM(PERCENT)), 0) + l_percent_total
859: FROM OE_PRICE_ADJUSTMENTS P, OE_ORDER_LINES L
860: WHERE P.HEADER_ID = l_header_id
861: AND P.LINE_ID IS NOT NULL
862: AND P.LINE_ID = L.LINE_ID
863: GROUP BY P.line_id;

Line 1266: FROM oe_order_lines

1262: SELECT header_id, reference_header_id, reference_line_id,split_by
1263: ,SOURCE_DOCUMENT_TYPE_ID --added source document id as a part of 6778016
1264: INTO l_header_id,l_ref_header_id, l_ref_line_id, l_split_by
1265: ,l_src_doc_type_id --added l_src_doc_type_id as a part of 6778016
1266: FROM oe_order_lines
1267: WHERE line_id = p_line_id;
1268: EXCEPTION
1269: WHEN NO_DATA_FOUND THEN
1270: OE_DEBUG_PUB.ADD('Invalid line_id',1);

Line 1317: FROM oe_order_lines

1313: /* moved to the beginning of the procedure to fix bug 3317323
1314: BEGIN
1315: SELECT header_id, reference_header_id, reference_line_id
1316: INTO l_header_id,l_ref_header_id, l_ref_line_id
1317: FROM oe_order_lines
1318: WHERE line_id = p_line_id;
1319: EXCEPTION
1320: WHEN NO_DATA_FOUND THEN
1321: OE_DEBUG_PUB.ADD('Invalid line_id',1);

Line 1914: FROM oe_order_lines

1910: OE_debug_pub.add('Line ID: '|| l_request_rec.entity_id,1);
1911: BEGIN
1912: SELECT header_id
1913: INTO l_header_id
1914: FROM oe_order_lines
1915: WHERE line_id = l_request_rec.entity_id;
1916: OE_debug_pub.add('OEXUREQB:Header ID: '|| l_header_id);
1917:
1918:

Line 2077: FROM oe_order_lines

2073: OE_debug_pub.add('Line ID: '|| l_request_rec.entity_id,1);
2074: BEGIN
2075: SELECT header_id
2076: INTO l_header_id
2077: FROM oe_order_lines
2078: WHERE line_id = l_request_rec.entity_id;
2079: OE_debug_pub.add('OEXUREQB:Header ID: '|| l_header_id);
2080:
2081:

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 2765: from oe_order_lines

2761: -- for valid as well as complete .
2762:
2763: select booked_flag
2764: into l_complete_flag
2765: from oe_order_lines
2766: where line_id = p_top_model_line_id;
2767:
2768: l_complete_flag := nvl(l_complete_flag, 'N');
2769: oe_debug_pub.add('option added to a booked order? : '||l_complete_flag , 2);

Line 3003: FROM oe_order_lines l,mtl_system_items m

2999:
3000: -- l_component_code VARCHAR2(2000);
3001: CURSOR rma_children IS
3002: SELECT l.header_id, l.line_id, l.ordered_quantity
3003: FROM oe_order_lines l,mtl_system_items m
3004: WHERE l.top_model_line_id = l_top_model_line_id
3005: AND nvl(l.ato_line_id,1) = nvl(l_ato_line_id,nvl(l.ato_line_id,1))
3006: AND l.link_to_line_id = nvl(l_link_to_line_id,l.link_to_line_id)
3007: AND line_id <> l_reference_line_id

Line 3994: -- FROM oe_order_lines l

3990: -- l.service_start_date,
3991: -- l.service_end_date,
3992: -- l.service_coterminate_flag,
3993: -- l.ordered_quantity
3994: -- FROM oe_order_lines l
3995: -- WHERE l.top_model_line_id = l_service_reference_line_id
3996: -- AND l.item_type_code in ('INCLUDED','CLASS','OPTION')
3997: -- AND exists (select null from mtl_system_items mtl where
3998: -- mtl.inventory_item_id = l.inventory_item_id and

Line 4005: FROM oe_order_lines l

4001: --lchen added check for organizations to fix bug 2039304
4002:
4003: CURSOR srv_number IS
4004: SELECT max(l.service_number) service_number
4005: FROM oe_order_lines l
4006: WHERE l.header_id = l_header_id
4007: AND l.line_number = l_line_number
4008: AND l.shipment_number = l_shipment_number
4009: AND nvl(l.option_number,0) = nvl(l_option_number,0)

Line 4030: FROM oe_order_headers_all h, oe_order_lines l

4026: x_line_rec => l_orig_line_rec);
4027:
4028: SELECT /* MOAC_SQL_CHANGE */ h.order_number
4029: INTO l_order_number
4030: FROM oe_order_headers_all h, oe_order_lines l
4031: WHERE h.header_id = l.header_id
4032: AND h.header_id = l_orig_line_rec.header_id
4033: AND rownum = 1;
4034:

Line 4069: FROM oe_order_lines l

4065: l.service_start_date,
4066: l.service_end_date,
4067: l.service_coterminate_flag,
4068: l.ordered_quantity
4069: FROM oe_order_lines l
4070: WHERE l.top_model_line_id = l_service_reference_line_id
4071: AND l.item_type_code = 'INCLUDED'
4072: AND exists (select null from mtl_system_items mtl where
4073: mtl.inventory_item_id = l.inventory_item_id and

Line 4093: FROM oe_order_lines l

4089: l.service_start_date,
4090: l.service_end_date,
4091: l.service_coterminate_flag,
4092: l.ordered_quantity
4093: FROM oe_order_lines l
4094: WHERE l.top_model_line_id = l_service_reference_line_id
4095: AND l.top_model_line_id <> l.line_id -- For bug 2938790
4096: AND l.item_type_code in ('INCLUDED','CLASS','OPTION', 'KIT') -- For bug 2447402
4097: AND exists (select null from mtl_system_items mtl where

Line 4316: FROM oe_order_lines l

4312: l.service_end_date,
4313: l.service_coterminate_flag,
4314: l.order_quantity_uom,
4315: l.inventory_item_id
4316: FROM oe_order_lines l
4317: where l.service_reference_line_id=l_top_model_line_id
4318: and l.item_type_code = 'SERVICE'
4319: and l.service_reference_type_code = 'ORDER';
4320:

Line 4323: FROM oe_order_lines l

4319: and l.service_reference_type_code = 'ORDER';
4320:
4321: CURSOR srv_number IS
4322: SELECT max(l.service_number) service_number
4323: FROM oe_order_lines l
4324: WHERE l.header_id = l_header_id
4325: AND l.line_number = l_line_number
4326: AND l.shipment_number = l_shipment_number
4327: AND nvl(l.option_number,0) = nvl(l_option_number,0)

Line 4347: FROM oe_order_headers_all h, oe_order_lines l

4343: x_line_rec => l_orig_line_rec);
4344:
4345: SELECT /* MOAC_SQL_CHANGE */ h.order_number
4346: INTO l_order_number
4347: FROM oe_order_headers_all h, oe_order_lines l
4348: WHERE h.header_id = l.header_id
4349: AND h.header_id = l_orig_line_rec.header_id
4350: AND rownum = 1;
4351:

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 5048: l_pricing_quantity_uom oe_order_lines.pricing_quantity_uom%TYPE;

5044: l_source_document_id NUMBER;
5045: l_source_document_line_id NUMBER;
5046: l_actual_shipment_date DATE;
5047: l_schedule_ship_date DATE;
5048: l_pricing_quantity_uom oe_order_lines.pricing_quantity_uom%TYPE;
5049: l_order_quantity_uom oe_order_lines.order_quantity_uom%TYPE;
5050: l_user_item_description oe_order_lines.user_item_description%TYPE;
5051: l_global_attribute_category VARCHAR2(30);
5052: l_line_rec OE_Order_PUB.Line_Rec_Type;

Line 5049: l_order_quantity_uom oe_order_lines.order_quantity_uom%TYPE;

5045: l_source_document_line_id NUMBER;
5046: l_actual_shipment_date DATE;
5047: l_schedule_ship_date DATE;
5048: l_pricing_quantity_uom oe_order_lines.pricing_quantity_uom%TYPE;
5049: l_order_quantity_uom oe_order_lines.order_quantity_uom%TYPE;
5050: l_user_item_description oe_order_lines.user_item_description%TYPE;
5051: l_global_attribute_category VARCHAR2(30);
5052: l_line_rec OE_Order_PUB.Line_Rec_Type;
5053: l_header_rec OE_Order_PUB.Header_Rec_Type;

Line 5050: l_user_item_description oe_order_lines.user_item_description%TYPE;

5046: l_actual_shipment_date DATE;
5047: l_schedule_ship_date DATE;
5048: l_pricing_quantity_uom oe_order_lines.pricing_quantity_uom%TYPE;
5049: l_order_quantity_uom oe_order_lines.order_quantity_uom%TYPE;
5050: l_user_item_description oe_order_lines.user_item_description%TYPE;
5051: l_global_attribute_category VARCHAR2(30);
5052: l_line_rec OE_Order_PUB.Line_Rec_Type;
5053: l_header_rec OE_Order_PUB.Header_Rec_Type;
5054: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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 5677: FROM OE_ORDER_LINES

5673: ,subinventory
5674: ,source_document_id
5675: ,source_document_line_id
5676: ,item_type_code
5677: FROM OE_ORDER_LINES
5678: WHERE header_id = p_header_id;
5679:
5680: CURSOR employee_id_cur(p_user_id in number) IS
5681: SELECT employee_id

Line 5807: Update Oe_Order_lines

5803: FOR k in 1..l_req_line_tbl.count
5804: LOOP
5805: IF (l_req_line_tbl(k).requisition_line_id is not null) then
5806: BEGIN
5807: Update Oe_Order_lines
5808: Set source_document_id = l_req_header_rec.requisition_header_id
5809: ,source_document_line_id = l_req_line_tbl(k).requisition_line_id
5810: ,source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL -- i.e 10 for internal
5811: ,orig_sys_document_ref= l_req_header_rec.segment1

Line 5813: where oe_order_lines.line_id = l_req_line_tbl(k).source_doc_line_reference;

5809: ,source_document_line_id = l_req_line_tbl(k).requisition_line_id
5810: ,source_document_type_id = OE_GLOBALS.G_ORDER_SOURCE_INTERNAL -- i.e 10 for internal
5811: ,orig_sys_document_ref= l_req_header_rec.segment1
5812: ,orig_sys_line_ref = l_req_line_tbl(k).line_num
5813: where oe_order_lines.line_id = l_req_line_tbl(k).source_doc_line_reference;
5814: END;
5815: END IF;
5816: END LOOP;
5817: oe_debug_pub.add('auto_create_internal_req after line update ',2);

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