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

Line 88: SELECT OE_LOT_SERIAL_S.NEXTVAL INTO l_lot_serial_id FROM DUAL;

84: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
85: --
86: BEGIN
87:
88: SELECT OE_LOT_SERIAL_S.NEXTVAL INTO l_lot_serial_id FROM DUAL;
89: RETURN l_lot_serial_id;
90:
91: END Get_Lot_Serial;
92:

Line 109: , dualum_ind

105: , discrete_item_id IN NUMBER) IS
106: SELECT item_id
107: , lot_ctl
108: -- , sublot_ctl INVCONV
109: , dualum_ind
110: FROM ic_item_mst
111: WHERE delete_mark = 0
112: AND item_no in (SELECT segment1
113: FROM mtl_system_items

Line 143: --l_dualum_ind NUMBER; INVCONV

139: l_order_quantity_uom VARCHAR2(3);
140: l_ordered_quantity_uom2 VARCHAR2(3);
141: l_lot_ctl NUMBER;
142: -- l_sublot_ctl NUMBER; INVCONV
143: --l_dualum_ind NUMBER; INVCONV
144: --l_lot_id NUMBER; -- INVCONV
145: -- l_item_id NUMBER; INVCONV
146: l_return NUMBER;
147: l_quantity NUMBER;

Line 187: IF oe_line_util.dual_uom_control -- INVCONV

183: END IF;
184: close c_lines;
185: end;
186:
187: IF oe_line_util.dual_uom_control -- INVCONV
188: (l_inventory_item_id,l_ship_from_org_id,l_item_rec)
189: Then
190:
191: IF l_debug_level > 0 THEN

Line 192: oe_debug_pub.add( 'Dual control RMA - get_quantity defaulting ' , 1 ) ;

188: (l_inventory_item_id,l_ship_from_org_id,l_item_rec)
189: Then
190:
191: IF l_debug_level > 0 THEN
192: oe_debug_pub.add( 'Dual control RMA - get_quantity defaulting ' , 1 ) ;
193: END IF;
194: /* begin
195: OPEN c_opm_item( l_ship_from_org_id,
196: l_inventory_item_id

Line 202: l_dualum_ind

198: FETCH c_opm_item
199: INTO l_item_id,
200: l_lot_ctl,
201: --l_sublot_ctl, INVCONV
202: l_dualum_ind
203: ;
204:
205: IF c_opm_item%NOTFOUND THEN
206: l_item_id := 0;

Line 209: l_dualum_ind := NULL;

205: IF c_opm_item%NOTFOUND THEN
206: l_item_id := 0;
207: l_lot_ctl := 0;
208: --l_sublot_ctl := 0; INVCONV
209: l_dualum_ind := NULL;
210:
211: END IF;
212:
213: Close c_opm_item;

Line 225: -- IF l_dualum_ind in(1,2) then

221: END IF;
222:
223: /* get quantity2 or check deviation but if type is 3 then quantity2 MUST be supplied */
224:
225: -- IF l_dualum_ind in(1,2) then
226: IF l_item_rec.secondary_default_ind in ('F','D') then -- INVCONV
227: l_quantity := g_Lot_Serial_rec.quantity;
228: l_quantity2 := g_Lot_Serial_rec.quantity2;
229:

Line 314: END IF; -- IF l_dualum_ind in(1,2) then

310: IF l_debug_level > 0 THEN
311: oe_debug_pub.add ('LOT SERIALS - returning quantity ....');
312: END IF; */
313:
314: END IF; -- IF l_dualum_ind in(1,2) then
315:
316:
317: else
318:

Line 321: END IF; -- IF oe_line_util.dual_uom_control -- INVCONV

317: else
318:
319: RETURN NULL;
320:
321: END IF; -- IF oe_line_util.dual_uom_control -- INVCONV
322:
323: end if; -- If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110510' or OE_GLOBALS.G_UI_FLAG = TRUE Then
324:
325: EXCEPTION

Line 380: , dualum_ind

376: , discrete_item_id IN NUMBER) IS
377: SELECT item_id
378: , lot_ctl
379: -- , sublot_ctl INVCONV
380: , dualum_ind
381: FROM ic_item_mst
382: WHERE delete_mark = 0
383: AND item_no in (SELECT segment1
384: FROM mtl_system_items

Line 412: --l_dualum_ind NUMBER;

408: l_order_quantity_uom VARCHAR2(3);
409: l_ordered_quantity_uom2 VARCHAR2(3);
410: --l_lot_ctl NUMBER;
411: --l_sublot_ctl NUMBER; INVCONV
412: --l_dualum_ind NUMBER;
413: --l_lot_id NUMBER;
414: --l_item_id NUMBER;
415: l_return NUMBER;
416: l_quantity NUMBER;

Line 450: IF oe_line_util.dual_uom_control -- INVCONV

446: END IF;
447: close c_lines;
448: end;
449:
450: IF oe_line_util.dual_uom_control -- INVCONV
451: (l_inventory_item_id,l_ship_from_org_id,l_item_rec)
452: Then
453:
454: IF l_debug_level > 0 THEN

Line 466: l_dualum_ind

462: FETCH c_opm_item
463: INTO l_item_id,
464: l_lot_ctl,
465: -- l_sublot_ctl, INVCONV
466: l_dualum_ind
467: ;
468:
469: IF c_opm_item%NOTFOUND THEN
470: l_item_id := 0;

Line 473: l_dualum_ind := NULL;

469: IF c_opm_item%NOTFOUND THEN
470: l_item_id := 0;
471: l_lot_ctl := 0;
472: -- l_sublot_ctl := 0; INVCONV
473: l_dualum_ind := NULL;
474:
475: END IF;
476: end; */
477:

Line 480: THEN -- INVCONV -- if not dual controlled then return null

476: end; */
477:
478: IF l_item_rec.tracking_quantity_ind <> 'PS' or -- INVCONV
479: l_item_rec.secondary_default_ind = 'N'
480: THEN -- INVCONV -- if not dual controlled then return null
481: return null;
482: END IF;
483:
484: /* get quantity2 or check deviation but if type is 3 then quantity2 MUST be supplied */

Line 486: -- INVCONV IF l_dualum_ind in(1,2) then

482: END IF;
483:
484: /* get quantity2 or check deviation but if type is 3 then quantity2 MUST be supplied */
485:
486: -- INVCONV IF l_dualum_ind in(1,2) then
487: IF l_item_rec.secondary_default_ind in ('F','D') then -- INVCONV
488: l_quantity := g_Lot_Serial_rec.quantity;
489: l_quantity2 := g_Lot_Serial_rec.quantity2;
490:

Line 575: END IF; -- IF l_dualum_ind in(1,2,3) then

571: END IF;
572:
573: return l_quantity2; */
574:
575: END IF; -- IF l_dualum_ind in(1,2,3) then
576: ELSE -- OPM 3610319
577:
578: return null;
579:

Line 580: END IF; -- IF oe_line_util.dual_uom_control -- INVCONV

576: ELSE -- OPM 3610319
577:
578: return null;
579:
580: END IF; -- IF oe_line_util.dual_uom_control -- INVCONV
581:
582: end if; -- If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' and OE_GLOBALS.G_UI_FLAG = FALSE Then
583:
584: EXCEPTION