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

Line 158: from dual;

154: select
155: oe_price_adjustments_s.nextval
156: into
157: v_price_adjustment_id
158: from dual;
159: G_ERROR_LOCATION := 103;
160: exception
161: when no_data_found then
162: v_price_adjustment_id := mpa.price_adjustment_id;

Line 395: from dual;

391: select
392: oe_sales_credits_s.nextval
393: into
394: v_sales_credit_id
395: from dual;
396: exception
397: when no_data_found then
398: v_sales_credit_id := mscx.sales_credit_id;
399: when others then

Line 1325: from dual;

1321: select
1322: oe_sets_s.nextval
1323: into
1324: g_set_id
1325: from dual;
1326:
1327: G_ERROR_LOCATION := 704;
1328:
1329: insert into oe_sets

Line 1388: from dual;

1384: select
1385: oe_order_lines_s.nextval
1386: into
1387: g_line_id
1388: from dual;
1389: g_line_id_change_flag := 'N';
1390: g_line_rec.split_from_line_id := g_orig_line_id; -- 3103312
1391: else
1392: v_line_id := mol.line_id;

Line 1757: into r_line_set_id from dual;

1753: IF (v_received_quantity is not null and
1754: v_actual_ordered_quantity > v_received_quantity)
1755: AND v_return_lctr in (2,4) THEN
1756: select oe_sets_s.nextval
1757: into r_line_set_id from dual;
1758: -- Also Insert into oe_sets
1759: insert into oe_sets
1760: (
1761: SET_ID,

Line 1919: from dual;

1915: select
1916: oe_order_lines_s.nextval
1917: into
1918: v_return_created_line_id
1919: from dual;
1920: end if;
1921:
1922: if r_lctr = 1 then
1923: g_line_id := g_line_id;

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

5944: p_line_number := c2.line_number;
5945:
5946: /* Create a set */
5947:
5948: select oe_sets_s.nextval into v_set_id from dual;
5949:
5950: insert into oe_sets
5951: (
5952: SET_ID,

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

6025: for c6 in c5 loop
6026: v_line_id := c6.line_id;
6027: p_line_number := c6.line_number;
6028:
6029: select oe_sets_s.nextval into v_set_id from dual;
6030:
6031: insert into oe_sets
6032: (
6033: SET_ID,

Line 6325: FROM dual;

6321: l_new_line_rec := l_line_rec;
6322:
6323: SELECT oe_order_lines_s.nextval
6324: INTO l_new_line_rec.line_id
6325: FROM dual;
6326:
6327: l_new_line_rec.ato_line_id := l_new_line_rec.line_id;
6328:
6329: IF l_line_rec.line_id = l_line_rec.top_model_line_id

Line 6387: FROM dual;

6383: l_service_line_rec := Query_Row(l_service_line_id);
6384: Query_And_Set_Price_Attribs(l_service_line_rec.line_id,l_service_line_rec.header_id);
6385: SELECT oe_order_lines_s.nextval
6386: INTO l_service_line_rec.line_id
6387: FROM dual;
6388:
6389: l_service_line_rec.service_reference_line_id
6390: := l_new_line_rec.line_id;
6391: l_service_line_rec.ordered_quantity

Line 6407: FROM dual;

6403: l_new_line_rec := l_line_rec;
6404:
6405: SELECT oe_order_lines_s.nextval
6406: INTO l_new_line_rec.line_id
6407: FROM dual;
6408:
6409: l_new_line_rec.ato_line_id := l_model_rec.line_id;
6410: l_new_line_rec.top_model_line_id := l_model_rec.top_model_line_id;
6411: l_new_line_rec.link_to_line_id := null;

Line 6453: FROM dual;

6449: l_service_line_rec := Query_Row(l_service_line_id);
6450: Query_And_Set_Price_Attribs(l_service_line_rec.line_id,l_service_line_rec.header_id);
6451: SELECT oe_order_lines_s.nextval
6452: INTO l_service_line_rec.line_id
6453: FROM dual;
6454:
6455: l_service_line_rec.service_reference_line_id
6456: := l_new_line_rec.line_id;
6457: l_service_line_rec.ordered_quantity

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

8401: l_inventory_item_id := l_line_rec.inventory_item_id;
8402:
8403: For l_rec in C1 LOOP
8404:
8405: select oe_order_lines_s.nextval into l_line_id from dual;
8406:
8407: IF module is null then
8408: g_Last_Line_Number := g_Last_Line_Number +1;
8409: l_line_number := g_Last_Line_Number;

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

8457: Insert_Row(l_line_rec1,p_line_id,'Y','N');
8458:
8459: ELSE
8460:
8461: select oe_sets_s.nextval into l_line_set_id from dual;
8462:
8463: insert into oe_sets
8464: ( SET_ID, SET_NAME, SET_TYPE, HEADER_ID, SHIP_FROM_ORG_ID,
8465: SHIP_TO_ORG_ID,SCHEDULE_SHIP_DATE, SCHEDULE_ARRIVAL_DATE,

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

8487: l_line_rec1.line_set_id := l_line_set_id;
8488:
8489: Insert_Row(l_line_rec1,p_line_id,'Y','N');
8490:
8491: select oe_order_lines_s.nextval into l_line_id1 from dual;
8492:
8493: l_line_rec1.line_id := l_line_id1;
8494: l_line_rec1.shipment_number := 2;
8495: l_line_rec1.ordered_quantity := l_rec.quantity-l_rec.received_quantity;

Line 8722: select oe_sets_s.nextval into l_fulfillment_set_id from dual;

8718: --
8719: -- Add ATO model and its children into a Fulfillment Set
8720: --
8721:
8722: select oe_sets_s.nextval into l_fulfillment_set_id from dual;
8723: --insert into sets .....
8724:
8725: insert into oe_sets
8726: ( SET_ID, SET_NAME, SET_TYPE, HEADER_ID, SHIP_FROM_ORG_ID,

Line 8783: select oe_sets_s.nextval into l_fulfillment_set_id from dual;

8779: --
8780: -- Add PTO model/class/kit and its included items into a Fulfillment Set
8781: --
8782:
8783: select oe_sets_s.nextval into l_fulfillment_set_id from dual;
8784: --insert into sets .....
8785:
8786: insert into oe_sets
8787: ( SET_ID, SET_NAME, SET_TYPE, HEADER_ID, SHIP_FROM_ORG_ID,