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 235: From oe_order_lines_all

231: BEGIN
232:
233: Select header_id
234: Into l_header_id
235: From oe_order_lines_all
236: Where line_id = p_line_rec.service_reference_line_id;
237:
238: END;
239: IF p_line_rec.header_id = l_header_id THEN

Line 269: oe_order_lines_all where

265: x_msg_count number;
266: x_msg_data varchar2(2000);
267: Cursor C1 is
268: Select line_id from
269: oe_order_lines_all where
270: top_model_line_id = p_line_id and
271: --item_type_code = 'INCLUDED' and
272: nvl(cancelled_flag,'N') <> 'Y' and
273: nvl(model_remnant_flag,'N') <> 'Y' and

Line 528: oe_order_lines_all where

524: Select Ordered_quantity,
525: header_id,
526: Line_id
527: from
528: oe_order_lines_all where
529: top_model_line_id = l_line_id and
530: --and line_id <> l_line_id and
531: nvl(cancelled_flag,'N') <> 'Y' and
532: nvl(model_remnant_flag,'N') <> 'Y'

Line 722: oe_order_lines_all where

718: Select Ordered_quantity,
719: header_id,
720: Line_id
721: from
722: oe_order_lines_all where
723: top_model_line_id = l_line_id
724: and line_id <> l_line_id and
725: nvl(cancelled_flag,'N') <> 'Y' and
726: nvl(model_remnant_flag,'N') <> 'Y'

Line 930: oe_order_lines_all

926: schedule_arrival_date,
927: ship_set_id,
928: arrival_set_id
929: from
930: oe_order_lines_all
931: where
932: line_id = l_top_model_line_id ;
933: /*nvl(cancelled_flag,'N') <> 'Y' and
934: nvl(model_remnant_flag,'N') <> 'Y'

Line 2241: oe_order_lines_all

2237: Ship_from_org_id,
2238: ship_to_org_id,
2239: schedule_arrival_date
2240: from
2241: oe_order_lines_all
2242: where
2243: line_id = l_top_model_line_id ;
2244: /*nvl(cancelled_flag,'N') <> 'Y' and
2245: nvl(model_remnant_flag,'N') <> 'Y'

Line 4040: FROM OE_ORDER_LINES_ALL WHERE

4036: BEGIN
4037:
4038: SELECT arrival_set_id INTO
4039: x_arrival_set_id
4040: FROM OE_ORDER_LINES_ALL WHERE
4041: header_id = p_header_id AND
4042: ship_set_id = p_ship_set_id AND
4043: arrival_set_id IS NOT NULL AND
4044: rownum = 1;

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

4083: column2 := 'ATO_LINE_ID';
4084: parent_line_id := p_ato_line_id;
4085: END IF;
4086:
4087: stmt_str := 'UPDATE OE_ORDER_LINES_ALL ' ||
4088: 'SET ' || column1 || ' = ' || to_char(p_set_id) ||
4089: 'WHERE ' || column2 || ' = ' ||to_char(parent_line_id);
4090:
4091:

Line 5861: Update oe_order_lines_all

5857:
5858: IF l_Set_type = 'SHIP_SET' THEN
5859: l_line_tbl(K).ship_set_id := l_Set_id;
5860: /*IF l_line_tbl(K).item_type_code = 'KIT' THEN
5861: Update oe_order_lines_all
5862: set ship_set_id = l_set_id where
5863: top_model_line_id = l_line_tbl(K).line_id and
5864: item_type_code = 'INCLUDED';
5865: END IF; */

Line 5869: Update oe_order_lines_all

5865: END IF; */
5866: ELSIF l_Set_type = 'ARRIVAL_SET' THEN
5867: l_line_tbl(K).arrival_set_id := l_Set_id;
5868: /*IF l_line_tbl(K).item_type_code = 'KIT' THEN
5869: Update oe_order_lines_all
5870: set arrival_set_id = l_set_id where
5871: top_model_line_id = l_line_tbl(K).line_id and
5872: item_type_code = 'INCLUDED';
5873: END IF; */

Line 6150: from oe_order_lines_all

6146: and set_status = 'T';
6147:
6148: CURSOR C5 IS
6149: Select line_id, shipping_interfaced_flag
6150: from oe_order_lines_all
6151: where top_model_line_id = p_x_line_rec.line_id
6152: and open_flag = 'Y';
6153:
6154: CURSOR C6 is

Line 6178: from oe_order_lines_all

6174: and set_name = nvl(p_x_line_rec.arrival_set,p_x_line_rec.ship_set);
6175:
6176: CURSOR C8 is
6177: select line_id,ship_set_id,arrival_set_id
6178: from oe_order_lines_all
6179: where top_model_line_id=p_x_line_rec.line_id
6180: and line_id<>p_x_line_rec.line_id
6181: and open_flag='Y';
6182:

Line 6685: from oe_order_lines_all ol

6681: IF l_set_type = 'ARRIVAL_SET' THEN
6682: begin
6683: select ol.arrival_set_id
6684: into l_old_set_id
6685: from oe_order_lines_all ol
6686: where ol.top_model_line_id = p_x_line_rec.line_id
6687: and ol.line_id<>p_x_line_rec.line_id
6688: and rownum=1;
6689: exception

Line 6700: from oe_order_lines_all ol

6696: ELSIF l_set_type='SHIP_SET' THEN
6697: begin
6698: select distinct(ol.ship_set_id)
6699: into l_old_set_id
6700: from oe_order_lines_all ol
6701: where ol.top_model_line_id = p_x_line_rec.line_id
6702: and ol.line_id<>p_x_line_rec.line_id
6703: and rownum=1;
6704: exception

Line 6718: Update oe_order_lines_all l

6714: END IF;
6715: /*Changes for bug 6719457 End*/
6716:
6717: Begin
6718: Update oe_order_lines_all l
6719: set
6720: arrival_set_id =
6721: decode(l_Set_type , 'ARRIVAL_SET', l_set_id,l.arrival_set_id),
6722: ship_set_id =

Line 7249: FROM oe_order_lines_all

7245: BEGIN
7246: IF p_request_rec.param3 = oe_schedule_util.OESCH_ENTITY_SHIP_SET THEN
7247: SELECT 1
7248: INTO l_dummy
7249: FROM oe_order_lines_all
7250: WHERE header_id=p_request_rec.param2
7251: AND ship_set_id =p_request_rec.param1
7252: AND ROWNUM =1;
7253:

Line 7260: FROM oe_order_lines_all

7256: END IF;
7257: ELSIF p_request_rec.param3 = oe_schedule_util.OESCH_ENTITY_ARRIVAL_SET THEN
7258: SELECT 1
7259: INTO l_dummy
7260: FROM oe_order_lines_all
7261: WHERE header_id=p_request_rec.param2
7262: AND arrival_set_id =p_request_rec.param1
7263: AND ROWNUM =1;
7264: