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_UPG_SO dependencies on DUAL

Line 83: from dual;

79: select
80: oe_price_adjustments_s.nextval
81: into
82: v_price_adjustment_id
83: from dual;
84: G_ERROR_LOCATION := 103;
85: exception
86: when no_data_found then
87: v_price_adjustment_id := mpa.price_adjustment_id;

Line 248: from dual;

244: select
245: oe_sales_credits_s.nextval
246: into
247: v_sales_credit_id
248: from dual;
249: exception
250: when no_data_found then
251: v_sales_credit_id := l_msc.sales_credit_id;
252: when others then

Line 1024: from dual;

1020: select
1021: oe_sets_s.nextval
1022: into
1023: g_set_id
1024: from dual;
1025:
1026: G_ERROR_LOCATION := 704;
1027:
1028: insert into oe_sets

Line 1081: from dual;

1077: select
1078: oe_order_lines_s.nextval
1079: into
1080: g_line_id
1081: from dual;
1082: g_line_id_change_flag := 'N';
1083: else
1084: v_line_id := mol.line_id;
1085: g_line_id := mol.line_id;

Line 1348: into r_line_set_id from dual;

1344: IF (v_received_quantity is not null and
1345: v_actual_ordered_quantity > v_received_quantity)
1346: AND v_return_lctr in (2,4) THEN
1347: select oe_sets_s.nextval
1348: into r_line_set_id from dual;
1349: -- Also Insert into oe_sets
1350: insert into oe_sets
1351: (
1352: SET_ID,

Line 1470: from dual;

1466: select
1467: oe_order_lines_s.nextval
1468: into
1469: v_return_created_line_id
1470: from dual;
1471: end if;
1472:
1473: if r_lctr = 1 then
1474: g_line_id := g_line_id;

Line 2382: from dual;

2378: decode(moh.order_category,'P','ORDER',
2379: 'R','ORDER','RMA','RETURN','*')
2380: into
2381: G_ORDER_CATEGORY_CODE
2382: from dual;
2383: exception
2384: when others then
2385: G_ORDER_CATEGORY_CODE := NULL;
2386: end;

Line 3803: select oe_sets_s.nextval into v_set_id from dual;

3799: p_line_number := c2.line_number;
3800:
3801: /* Create a set */
3802:
3803: select oe_sets_s.nextval into v_set_id from dual;
3804:
3805: insert into oe_sets
3806: (
3807: SET_ID,

Line 3884: select oe_sets_s.nextval into v_set_id from dual;

3880: for c6 in c5 loop
3881: v_line_id := c6.line_id;
3882: p_line_number := c6.line_number;
3883:
3884: select oe_sets_s.nextval into v_set_id from dual;
3885:
3886: insert into oe_sets
3887: (
3888: SET_ID,

Line 4145: FROM dual;

4141: l_new_line_rec := l_line_rec;
4142:
4143: SELECT oe_order_lines_s.nextval
4144: INTO l_new_line_rec.line_id
4145: FROM dual;
4146:
4147: l_new_line_rec.ato_line_id := l_new_line_rec.line_id;
4148: l_new_line_rec.top_model_line_id := l_new_line_rec.line_id;
4149: l_new_line_rec.link_to_line_id := null;

Line 4181: FROM dual;

4177: l_service_line_rec := Query_Row(l_service_line_id);
4178:
4179: SELECT oe_order_lines_s.nextval
4180: INTO l_service_line_rec.line_id
4181: FROM dual;
4182:
4183: l_service_line_rec.service_reference_line_id
4184: := l_new_line_rec.line_id;
4185: INSERT_ROW(l_service_line_rec,l_service_line_id,l_s_upgraded_flag);

Line 4199: FROM dual;

4195: l_new_line_rec := l_line_rec;
4196:
4197: SELECT oe_order_lines_s.nextval
4198: INTO l_new_line_rec.line_id
4199: FROM dual;
4200:
4201: l_new_line_rec.ato_line_id := l_model_rec.line_id;
4202: l_new_line_rec.top_model_line_id := l_model_rec.line_id;
4203: l_new_line_rec.link_to_line_id := null;

Line 4221: FROM dual;

4217: l_service_line_rec := Query_Row(l_service_line_id);
4218:
4219: SELECT oe_order_lines_s.nextval
4220: INTO l_service_line_rec.line_id
4221: FROM dual;
4222:
4223: l_service_line_rec.service_reference_line_id
4224: := l_new_line_rec.line_id;
4225:

Line 6113: select oe_order_lines_s.nextval into l_line_id from dual;

6109: l_inventory_item_id := l_line_rec.inventory_item_id;
6110:
6111: For l_rec in C1 LOOP
6112:
6113: select oe_order_lines_s.nextval into l_line_id from dual;
6114:
6115: IF module is null then
6116: g_Last_Line_Number := g_Last_Line_Number +1;
6117: l_line_number := g_Last_Line_Number;

Line 6164: select oe_sets_s.nextval into l_line_set_id from dual;

6160: Insert_Row(l_line_rec1,p_line_id,'Y','N');
6161:
6162: ELSE
6163:
6164: select oe_sets_s.nextval into l_line_set_id from dual;
6165:
6166: insert into oe_sets
6167: ( SET_ID, SET_NAME, SET_TYPE, HEADER_ID, SHIP_FROM_ORG_ID,
6168: SHIP_TO_ORG_ID,SCHEDULE_SHIP_DATE, SCHEDULE_ARRIVAL_DATE,

Line 6194: select oe_order_lines_s.nextval into l_line_id1 from dual;

6190: l_line_rec1.line_set_id := l_line_set_id;
6191:
6192: Insert_Row(l_line_rec1,p_line_id,'Y','N');
6193:
6194: select oe_order_lines_s.nextval into l_line_id1 from dual;
6195:
6196: l_line_rec1.line_id := l_line_id1;
6197: l_line_rec1.shipment_number := 2;
6198: l_line_rec1.ordered_quantity := l_rec.quantity-l_rec.received_quantity;

Line 6351: select oe_sets_s.nextval into l_line_set_id from dual;

6347: v_received_quantity := l_rec.received_quantity;
6348:
6349: l_line_rec := Query_Row(l_line_id);
6350:
6351: select oe_sets_s.nextval into l_line_set_id from dual;
6352:
6353: insert into oe_sets
6354: ( SET_ID, SET_NAME, SET_TYPE, HEADER_ID, SHIP_FROM_ORG_ID,
6355: SHIP_TO_ORG_ID,SCHEDULE_SHIP_DATE, SCHEDULE_ARRIVAL_DATE,

Line 6379: from dual;

6375:
6376:
6377: select oe_order_lines_s.nextval
6378: into l_line_id1
6379: from dual;
6380:
6381: l_line_rec2 := l_line_rec;
6382: l_line_rec2.line_id := l_line_id1;
6383: l_line_rec2.shipment_number := 2;