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 OE_SETS

Line 1322: oe_sets_s.nextval

1318:
1319: end if;
1320: IF g_include_ship_set = 'Y' THEN
1321: select
1322: oe_sets_s.nextval
1323: into
1324: g_set_id
1325: from dual;
1326:

Line 1329: insert into oe_sets

1325: from dual;
1326:
1327: G_ERROR_LOCATION := 704;
1328:
1329: insert into oe_sets
1330: (
1331: set_id,
1332: set_name,
1333: set_type,

Line 1756: select oe_sets_s.nextval

1752:
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: (

Line 1758: -- Also Insert into oe_sets

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,
1762: SET_NAME,

Line 1759: insert into oe_sets

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,
1762: SET_NAME,
1763: SET_TYPE,

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 5950: insert into oe_sets

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,
5953: SET_NAME,
5954: SET_TYPE,

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 6031: insert into oe_sets

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,
6034: SET_NAME,
6035: SET_TYPE,

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 8463: insert into oe_sets

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,
8466: FREIGHT_CARRIER_CODE, SHIPPING_METHOD_CODE,
8467: SHIPMENT_PRIORITY_CODE, SET_STATUS,

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 8725: insert into oe_sets

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,
8727: SHIP_TO_ORG_ID,SCHEDULE_SHIP_DATE, SCHEDULE_ARRIVAL_DATE,
8728: FREIGHT_CARRIER_CODE, SHIPPING_METHOD_CODE,
8729: SHIPMENT_PRIORITY_CODE, SET_STATUS,

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,

Line 8786: insert into oe_sets

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,
8788: SHIP_TO_ORG_ID,SCHEDULE_SHIP_DATE, SCHEDULE_ARRIVAL_DATE,
8789: FREIGHT_CARRIER_CODE, SHIPPING_METHOD_CODE,
8790: SHIPMENT_PRIORITY_CODE, SET_STATUS,