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_SET_UTIL dependencies on OE_ORDER_LINES_ALL

Line 243: From oe_order_lines_all

239: BEGIN
240:
241: Select header_id
242: Into l_header_id
243: From oe_order_lines_all
244: Where line_id = p_line_rec.service_reference_line_id;
245:
246: EXCEPTION
247: WHEN No_Data_Found THEN RETURN FALSE; -- Bug 16561155

Line 279: oe_order_lines_all where

275: x_msg_count number;
276: x_msg_data varchar2(2000);
277: Cursor C1 is
278: Select line_id from
279: oe_order_lines_all where
280: top_model_line_id = p_line_id and
281: --item_type_code = 'INCLUDED' and
282: nvl(cancelled_flag,'N') <> 'Y' and
283: nvl(model_remnant_flag,'N') <> 'Y' and

Line 564: oe_order_lines_all where

560: Select Ordered_quantity,
561: header_id,
562: Line_id
563: from
564: oe_order_lines_all where
565: top_model_line_id = l_line_id and
566: --and line_id <> l_line_id and
567: nvl(cancelled_flag,'N') <> 'Y' and
568: nvl(model_remnant_flag,'N') <> 'Y'

Line 758: oe_order_lines_all where

754: Select Ordered_quantity,
755: header_id,
756: Line_id
757: from
758: oe_order_lines_all where
759: top_model_line_id = l_line_id
760: and line_id <> l_line_id and
761: nvl(cancelled_flag,'N') <> 'Y' and
762: nvl(model_remnant_flag,'N') <> 'Y'

Line 966: oe_order_lines_all

962: schedule_arrival_date,
963: ship_set_id,
964: arrival_set_id
965: from
966: oe_order_lines_all
967: where
968: line_id = l_top_model_line_id ;
969: /*nvl(cancelled_flag,'N') <> 'Y' and
970: nvl(model_remnant_flag,'N') <> 'Y'

Line 2294: oe_order_lines_all

2290: Ship_from_org_id,
2291: ship_to_org_id,
2292: schedule_arrival_date
2293: from
2294: oe_order_lines_all
2295: where
2296: line_id = l_top_model_line_id ;
2297: /*nvl(cancelled_flag,'N') <> 'Y' and
2298: nvl(model_remnant_flag,'N') <> 'Y'

Line 4097: FROM OE_ORDER_LINES_ALL WHERE

4093: BEGIN
4094:
4095: SELECT arrival_set_id INTO
4096: x_arrival_set_id
4097: FROM OE_ORDER_LINES_ALL WHERE
4098: header_id = p_header_id AND
4099: ship_set_id = p_ship_set_id AND
4100: arrival_set_id IS NOT NULL AND
4101: rownum = 1;

Line 4144: stmt_str := 'UPDATE OE_ORDER_LINES_ALL ' ||

4140: column2 := 'ATO_LINE_ID';
4141: parent_line_id := p_ato_line_id;
4142: END IF;
4143:
4144: stmt_str := 'UPDATE OE_ORDER_LINES_ALL ' ||
4145: 'SET ' || column1 || ' = ' || to_char(p_set_id) ||
4146: 'WHERE ' || column2 || ' = ' ||to_char(parent_line_id);
4147:
4148:

Line 5918: Update oe_order_lines_all

5914:
5915: IF l_Set_type = 'SHIP_SET' THEN
5916: l_line_tbl(K).ship_set_id := l_Set_id;
5917: /*IF l_line_tbl(K).item_type_code = 'KIT' THEN
5918: Update oe_order_lines_all
5919: set ship_set_id = l_set_id where
5920: top_model_line_id = l_line_tbl(K).line_id and
5921: item_type_code = 'INCLUDED';
5922: END IF; */

Line 5926: Update oe_order_lines_all

5922: END IF; */
5923: ELSIF l_Set_type = 'ARRIVAL_SET' THEN
5924: l_line_tbl(K).arrival_set_id := l_Set_id;
5925: /*IF l_line_tbl(K).item_type_code = 'KIT' THEN
5926: Update oe_order_lines_all
5927: set arrival_set_id = l_set_id where
5928: top_model_line_id = l_line_tbl(K).line_id and
5929: item_type_code = 'INCLUDED';
5930: END IF; */

Line 6224: from oe_sets, oe_order_lines_all

6220:
6221: -- Added for ER 2843738
6222: CURSOR C_profile is
6223: select set_id
6224: from oe_sets, oe_order_lines_all
6225: where line_id = p_x_line_rec.line_id
6226: and set_type = l_set_pref_type
6227: and set_status = 'T'
6228: AND set_id = Nvl(ship_set_id, arrival_set_id);

Line 6241: from oe_order_lines_all

6237: AND Nvl(ship_from_org_id,p_x_line_rec.ship_from_org_id) = p_x_line_rec.ship_from_org_id;
6238:
6239: CURSOR C5 IS
6240: Select line_id, shipping_interfaced_flag
6241: from oe_order_lines_all
6242: where top_model_line_id = p_x_line_rec.line_id
6243: and open_flag = 'Y';
6244:
6245: CURSOR C6 is

Line 6269: from oe_order_lines_all

6265: and set_name = nvl(p_x_line_rec.arrival_set,p_x_line_rec.ship_set);
6266:
6267: CURSOR C8 is
6268: select line_id,ship_set_id,arrival_set_id
6269: from oe_order_lines_all
6270: where top_model_line_id=p_x_line_rec.line_id
6271: and line_id<>p_x_line_rec.line_id
6272: and open_flag='Y';
6273:

Line 6279: FROM oe_order_lines_all

6275: SELECT inventory_item_id, ship_from_org_id, item_type_code,
6276: line_id,top_model_line_id,source_document_type_id, line_number,
6277: shipment_number, option_number, component_number, service_number,
6278: line_category_code --4241385
6279: FROM oe_order_lines_all
6280: WHERE ship_set_id = p_x_line_rec.ship_set_id;
6281:
6282: CURSOR C10 is
6283: select set_id

Line 6284: from oe_sets, oe_order_lines_all

6280: WHERE ship_set_id = p_x_line_rec.ship_set_id;
6281:
6282: CURSOR C10 is
6283: select set_id
6284: from oe_sets, oe_order_lines_all
6285: where line_id = p_x_line_rec.line_id
6286: and set_status = 'A'
6287: AND set_id = nvl(ship_set_id,arrival_set_id); --Bug 13691678
6288:

Line 6375: from oe_order_lines_all

6371: ELSE
6372: BEGIN
6373: select Nvl(ship_set_id,arrival_set_id)
6374: into l_set_id
6375: from oe_order_lines_all
6376: where line_id= p_x_line_rec.top_model_line_id;
6377: EXCEPTION
6378: WHEN OTHERS THEN NULL;
6379: END;

Line 6427: AND not exists (select line_id FROM oe_order_lines_all

6423: BEGIN
6424: select Min(set_id) INTO l_set_id from oe_sets
6425: where header_id = p_x_line_rec.header_id
6426: AND set_status = 'T'
6427: AND not exists (select line_id FROM oe_order_lines_all
6428: WHERE ship_set_id = set_id);
6429: oe_debug_pub.add( 'existing ship set id retrieved :' || l_set_id) ;
6430: EXCEPTION
6431: WHEN Others THEN NULL;

Line 6454: FROM oe_order_lines_all ol1

6450: -- Bug 13691678
6451: IF l_set_id IS NULL THEN
6452: BEGIN
6453: SELECT ol1.ship_set_id INTO l_set_id
6454: FROM oe_order_lines_all ol1
6455: WHERE ol1.line_id = p_x_line_rec.line_id
6456: AND NOT EXISTS ( SELECT 1 FROM oe_order_lines_all ol2
6457: WHERE ol2.ship_set_id = ol1.ship_set_id
6458: AND Nvl(ol2.top_model_line_id,ol2.line_id) <> ol1.line_id);

Line 6456: AND NOT EXISTS ( SELECT 1 FROM oe_order_lines_all ol2

6452: BEGIN
6453: SELECT ol1.ship_set_id INTO l_set_id
6454: FROM oe_order_lines_all ol1
6455: WHERE ol1.line_id = p_x_line_rec.line_id
6456: AND NOT EXISTS ( SELECT 1 FROM oe_order_lines_all ol2
6457: WHERE ol2.ship_set_id = ol1.ship_set_id
6458: AND Nvl(ol2.top_model_line_id,ol2.line_id) <> ol1.line_id);
6459: EXCEPTION
6460: WHEN Others THEN NULL;

Line 6979: UPDATE oe_order_lines_all

6975: /* if the new warehouse is valid on all the lines in the set, then update
6976: the new warehouse on all the lines and also update the set with the new
6977: warehouse information*/
6978:
6979: UPDATE oe_order_lines_all
6980: SET ship_from_org_id=p_x_line_rec.ship_from_org_id
6981: WHERE ship_set_id= p_x_line_rec.ship_set_id
6982: AND open_flag='Y';
6983:

Line 7065: UPDATE oe_order_lines_all

7061: /* if the new warehouse is valid on all the lines in the set, then update
7062: the new warehouse on all the lines and also update the set with the new
7063: warehouse information*/
7064:
7065: UPDATE oe_order_lines_all
7066: SET shipping_method_code=p_x_line_rec.shipping_method_code
7067: WHERE ship_set_id= p_x_line_rec.ship_set_id
7068: AND open_flag='Y';
7069:

Line 7163: from oe_order_lines_all ol

7159: IF l_set_type = 'ARRIVAL_SET' THEN
7160: begin
7161: select ol.arrival_set_id
7162: into l_old_set_id
7163: from oe_order_lines_all ol
7164: where ol.top_model_line_id = p_x_line_rec.line_id
7165: and ol.line_id<>p_x_line_rec.line_id
7166: and rownum=1;
7167: exception

Line 7178: from oe_order_lines_all ol

7174: ELSIF l_set_type='SHIP_SET' THEN
7175: begin
7176: select distinct(ol.ship_set_id)
7177: into l_old_set_id
7178: from oe_order_lines_all ol
7179: where ol.top_model_line_id = p_x_line_rec.line_id
7180: and ol.line_id<>p_x_line_rec.line_id
7181: and rownum=1;
7182: exception

Line 7196: Update oe_order_lines_all l

7192: END IF;
7193: /*Changes for bug 6719457 End*/
7194:
7195: Begin
7196: Update oe_order_lines_all l
7197: set
7198: arrival_set_id =
7199: decode(l_Set_type , 'ARRIVAL_SET', l_set_id,l.arrival_set_id),
7200: ship_set_id =

Line 7731: FROM oe_order_lines_all

7727: BEGIN
7728: IF p_request_rec.param3 = oe_schedule_util.OESCH_ENTITY_SHIP_SET THEN
7729: SELECT 1
7730: INTO l_dummy
7731: FROM oe_order_lines_all
7732: WHERE header_id=p_request_rec.param2
7733: AND ship_set_id =p_request_rec.param1
7734: AND ROWNUM =1;
7735:

Line 7742: FROM oe_order_lines_all

7738: END IF;
7739: ELSIF p_request_rec.param3 = oe_schedule_util.OESCH_ENTITY_ARRIVAL_SET THEN
7740: SELECT 1
7741: INTO l_dummy
7742: FROM oe_order_lines_all
7743: WHERE header_id=p_request_rec.param2
7744: AND arrival_set_id =p_request_rec.param1
7745: AND ROWNUM =1;
7746:

Line 7818: FROM OE_ORDER_LINES_ALL

7814: END IF;
7815:
7816: IF p_ship_set_id IS NOT NULL THEN
7817: SELECT line_type_id INTO l_line_type_id
7818: FROM OE_ORDER_LINES_ALL
7819: WHERE header_id = p_header_id
7820: AND ship_set_id = p_ship_set_id
7821: AND line_id <> p_line_id
7822: AND rownum=1;

Line 7846: FROM OE_ORDER_LINES_ALL

7842: RETURN TRUE;
7843: END IF;
7844: ELSE
7845: SELECT line_type_id INTO l_line_type_id
7846: FROM OE_ORDER_LINES_ALL
7847: WHERE header_id = p_header_id
7848: AND arrival_set_id = p_arrival_set_id
7849: AND line_id <> p_line_id
7850: AND rownum=1;