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.INV_CYC_SERIALS dependencies on MTL_SERIAL_NUMBERS

Line 42: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

38: msn.lot_number,
39: 0,
40: msn.current_status,
41: mms.status_code
42: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
43: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
44: WHERE msn.inventory_item_id = p_inventory_item_id
45: AND msn.current_organization_id = p_organization_id
46: AND msn.current_status IN (1, 3)

Line 87: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

83: msn.lot_number,
84: 0,
85: msn.current_status,
86: mms.status_code
87: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
88: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
89: WHERE msn.inventory_item_id = p_inventory_item_id
90: AND msn.group_mark_id = 1
91: AND msn.current_organization_id = p_organization_id

Line 125: UPDATE mtl_serial_numbers

121: IS
122:
123: BEGIN
124: -- Multiple serial that are scheduled
125: UPDATE mtl_serial_numbers
126: SET group_mark_id = -1
127: WHERE inventory_item_id = p_inventory_item_id
128: AND current_organization_id = p_organization_id
129: AND serial_number IN

Line 131: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

127: WHERE inventory_item_id = p_inventory_item_id
128: AND current_organization_id = p_organization_id
129: AND serial_number IN
130: (SELECT UNIQUE msn.serial_number
131: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
132: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
133: WHERE msn.inventory_item_id = p_inventory_item_id
134: AND msn.current_organization_id = p_organization_id
135: AND msn.current_status IN (1, 3)

Line 179: FROM mtl_serial_numbers

175: INTO l_exist_temp
176: FROM DUAL
177: WHERE EXISTS
178: (SELECT 'multiple-serial'
179: FROM mtl_serial_numbers
180: WHERE inventory_item_id = p_inventory_item_id
181: AND current_organization_id = p_organization_id
182: AND serial_number IN
183: (SELECT UNIQUE msn.serial_number

Line 184: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

180: WHERE inventory_item_id = p_inventory_item_id
181: AND current_organization_id = p_organization_id
182: AND serial_number IN
183: (SELECT UNIQUE msn.serial_number
184: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
185: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
186: WHERE msn.inventory_item_id = p_inventory_item_id
187: AND msn.current_organization_id = p_organization_id
188: AND ( msn.current_status IN (1, 3)

Line 209: UPDATE mtl_serial_numbers

205: print_debug('l_exist_temp = ' || l_exist_temp);
206:
207: IF (l_exist_temp <> 0) THEN
208: -- The serial number entry exists and can be marked
209: UPDATE mtl_serial_numbers
210: SET group_mark_id = 1
211: WHERE inventory_item_id = p_inventory_item_id
212: AND current_organization_id = p_organization_id
213: AND serial_number = p_serial_number;

Line 253: FROM mtl_serial_numbers

249: INTO l_exist_temp
250: FROM DUAL
251: WHERE EXISTS
252: (SELECT 'multiple-serial'
253: FROM mtl_serial_numbers
254: WHERE inventory_item_id = p_inventory_item_id
255: AND current_organization_id = p_organization_id
256: AND serial_number IN
257: (SELECT UNIQUE msn.serial_number

Line 258: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

254: WHERE inventory_item_id = p_inventory_item_id
255: AND current_organization_id = p_organization_id
256: AND serial_number IN
257: (SELECT UNIQUE msn.serial_number
258: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
259: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
260: WHERE msn.inventory_item_id = p_inventory_item_id
261: AND msn.current_organization_id = p_organization_id
262: AND msn.current_status IN (1, 3)

Line 281: UPDATE mtl_serial_numbers

277: AND NVL(mcce.export_flag, 2) = 2));
278:
279: IF (l_exist_temp <> 0) THEN
280: -- The serial number entry exists so unmark that serial number
281: UPDATE mtl_serial_numbers
282: SET group_mark_id = -1
283: WHERE inventory_item_id = p_inventory_item_id
284: AND current_organization_id = p_organization_id
285: AND serial_number = p_serial_number;

Line 311: UPDATE mtl_serial_numbers

307: IS
308:
309: BEGIN
310: -- Multiple serial that are scheduled
311: UPDATE mtl_serial_numbers
312: SET group_mark_id = 1
313: WHERE inventory_item_id = p_inventory_item_id
314: AND current_organization_id = p_organization_id
315: AND serial_number IN

Line 317: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

313: WHERE inventory_item_id = p_inventory_item_id
314: AND current_organization_id = p_organization_id
315: AND serial_number IN
316: (SELECT UNIQUE msn.serial_number
317: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
318: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
319: WHERE msn.inventory_item_id = p_inventory_item_id
320: AND msn.current_organization_id = p_organization_id
321: AND msn.current_status IN (1, 3)

Line 355: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

351:
352: BEGIN
353: SELECT COUNT(*)
354: INTO x_number
355: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
356: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
357: WHERE msn.inventory_item_id = p_inventory_item_id
358: AND msn.group_mark_id = 1
359: AND msn.current_organization_id = p_organization_id

Line 383: FROM mtl_Serial_numbers

379: l_temp_buf VARCHAR2(10);
380: BEGIN
381: SELECT 'exists'
382: INTO l_temp_buf
383: FROM mtl_Serial_numbers
384: WHERE serial_number = p_serial_number
385: AND inventory_item_id = p_inventory_item_id
386: AND current_organization_id = p_organization_id;
387:

Line 525: INSERT INTO MTL_SERIAL_NUMBERS (

521:
522: IF(exist_Serial_number(p_serial_number,p_inventory_item_id,p_organization_id) = FALSE) THEN
523: print_Debug('Serial number doesnt exist in msn ');
524: --Insert into MSN in case the serial number doesn't exist there.
525: INSERT INTO MTL_SERIAL_NUMBERS (
526: inventory_item_id,
527: serial_number,
528: last_update_date,
529: last_updated_by,

Line 570: Remove the serial numbers from mtl_cc_Serial_numbers and unmark the serials in mtl_serial_numbers

566: NULL;
567: END insert_Serial_number;
568:
569: /*Bug # 3646068
570: Remove the serial numbers from mtl_cc_Serial_numbers and unmark the serials in mtl_serial_numbers
571: for serials that have been entered till now */
572: PROCEDURE remove_serial_number
573: (p_cycle_count_header_id IN NUMBER,
574: p_organization_id IN NUMBER ,

Line 624: --Unmark the serial number in mtl_Serial_numbers

620: print_debug('Exception while trying to delete from mtl_cc_serial_numbers for serial ' || l_serial_number);
621: END;
622: END IF;
623:
624: --Unmark the serial number in mtl_Serial_numbers
625: BEGIN
626:
627: UPDATE mtl_serial_numbers
628: SET group_mark_id = NULL

Line 627: UPDATE mtl_serial_numbers

623:
624: --Unmark the serial number in mtl_Serial_numbers
625: BEGIN
626:
627: UPDATE mtl_serial_numbers
628: SET group_mark_id = NULL
629: WHERE serial_number = l_serial_number
630: AND inventory_item_id = p_inventory_item_id
631: AND current_organization_id = p_organization_id;