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_RECEIVING_TRANSACTION dependencies on MTL_SERIAL_NUMBERS

Line 182: UPDATE mtl_serial_numbers

178: UPDATE wms_lpn_contents
179: SET organization_id = l_organization_id
180: WHERE parent_lpn_id = l_lpn_id;
181:
182: UPDATE mtl_serial_numbers
183: SET current_organization_id = l_organization_id,
184: group_mark_id = null,
185: current_subinventory_code = null,
186: current_locator_id = null

Line 272: UPDATE mtl_serial_numbers

268: IF (l_debug = 1) THEN
269: print_debug('rcv_txn_clean_up - Case for Serial ASNEXP cleanup ',1);
270: END IF;
271:
272: UPDATE mtl_serial_numbers
273: SET current_status = Nvl(previous_status, current_status)
274: , group_mark_id = -1
275: , previous_status = NULL
276: WHERE inventory_item_id = l_inventory_item_id

Line 295: DELETE mtl_serial_numbers

291: WHERE inventory_item_id = l_inventory_item_id
292: AND organization_id = l_from_organization_id;
293: ELSE
294: -- delete if it is a newly created dynamic serial
295: DELETE mtl_serial_numbers
296: WHERE inventory_item_id = l_inventory_item_id
297: AND serial_number = l_serial_number
298: AND current_organization_id = l_organization_id
299: AND previous_status IS NULL;

Line 304: UPDATE mtl_serial_numbers

300: END IF;
301:
302: l_progress := '60';
303: -- revert its previous status otherwise
304: UPDATE mtl_serial_numbers
305: SET current_status = Nvl(previous_status, current_status)
306: , group_mark_id = -1 -- This line and next line for Bug#2368323
307: , current_organization_id = Decode(previous_status, NULL,
308: Decode(l_serial_control_at_from_org,

Line 507: update /+ ROWID / mtl_serial_numbers msn

503: END IF;
504: /* Bug 4911281: We have to clear the line_mark_id and lot_line_mark_id
505: along with group_mark_id */
506: -- Bug 6869089
507: update /*+ ROWID */ mtl_serial_numbers msn
508: set group_mark_id = NULL,
509: line_mark_id = NULL,
510: lot_line_mark_id = NULL
511: where msn.ROWID in ( select msn1.ROWID

Line 512: from mtl_serial_numbers msn1 ,

508: set group_mark_id = NULL,
509: line_mark_id = NULL,
510: lot_line_mark_id = NULL
511: where msn.ROWID in ( select msn1.ROWID
512: from mtl_serial_numbers msn1 ,
513: mtl_serial_numbers_interface msni
514: where msn1.inventory_item_id = l_rti_rec.item_id
515: and msni.product_code = 'RCV'
516: and msni.product_transaction_id = l_rti_rec.interface_transaction_id

Line 513: mtl_serial_numbers_interface msni

509: line_mark_id = NULL,
510: lot_line_mark_id = NULL
511: where msn.ROWID in ( select msn1.ROWID
512: from mtl_serial_numbers msn1 ,
513: mtl_serial_numbers_interface msni
514: where msn1.inventory_item_id = l_rti_rec.item_id
515: and msni.product_code = 'RCV'
516: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
517: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 522: update /+ ROWID / mtl_serial_numbers msn

518: and length(msn1.serial_number) = length(msni.fm_serial_number)
519: and length(msni.fm_serial_number) = length(nvl(msni.to_serial_number,msni.fm_serial_number)));
520:
521: --MSNI could have been moved to MSNT
522: update /*+ ROWID */ mtl_serial_numbers msn
523: set group_mark_id = NULL,
524: line_mark_id = NULL,
525: lot_line_mark_id = NULL
526: where msn.ROWID in ( select msn1.ROWID

Line 527: from mtl_serial_numbers msn1 ,

523: set group_mark_id = NULL,
524: line_mark_id = NULL,
525: lot_line_mark_id = NULL
526: where msn.ROWID in ( select msn1.ROWID
527: from mtl_serial_numbers msn1 ,
528: mtl_serial_numbers_temp msnt
529: where msn1.inventory_item_id = l_rti_rec.item_id
530: and msnt.product_code = 'RCV'
531: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id

Line 528: mtl_serial_numbers_temp msnt

524: line_mark_id = NULL,
525: lot_line_mark_id = NULL
526: where msn.ROWID in ( select msn1.ROWID
527: from mtl_serial_numbers msn1 ,
528: mtl_serial_numbers_temp msnt
529: where msn1.inventory_item_id = l_rti_rec.item_id
530: and msnt.product_code = 'RCV'
531: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
532: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 601: update /+ ROWID / mtl_serial_numbers msn

597:
598: /* Bug 4911281: We have to clear the line_mark_id and lot_line_mark_id
599: along with group_mark_id */
600: -- Bug 6869089
601: update /*+ ROWID */ mtl_serial_numbers msn
602: set group_mark_id = NULL,
603: line_mark_id = NULL,
604: lot_line_mark_id = NULL
605: where msn.ROWID in ( select msn1.ROWID

Line 606: from mtl_serial_numbers msn1 ,

602: set group_mark_id = NULL,
603: line_mark_id = NULL,
604: lot_line_mark_id = NULL
605: where msn.ROWID in ( select msn1.ROWID
606: from mtl_serial_numbers msn1 ,
607: mtl_serial_numbers_interface msni
608: where msn1.inventory_item_id = l_rti_rec.item_id
609: and msni.product_code = 'RCV'
610: and msni.product_transaction_id = l_rti_rec.interface_transaction_id

Line 607: mtl_serial_numbers_interface msni

603: line_mark_id = NULL,
604: lot_line_mark_id = NULL
605: where msn.ROWID in ( select msn1.ROWID
606: from mtl_serial_numbers msn1 ,
607: mtl_serial_numbers_interface msni
608: where msn1.inventory_item_id = l_rti_rec.item_id
609: and msni.product_code = 'RCV'
610: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
611: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 616: update /+ ROWID / mtl_serial_numbers msn

612: and length(msn1.serial_number) = length(msni.fm_serial_number)
613: and length(msni.fm_serial_number) = length(nvl(msni.to_serial_number,msni.fm_serial_number)));
614:
615: --MSNI could have been moved to MSNT
616: update /*+ ROWID */ mtl_serial_numbers msn
617: set group_mark_id = NULL,
618: line_mark_id = NULL,
619: lot_line_mark_id = NULL
620: where msn.ROWID in ( select msn1.ROWID

Line 621: from mtl_serial_numbers msn1 ,

617: set group_mark_id = NULL,
618: line_mark_id = NULL,
619: lot_line_mark_id = NULL
620: where msn.ROWID in ( select msn1.ROWID
621: from mtl_serial_numbers msn1 ,
622: mtl_serial_numbers_temp msnt
623: where msn1.inventory_item_id = l_rti_rec.item_id
624: and msnt.product_code = 'RCV'
625: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id

Line 622: mtl_serial_numbers_temp msnt

618: line_mark_id = NULL,
619: lot_line_mark_id = NULL
620: where msn.ROWID in ( select msn1.ROWID
621: from mtl_serial_numbers msn1 ,
622: mtl_serial_numbers_temp msnt
623: where msn1.inventory_item_id = l_rti_rec.item_id
624: and msnt.product_code = 'RCV'
625: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
626: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 694: update /+ ROWID / mtl_serial_numbers msn

690: END IF;
691: /* Bug 4911281: We have to clear the line_mark_id and lot_line_mark_id
692: along with group_mark_id */
693: -- Bug 6869089
694: update /*+ ROWID */ mtl_serial_numbers msn
695: set group_mark_id = NULL,
696: line_mark_id = NULL,
697: lot_line_mark_id = NULL
698: where msn.ROWID in ( select msn1.ROWID

Line 699: from mtl_serial_numbers msn1 ,

695: set group_mark_id = NULL,
696: line_mark_id = NULL,
697: lot_line_mark_id = NULL
698: where msn.ROWID in ( select msn1.ROWID
699: from mtl_serial_numbers msn1 ,
700: mtl_serial_numbers_interface msni
701: where msn1.inventory_item_id = l_rti_rec.item_id
702: and msni.product_code = 'RCV'
703: and msni.product_transaction_id = l_rti_rec.interface_transaction_id

Line 700: mtl_serial_numbers_interface msni

696: line_mark_id = NULL,
697: lot_line_mark_id = NULL
698: where msn.ROWID in ( select msn1.ROWID
699: from mtl_serial_numbers msn1 ,
700: mtl_serial_numbers_interface msni
701: where msn1.inventory_item_id = l_rti_rec.item_id
702: and msni.product_code = 'RCV'
703: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
704: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 709: update /+ ROWID / mtl_serial_numbers msn

705: and length(msn1.serial_number) = length(msni.fm_serial_number)
706: and length(msni.fm_serial_number) = length(nvl(msni.to_serial_number,msni.fm_serial_number)));
707:
708: -- MSNI could have been moved to MSNT
709: update /*+ ROWID */ mtl_serial_numbers msn
710: set group_mark_id = NULL,
711: line_mark_id = NULL,
712: lot_line_mark_id = NULL
713: where msn.ROWID in ( select msn1.ROWID

Line 714: from mtl_serial_numbers msn1 ,

710: set group_mark_id = NULL,
711: line_mark_id = NULL,
712: lot_line_mark_id = NULL
713: where msn.ROWID in ( select msn1.ROWID
714: from mtl_serial_numbers msn1 ,
715: mtl_serial_numbers_temp msnt
716: where msn1.inventory_item_id = l_rti_rec.item_id
717: and msnt.product_code = 'RCV'
718: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id

Line 715: mtl_serial_numbers_temp msnt

711: line_mark_id = NULL,
712: lot_line_mark_id = NULL
713: where msn.ROWID in ( select msn1.ROWID
714: from mtl_serial_numbers msn1 ,
715: mtl_serial_numbers_temp msnt
716: where msn1.inventory_item_id = l_rti_rec.item_id
717: and msnt.product_code = 'RCV'
718: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
719: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 789: update /+ ROWID / mtl_serial_numbers msn

785: END IF;
786: /* Bug 4911281: We have to clear the line_mark_id and lot_line_mark_id
787: along with group_mark_id */
788: -- Bug 6869089
789: update /*+ ROWID */ mtl_serial_numbers msn
790: set group_mark_id = NULL,
791: line_mark_id = NULL,
792: lot_line_mark_id = NULL
793: where msn.ROWID in ( select msn1.ROWID

Line 794: from mtl_serial_numbers msn1 ,

790: set group_mark_id = NULL,
791: line_mark_id = NULL,
792: lot_line_mark_id = NULL
793: where msn.ROWID in ( select msn1.ROWID
794: from mtl_serial_numbers msn1 ,
795: mtl_serial_numbers_interface msni
796: where msn1.inventory_item_id = l_rti_rec.item_id
797: and msni.product_code = 'RCV'
798: and msni.product_transaction_id = l_rti_rec.interface_transaction_id

Line 795: mtl_serial_numbers_interface msni

791: line_mark_id = NULL,
792: lot_line_mark_id = NULL
793: where msn.ROWID in ( select msn1.ROWID
794: from mtl_serial_numbers msn1 ,
795: mtl_serial_numbers_interface msni
796: where msn1.inventory_item_id = l_rti_rec.item_id
797: and msni.product_code = 'RCV'
798: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
799: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 804: update /+ ROWID / mtl_serial_numbers msn

800: and length(msn1.serial_number) = length(msni.fm_serial_number)
801: and length(msni.fm_serial_number) = length(nvl(msni.to_serial_number,msni.fm_serial_number)));
802:
803: -- MSNI could have been moved to MSNT
804: update /*+ ROWID */ mtl_serial_numbers msn
805: set group_mark_id = NULL,
806: line_mark_id = NULL,
807: lot_line_mark_id = NULL
808: where msn.ROWID in ( select msn1.ROWID

Line 809: from mtl_serial_numbers msn1 ,

805: set group_mark_id = NULL,
806: line_mark_id = NULL,
807: lot_line_mark_id = NULL
808: where msn.ROWID in ( select msn1.ROWID
809: from mtl_serial_numbers msn1 ,
810: mtl_serial_numbers_temp msnt
811: where msn1.inventory_item_id = l_rti_rec.item_id
812: and msnt.product_code = 'RCV'
813: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id

Line 810: mtl_serial_numbers_temp msnt

806: line_mark_id = NULL,
807: lot_line_mark_id = NULL
808: where msn.ROWID in ( select msn1.ROWID
809: from mtl_serial_numbers msn1 ,
810: mtl_serial_numbers_temp msnt
811: where msn1.inventory_item_id = l_rti_rec.item_id
812: and msnt.product_code = 'RCV'
813: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
814: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 837: DELETE FROM mtl_serial_numbers_interface

833: DELETE FROM mtl_transaction_lots_temp
834: WHERE product_code = 'RCV'
835: AND product_transaction_id = l_rti_rec.interface_transaction_id;
836:
837: DELETE FROM mtl_serial_numbers_interface
838: WHERE product_code = 'RCV'
839: AND product_transaction_id = l_rti_rec.interface_transaction_id;
840:
841: DELETE FROM mtl_serial_numbers_temp

Line 841: DELETE FROM mtl_serial_numbers_temp

837: DELETE FROM mtl_serial_numbers_interface
838: WHERE product_code = 'RCV'
839: AND product_transaction_id = l_rti_rec.interface_transaction_id;
840:
841: DELETE FROM mtl_serial_numbers_temp
842: WHERE product_code = 'RCV'
843: AND product_transaction_id = l_rti_rec.interface_transaction_id;
844:
845: IF (l_prev_lpn_group_id <> l_rti_rec.lpn_group_id) THEN

Line 1108: UPDATE mtl_serial_numbers

1104: END IF;
1105: END;
1106:
1107: BEGIN
1108: UPDATE mtl_serial_numbers
1109: SET lpn_txn_error_flag = 'Y'
1110: WHERE ROWID IN (SELECT msn.ROWID
1111: FROM mtl_serial_numbers msn
1112: , rcv_transactions_interface rti

Line 1111: FROM mtl_serial_numbers msn

1107: BEGIN
1108: UPDATE mtl_serial_numbers
1109: SET lpn_txn_error_flag = 'Y'
1110: WHERE ROWID IN (SELECT msn.ROWID
1111: FROM mtl_serial_numbers msn
1112: , rcv_transactions_interface rti
1113: WHERE msn.last_txn_source_id = p_group_id
1114: AND rti.group_id = p_group_id
1115: AND rti.item_id = msn.inventory_item_id);

Line 1122: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Exception while updating mtl_serial_numbers to error : 210',4);

1118: WHEN no_data_found THEN
1119: NULL;
1120: WHEN OTHERS THEN
1121: IF (l_debug = 1) THEN
1122: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Exception while updating mtl_serial_numbers to error : 210',4);
1123: END IF;
1124: END;
1125:
1126: ELSIF l_transaction_type = 'RECEIVE' THEN

Line 1140: -- Delete/Clear mtl_serial_numbers_temp rows

1136: print_debug('rcv_txn_clean_up - Finished clean up : 221',4);
1137: END IF;
1138:
1139:
1140: -- Delete/Clear mtl_serial_numbers_temp rows
1141: -- Delete/Clear mtl_transaction_lots_temp rows
1142: -- If the Transaction Fails
1143:
1144: IF (l_debug = 1) THEN

Line 1149: delete from mtl_serial_numbers_temp msnt

1145: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - cleanup msnt 1',4);
1146: END IF;
1147:
1148:
1149: delete from mtl_serial_numbers_temp msnt
1150: where msnt.transaction_temp_id in
1151: ( select interface_transaction_id
1152: from rcv_transactions_interface
1153: where group_id = p_group_id )

Line 1160: delete from mtl_serial_numbers_temp msnt

1156: IF (l_debug = 1) THEN
1157: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - cleanup msnt 2',4);
1158: END IF;
1159:
1160: delete from mtl_serial_numbers_temp msnt
1161: where msnt.transaction_temp_id in
1162: ( select mtlt.serial_transaction_temp_id
1163: from mtl_transaction_lots_temp mtlt
1164: where mtlt.transaction_temp_id in (