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_CC_SERIAL_NUMBERS

Line 40: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

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

Line 97: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

93: msn.lot_number,
94: 0,
95: msn.current_status,
96: mms.status_code
97: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
98: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
99: WHERE msn.inventory_item_id = p_inventory_item_id
100: AND msn.group_mark_id = 1
101: AND msn.current_organization_id = p_organization_id

Line 153: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

149: WHERE inventory_item_id = p_inventory_item_id
150: AND current_organization_id = p_organization_id
151: AND serial_number IN
152: (SELECT UNIQUE msn.serial_number
153: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
154: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
155: WHERE msn.inventory_item_id = p_inventory_item_id
156: AND msn.current_organization_id = p_organization_id
157: AND msn.current_status IN (1, 3)

Line 219: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

215: WHERE inventory_item_id = p_inventory_item_id
216: AND current_organization_id = p_organization_id
217: AND serial_number IN
218: (SELECT UNIQUE msn.serial_number
219: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
220: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
221: WHERE msn.inventory_item_id = p_inventory_item_id
222: AND msn.current_organization_id = p_organization_id
223: AND msn.current_status IN (1, 3, 4) -- For bug 14144558, added 4 in the list and commented below check

Line 306: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

302: WHERE inventory_item_id = p_inventory_item_id
303: AND current_organization_id = p_organization_id
304: AND serial_number IN
305: (SELECT UNIQUE msn.serial_number
306: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
307: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
308: WHERE msn.inventory_item_id = p_inventory_item_id
309: AND msn.current_organization_id = p_organization_id
310: AND msn.current_status IN (1, 3, 4) -- For bug 14144558, added 4 in the list

Line 378: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

374: WHERE inventory_item_id = p_inventory_item_id
375: AND current_organization_id = p_organization_id
376: AND serial_number IN
377: (SELECT UNIQUE msn.serial_number
378: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
379: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
380: WHERE msn.inventory_item_id = p_inventory_item_id
381: AND msn.current_organization_id = p_organization_id
382: AND msn.current_status IN (1, 3)

Line 442: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

438: WHERE inventory_item_id = p_inventory_item_id
439: AND current_organization_id = p_organization_id
440: AND serial_number IN
441: (SELECT UNIQUE msn.serial_number
442: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
443: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
444: WHERE msn.inventory_item_id = p_inventory_item_id
445: AND msn.current_organization_id = p_organization_id
446: AND msn.current_status IN (1, 3)

Line 497: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,

493:
494: BEGIN
495: SELECT COUNT(*)
496: INTO x_number
497: FROM mtl_serial_numbers msn, mtl_cc_serial_numbers mcsn,
498: mtl_material_statuses_vl mms, mtl_cycle_count_entries mcce
499: WHERE msn.inventory_item_id = p_inventory_item_id
500: AND msn.group_mark_id = 1
501: AND msn.current_organization_id = p_organization_id

Line 551: /* Inserts the serial number into mtl_cc_Serial_numbers if its new, else updates the same */

547:
548: END exist_Serial_number;
549:
550: /* Bug# 3595723 */
551: /* Inserts the serial number into mtl_cc_Serial_numbers if its new, else updates the same */
552: PROCEDURE insert_serial_number
553: (p_serial_number IN VARCHAR2 ,
554: p_cycle_count_header_id IN NUMBER,
555: p_organization_id IN NUMBER ,

Line 689: FROM mtl_cc_serial_numbers

685:
686: /* Check if the serial number already exists */
687: SELECT number_of_counts, unit_status_current, unit_status_first
688: INTO l_number_of_counts, l_unit_status_prior, l_unit_status_first
689: FROM mtl_cc_serial_numbers
690: WHERE cycle_count_entry_id = l_cycle_count_entry_id
691: AND serial_number = p_serial_number;
692:
693: print_debug('serial number ' || p_serial_number || ' already exists in mtl_cc_serial_numbers');

Line 693: print_debug('serial number ' || p_serial_number || ' already exists in mtl_cc_serial_numbers');

689: FROM mtl_cc_serial_numbers
690: WHERE cycle_count_entry_id = l_cycle_count_entry_id
691: AND serial_number = p_serial_number;
692:
693: print_debug('serial number ' || p_serial_number || ' already exists in mtl_cc_serial_numbers');
694: print_debug('l_number_of_counts ' || l_number_of_counts);
695: print_debug('l_unit_status_prior ' || l_unit_status_prior);
696: print_debug('l_unit_status_first ' || l_unit_status_first);
697:

Line 708: UPDATE MTL_CC_SERIAL_NUMBERS

704: l_pos_adjustment_qty := 0; -- 1 -> New serial number found at the location
705: END IF;
706: l_neg_adjustment_qty := 0; -- 1 -> Serial number not found at the location
707:
708: UPDATE MTL_CC_SERIAL_NUMBERS
709: SET
710: last_update_date = SYSDATE,
711: last_updated_by = fnd_global.user_id,
712: last_update_login = fnd_global.login_id,

Line 735: INSERT INTO MTL_CC_SERIAL_NUMBERS(

731: l_neg_adjustment_qty := NULL;
732:
733: print_debug('could not find serial number ' || p_serial_number);
734:
735: INSERT INTO MTL_CC_SERIAL_NUMBERS(
736: cycle_count_entry_id,
737: serial_number,
738: last_update_date,
739: last_updated_by,

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

953: NULL;
954: END insert_Serial_number;
955:
956: /*Bug # 3646068
957: Remove the serial numbers from mtl_cc_Serial_numbers and unmark the serials in mtl_serial_numbers
958: for serials that have been entered till now */
959: PROCEDURE remove_serial_number
960: (p_cycle_count_header_id IN NUMBER,
961: p_organization_id IN NUMBER ,

Line 976: FROM mtl_cc_Serial_numbers

972:
973: CURSOR serial_cur IS
974: SELECT serial_number,
975: pos_adjustment_qty
976: FROM mtl_cc_Serial_numbers
977: WHERE cycle_count_entry_id = l_cycle_count_entry_id;
978:
979: BEGIN
980:

Line 1000: --This was inserted as part of call to insert_serial_number, Delete from mtl_cc_Serial_numbers

996: LOOP
997: FETCH serial_cur INTO l_serial_number, l_pos_adjustment_qty;
998: EXIT WHEN serial_cur%NOTFOUND;
999: IF(nvl(l_pos_adjustment_qty,0) = 1) THEN
1000: --This was inserted as part of call to insert_serial_number, Delete from mtl_cc_Serial_numbers
1001: BEGIN
1002: DELETE FROM mtl_cc_serial_numbers
1003: WHERE cycle_count_entry_id = l_cycle_count_entry_id
1004: AND serial_number = l_serial_number;

Line 1002: DELETE FROM mtl_cc_serial_numbers

998: EXIT WHEN serial_cur%NOTFOUND;
999: IF(nvl(l_pos_adjustment_qty,0) = 1) THEN
1000: --This was inserted as part of call to insert_serial_number, Delete from mtl_cc_Serial_numbers
1001: BEGIN
1002: DELETE FROM mtl_cc_serial_numbers
1003: WHERE cycle_count_entry_id = l_cycle_count_entry_id
1004: AND serial_number = l_serial_number;
1005: EXCEPTION
1006: WHEN OTHERS THEN

Line 1007: print_debug('Exception while trying to delete from mtl_cc_serial_numbers for serial ' || l_serial_number);

1003: WHERE cycle_count_entry_id = l_cycle_count_entry_id
1004: AND serial_number = l_serial_number;
1005: EXCEPTION
1006: WHEN OTHERS THEN
1007: print_debug('Exception while trying to delete from mtl_cc_serial_numbers for serial ' || l_serial_number);
1008: END;
1009: END IF;
1010:
1011: --Unmark the serial number in mtl_Serial_numbers