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 519: update /+ ROWID / mtl_serial_numbers msn

515:
516: /* Bug 4911281: We have to clear the line_mark_id and lot_line_mark_id
517: along with group_mark_id */
518: -- Bug 6869089
519: update /*+ ROWID */ mtl_serial_numbers msn
520: set group_mark_id = NULL,
521: line_mark_id = NULL,
522: last_update_date = sysdate,
523: last_updated_by = fnd_global.user_id,

Line 527: from mtl_serial_numbers msn1 ,

523: last_updated_by = fnd_global.user_id,
524: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
525: lot_line_mark_id = NULL
526: where msn.ROWID in ( select msn1.ROWID
527: from mtl_serial_numbers msn1 ,
528: mtl_serial_numbers_interface msni
529: where msn1.inventory_item_id = l_rti_rec.item_id
530: and msni.product_code = 'RCV'
531: and msni.product_transaction_id = l_rti_rec.interface_transaction_id

Line 528: mtl_serial_numbers_interface msni

524: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
525: lot_line_mark_id = NULL
526: where msn.ROWID in ( select msn1.ROWID
527: from mtl_serial_numbers msn1 ,
528: mtl_serial_numbers_interface msni
529: where msn1.inventory_item_id = l_rti_rec.item_id
530: and msni.product_code = 'RCV'
531: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
532: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 537: update /+ ROWID / mtl_serial_numbers msn

533: and length(msn1.serial_number) = length(msni.fm_serial_number)
534: and length(msni.fm_serial_number) = length(nvl(msni.to_serial_number,msni.fm_serial_number)));
535:
536: --MSNI could have been moved to MSNT
537: update /*+ ROWID */ mtl_serial_numbers msn
538: set group_mark_id = NULL,
539: line_mark_id = NULL,
540: last_update_date = sysdate,
541: last_updated_by = fnd_global.user_id,

Line 545: from mtl_serial_numbers msn1 ,

541: last_updated_by = fnd_global.user_id,
542: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
543: lot_line_mark_id = NULL
544: where msn.ROWID in ( select msn1.ROWID
545: from mtl_serial_numbers msn1 ,
546: mtl_serial_numbers_temp msnt
547: where msn1.inventory_item_id = l_rti_rec.item_id
548: and msnt.product_code = 'RCV'
549: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id

Line 546: mtl_serial_numbers_temp msnt

542: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
543: lot_line_mark_id = NULL
544: where msn.ROWID in ( select msn1.ROWID
545: from mtl_serial_numbers msn1 ,
546: mtl_serial_numbers_temp msnt
547: where msn1.inventory_item_id = l_rti_rec.item_id
548: and msnt.product_code = 'RCV'
549: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
550: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 558: update /+ ROWID / mtl_serial_numbers msn

554:
555: else
556:
557:
558: update /*+ ROWID */ mtl_serial_numbers msn
559: set group_mark_id = NULL,
560: line_mark_id = NULL,
561: last_update_date = sysdate,
562: last_updated_by = fnd_global.user_id,

Line 565: from mtl_serial_numbers msn1 ,

561: last_update_date = sysdate,
562: last_updated_by = fnd_global.user_id,
563: lot_line_mark_id = NULL
564: where msn.ROWID in ( select msn1.ROWID
565: from mtl_serial_numbers msn1 ,
566: mtl_serial_numbers_interface msni
567: where msn1.inventory_item_id = l_rti_rec.item_id
568: and msni.product_code = 'RCV'
569: and msni.product_transaction_id = l_rti_rec.interface_transaction_id

Line 566: mtl_serial_numbers_interface msni

562: last_updated_by = fnd_global.user_id,
563: lot_line_mark_id = NULL
564: where msn.ROWID in ( select msn1.ROWID
565: from mtl_serial_numbers msn1 ,
566: mtl_serial_numbers_interface msni
567: where msn1.inventory_item_id = l_rti_rec.item_id
568: and msni.product_code = 'RCV'
569: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
570: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 575: update /+ ROWID / mtl_serial_numbers msn

571: and length(msn1.serial_number) = length(msni.fm_serial_number)
572: and length(msni.fm_serial_number) = length(nvl(msni.to_serial_number,msni.fm_serial_number)));
573:
574: --MSNI could have been moved to MSNT
575: update /*+ ROWID */ mtl_serial_numbers msn
576: set group_mark_id = NULL,
577: line_mark_id = NULL,
578: last_update_date = sysdate,
579: last_updated_by = fnd_global.user_id,

Line 582: from mtl_serial_numbers msn1 ,

578: last_update_date = sysdate,
579: last_updated_by = fnd_global.user_id,
580: lot_line_mark_id = NULL
581: where msn.ROWID in ( select msn1.ROWID
582: from mtl_serial_numbers msn1 ,
583: mtl_serial_numbers_temp msnt
584: where msn1.inventory_item_id = l_rti_rec.item_id
585: and msnt.product_code = 'RCV'
586: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id

Line 583: mtl_serial_numbers_temp msnt

579: last_updated_by = fnd_global.user_id,
580: lot_line_mark_id = NULL
581: where msn.ROWID in ( select msn1.ROWID
582: from mtl_serial_numbers msn1 ,
583: mtl_serial_numbers_temp msnt
584: where msn1.inventory_item_id = l_rti_rec.item_id
585: and msnt.product_code = 'RCV'
586: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
587: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 671: update /+ ROWID / mtl_serial_numbers msn

667:
668: /* Bug 4911281: We have to clear the line_mark_id and lot_line_mark_id
669: along with group_mark_id */
670: -- Bug 6869089
671: update /*+ ROWID */ mtl_serial_numbers msn
672: set group_mark_id = NULL,
673: line_mark_id = NULL,
674: last_update_date = sysdate,
675: last_updated_by = fnd_global.user_id,

Line 680: from mtl_serial_numbers msn1 ,

676: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
677: lot_line_mark_id = NULL
678:
679: where msn.ROWID in ( select msn1.ROWID
680: from mtl_serial_numbers msn1 ,
681: mtl_serial_numbers_interface msni
682: where msn1.inventory_item_id = l_rti_rec.item_id
683: and msni.product_code = 'RCV'
684: and msni.product_transaction_id = l_rti_rec.interface_transaction_id

Line 681: mtl_serial_numbers_interface msni

677: lot_line_mark_id = NULL
678:
679: where msn.ROWID in ( select msn1.ROWID
680: from mtl_serial_numbers msn1 ,
681: mtl_serial_numbers_interface msni
682: where msn1.inventory_item_id = l_rti_rec.item_id
683: and msni.product_code = 'RCV'
684: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
685: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 690: update /+ ROWID / mtl_serial_numbers msn

686: and length(msn1.serial_number) = length(msni.fm_serial_number)
687: and length(msni.fm_serial_number) = length(nvl(msni.to_serial_number,msni.fm_serial_number)));
688:
689: --MSNI could have been moved to MSNT
690: update /*+ ROWID */ mtl_serial_numbers msn
691: set group_mark_id = NULL,
692: line_mark_id = NULL,
693: last_update_date = sysdate,
694: last_updated_by = fnd_global.user_id,

Line 698: from mtl_serial_numbers msn1 ,

694: last_updated_by = fnd_global.user_id,
695: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
696: lot_line_mark_id = NULL
697: where msn.ROWID in ( select msn1.ROWID
698: from mtl_serial_numbers msn1 ,
699: mtl_serial_numbers_temp msnt
700: where msn1.inventory_item_id = l_rti_rec.item_id
701: and msnt.product_code = 'RCV'
702: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id

Line 699: mtl_serial_numbers_temp msnt

695: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
696: lot_line_mark_id = NULL
697: where msn.ROWID in ( select msn1.ROWID
698: from mtl_serial_numbers msn1 ,
699: mtl_serial_numbers_temp msnt
700: where msn1.inventory_item_id = l_rti_rec.item_id
701: and msnt.product_code = 'RCV'
702: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
703: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 715: update /+ ROWID / mtl_serial_numbers msn

711:
712: /* Bug 4911281: We have to clear the line_mark_id and lot_line_mark_id
713: along with group_mark_id */
714: -- Bug 6869089
715: update /*+ ROWID */ mtl_serial_numbers msn
716: set group_mark_id = NULL,
717: line_mark_id = NULL,
718: last_update_date = sysdate,
719: last_updated_by = fnd_global.user_id,

Line 722: from mtl_serial_numbers msn1 ,

718: last_update_date = sysdate,
719: last_updated_by = fnd_global.user_id,
720: lot_line_mark_id = NULL
721: where msn.ROWID in ( select msn1.ROWID
722: from mtl_serial_numbers msn1 ,
723: mtl_serial_numbers_interface msni
724: where msn1.inventory_item_id = l_rti_rec.item_id
725: and msni.product_code = 'RCV'
726: and msni.product_transaction_id = l_rti_rec.interface_transaction_id

Line 723: mtl_serial_numbers_interface msni

719: last_updated_by = fnd_global.user_id,
720: lot_line_mark_id = NULL
721: where msn.ROWID in ( select msn1.ROWID
722: from mtl_serial_numbers msn1 ,
723: mtl_serial_numbers_interface msni
724: where msn1.inventory_item_id = l_rti_rec.item_id
725: and msni.product_code = 'RCV'
726: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
727: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 732: update /+ ROWID / mtl_serial_numbers msn

728: and length(msn1.serial_number) = length(msni.fm_serial_number)
729: and length(msni.fm_serial_number) = length(nvl(msni.to_serial_number,msni.fm_serial_number)));
730:
731: --MSNI could have been moved to MSNT
732: update /*+ ROWID */ mtl_serial_numbers msn
733: set group_mark_id = NULL,
734: line_mark_id = NULL,
735: last_update_date = sysdate,
736: last_updated_by = fnd_global.user_id,

Line 739: from mtl_serial_numbers msn1 ,

735: last_update_date = sysdate,
736: last_updated_by = fnd_global.user_id,
737: lot_line_mark_id = NULL
738: where msn.ROWID in ( select msn1.ROWID
739: from mtl_serial_numbers msn1 ,
740: mtl_serial_numbers_temp msnt
741: where msn1.inventory_item_id = l_rti_rec.item_id
742: and msnt.product_code = 'RCV'
743: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id

Line 740: mtl_serial_numbers_temp msnt

736: last_updated_by = fnd_global.user_id,
737: lot_line_mark_id = NULL
738: where msn.ROWID in ( select msn1.ROWID
739: from mtl_serial_numbers msn1 ,
740: mtl_serial_numbers_temp msnt
741: where msn1.inventory_item_id = l_rti_rec.item_id
742: and msnt.product_code = 'RCV'
743: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
744: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 825: update /+ ROWID / mtl_serial_numbers msn

821:
822: /* Bug 4911281: We have to clear the line_mark_id and lot_line_mark_id
823: along with group_mark_id */
824: -- Bug 6869089
825: update /*+ ROWID */ mtl_serial_numbers msn
826: set group_mark_id = NULL,
827: line_mark_id = NULL,
828: last_update_date = sysdate,
829: last_updated_by = fnd_global.user_id,

Line 834: from mtl_serial_numbers msn1 ,

830: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
831: lot_line_mark_id = NULL
832:
833: where msn.ROWID in ( select msn1.ROWID
834: from mtl_serial_numbers msn1 ,
835: mtl_serial_numbers_interface msni
836: where msn1.inventory_item_id = l_rti_rec.item_id
837: and msni.product_code = 'RCV'
838: and msni.product_transaction_id = l_rti_rec.interface_transaction_id

Line 835: mtl_serial_numbers_interface msni

831: lot_line_mark_id = NULL
832:
833: where msn.ROWID in ( select msn1.ROWID
834: from mtl_serial_numbers msn1 ,
835: mtl_serial_numbers_interface msni
836: where msn1.inventory_item_id = l_rti_rec.item_id
837: and msni.product_code = 'RCV'
838: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
839: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 844: update /+ ROWID / mtl_serial_numbers msn

840: and length(msn1.serial_number) = length(msni.fm_serial_number)
841: and length(msni.fm_serial_number) = length(nvl(msni.to_serial_number,msni.fm_serial_number)));
842:
843: --MSNI could have been moved to MSNT
844: update /*+ ROWID */ mtl_serial_numbers msn
845: set group_mark_id = NULL,
846: line_mark_id = NULL,
847: last_update_date = sysdate,
848: last_updated_by = fnd_global.user_id,

Line 852: from mtl_serial_numbers msn1 ,

848: last_updated_by = fnd_global.user_id,
849: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
850: lot_line_mark_id = NULL
851: where msn.ROWID in ( select msn1.ROWID
852: from mtl_serial_numbers msn1 ,
853: mtl_serial_numbers_temp msnt
854: where msn1.inventory_item_id = l_rti_rec.item_id
855: and msnt.product_code = 'RCV'
856: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id

Line 853: mtl_serial_numbers_temp msnt

849: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
850: lot_line_mark_id = NULL
851: where msn.ROWID in ( select msn1.ROWID
852: from mtl_serial_numbers msn1 ,
853: mtl_serial_numbers_temp msnt
854: where msn1.inventory_item_id = l_rti_rec.item_id
855: and msnt.product_code = 'RCV'
856: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
857: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 869: update /+ ROWID / mtl_serial_numbers msn

865:
866: /* Bug 4911281: We have to clear the line_mark_id and lot_line_mark_id
867: along with group_mark_id */
868: -- Bug 6869089
869: update /*+ ROWID */ mtl_serial_numbers msn
870: set group_mark_id = NULL,
871: line_mark_id = NULL,
872: last_update_date = sysdate,
873: last_updated_by = fnd_global.user_id,

Line 876: from mtl_serial_numbers msn1 ,

872: last_update_date = sysdate,
873: last_updated_by = fnd_global.user_id,
874: lot_line_mark_id = NULL
875: where msn.ROWID in ( select msn1.ROWID
876: from mtl_serial_numbers msn1 ,
877: mtl_serial_numbers_interface msni
878: where msn1.inventory_item_id = l_rti_rec.item_id
879: and msni.product_code = 'RCV'
880: and msni.product_transaction_id = l_rti_rec.interface_transaction_id

Line 877: mtl_serial_numbers_interface msni

873: last_updated_by = fnd_global.user_id,
874: lot_line_mark_id = NULL
875: where msn.ROWID in ( select msn1.ROWID
876: from mtl_serial_numbers msn1 ,
877: mtl_serial_numbers_interface msni
878: where msn1.inventory_item_id = l_rti_rec.item_id
879: and msni.product_code = 'RCV'
880: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
881: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 886: update /+ ROWID / mtl_serial_numbers msn

882: and length(msn1.serial_number) = length(msni.fm_serial_number)
883: and length(msni.fm_serial_number) = length(nvl(msni.to_serial_number,msni.fm_serial_number)));
884:
885: --MSNI could have been moved to MSNT
886: update /*+ ROWID */ mtl_serial_numbers msn
887: set group_mark_id = NULL,
888: line_mark_id = NULL,
889: last_update_date = sysdate,
890: last_updated_by = fnd_global.user_id,

Line 893: from mtl_serial_numbers msn1 ,

889: last_update_date = sysdate,
890: last_updated_by = fnd_global.user_id,
891: lot_line_mark_id = NULL
892: where msn.ROWID in ( select msn1.ROWID
893: from mtl_serial_numbers msn1 ,
894: mtl_serial_numbers_temp msnt
895: where msn1.inventory_item_id = l_rti_rec.item_id
896: and msnt.product_code = 'RCV'
897: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id

Line 894: mtl_serial_numbers_temp msnt

890: last_updated_by = fnd_global.user_id,
891: lot_line_mark_id = NULL
892: where msn.ROWID in ( select msn1.ROWID
893: from mtl_serial_numbers msn1 ,
894: mtl_serial_numbers_temp msnt
895: where msn1.inventory_item_id = l_rti_rec.item_id
896: and msnt.product_code = 'RCV'
897: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
898: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 981: update /+ ROWID / mtl_serial_numbers msn

977:
978: /* Bug 4911281: We have to clear the line_mark_id and lot_line_mark_id
979: along with group_mark_id */
980: -- Bug 6869089
981: update /*+ ROWID */ mtl_serial_numbers msn
982: set group_mark_id = NULL,
983: line_mark_id = NULL,
984: last_update_date = sysdate,
985: last_updated_by = fnd_global.user_id,

Line 989: from mtl_serial_numbers msn1 ,

985: last_updated_by = fnd_global.user_id,
986: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
987: lot_line_mark_id = NULL
988: where msn.ROWID in ( select msn1.ROWID
989: from mtl_serial_numbers msn1 ,
990: mtl_serial_numbers_interface msni
991: where msn1.inventory_item_id = l_rti_rec.item_id
992: and msni.product_code = 'RCV'
993: and msni.product_transaction_id = l_rti_rec.interface_transaction_id

Line 990: mtl_serial_numbers_interface msni

986: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
987: lot_line_mark_id = NULL
988: where msn.ROWID in ( select msn1.ROWID
989: from mtl_serial_numbers msn1 ,
990: mtl_serial_numbers_interface msni
991: where msn1.inventory_item_id = l_rti_rec.item_id
992: and msni.product_code = 'RCV'
993: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
994: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 999: update /+ ROWID / mtl_serial_numbers msn

995: and length(msn1.serial_number) = length(msni.fm_serial_number)
996: and length(msni.fm_serial_number) = length(nvl(msni.to_serial_number,msni.fm_serial_number)));
997:
998: --MSNI could have been moved to MSNT
999: update /*+ ROWID */ mtl_serial_numbers msn
1000: set group_mark_id = NULL,
1001: line_mark_id = NULL,
1002: last_update_date = sysdate,
1003: last_updated_by = fnd_global.user_id,

Line 1007: from mtl_serial_numbers msn1 ,

1003: last_updated_by = fnd_global.user_id,
1004: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
1005: lot_line_mark_id = NULL
1006: where msn.ROWID in ( select msn1.ROWID
1007: from mtl_serial_numbers msn1 ,
1008: mtl_serial_numbers_temp msnt
1009: where msn1.inventory_item_id = l_rti_rec.item_id
1010: and msnt.product_code = 'RCV'
1011: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id

Line 1008: mtl_serial_numbers_temp msnt

1004: current_status = (CASE WHEN Nvl(previous_status,-1) < 0 THEN current_status ELSE previous_status END),
1005: lot_line_mark_id = NULL
1006: where msn.ROWID in ( select msn1.ROWID
1007: from mtl_serial_numbers msn1 ,
1008: mtl_serial_numbers_temp msnt
1009: where msn1.inventory_item_id = l_rti_rec.item_id
1010: and msnt.product_code = 'RCV'
1011: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
1012: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 1024: update /+ ROWID / mtl_serial_numbers msn

1020:
1021: /* Bug 4911281: We have to clear the line_mark_id and lot_line_mark_id
1022: along with group_mark_id */
1023: -- Bug 6869089
1024: update /*+ ROWID */ mtl_serial_numbers msn
1025: set group_mark_id = NULL,
1026: line_mark_id = NULL,
1027: last_update_date = sysdate,
1028: last_updated_by = fnd_global.user_id,

Line 1031: from mtl_serial_numbers msn1 ,

1027: last_update_date = sysdate,
1028: last_updated_by = fnd_global.user_id,
1029: lot_line_mark_id = NULL
1030: where msn.ROWID in ( select msn1.ROWID
1031: from mtl_serial_numbers msn1 ,
1032: mtl_serial_numbers_interface msni
1033: where msn1.inventory_item_id = l_rti_rec.item_id
1034: and msni.product_code = 'RCV'
1035: and msni.product_transaction_id = l_rti_rec.interface_transaction_id

Line 1032: mtl_serial_numbers_interface msni

1028: last_updated_by = fnd_global.user_id,
1029: lot_line_mark_id = NULL
1030: where msn.ROWID in ( select msn1.ROWID
1031: from mtl_serial_numbers msn1 ,
1032: mtl_serial_numbers_interface msni
1033: where msn1.inventory_item_id = l_rti_rec.item_id
1034: and msni.product_code = 'RCV'
1035: and msni.product_transaction_id = l_rti_rec.interface_transaction_id
1036: and msn1.serial_number between msni.fm_serial_number and msni.to_serial_number

Line 1041: update /+ ROWID / mtl_serial_numbers msn

1037: and length(msn1.serial_number) = length(msni.fm_serial_number)
1038: and length(msni.fm_serial_number) = length(nvl(msni.to_serial_number,msni.fm_serial_number)));
1039:
1040: --MSNI could have been moved to MSNT
1041: update /*+ ROWID */ mtl_serial_numbers msn
1042: set group_mark_id = NULL,
1043: line_mark_id = NULL,
1044: last_update_date = sysdate,
1045: last_updated_by = fnd_global.user_id,

Line 1048: from mtl_serial_numbers msn1 ,

1044: last_update_date = sysdate,
1045: last_updated_by = fnd_global.user_id,
1046: lot_line_mark_id = NULL
1047: where msn.ROWID in ( select msn1.ROWID
1048: from mtl_serial_numbers msn1 ,
1049: mtl_serial_numbers_temp msnt
1050: where msn1.inventory_item_id = l_rti_rec.item_id
1051: and msnt.product_code = 'RCV'
1052: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id

Line 1049: mtl_serial_numbers_temp msnt

1045: last_updated_by = fnd_global.user_id,
1046: lot_line_mark_id = NULL
1047: where msn.ROWID in ( select msn1.ROWID
1048: from mtl_serial_numbers msn1 ,
1049: mtl_serial_numbers_temp msnt
1050: where msn1.inventory_item_id = l_rti_rec.item_id
1051: and msnt.product_code = 'RCV'
1052: and msnt.product_transaction_id = l_rti_rec.interface_transaction_id
1053: and msn1.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 1079: DELETE FROM mtl_serial_numbers_interface

1075: DELETE FROM mtl_transaction_lots_temp
1076: WHERE product_code = 'RCV'
1077: AND product_transaction_id = l_rti_rec.interface_transaction_id;
1078:
1079: DELETE FROM mtl_serial_numbers_interface
1080: WHERE product_code = 'RCV'
1081: AND product_transaction_id = l_rti_rec.interface_transaction_id;
1082:
1083: DELETE FROM mtl_serial_numbers_temp

Line 1083: DELETE FROM mtl_serial_numbers_temp

1079: DELETE FROM mtl_serial_numbers_interface
1080: WHERE product_code = 'RCV'
1081: AND product_transaction_id = l_rti_rec.interface_transaction_id;
1082:
1083: DELETE FROM mtl_serial_numbers_temp
1084: WHERE product_code = 'RCV'
1085: AND product_transaction_id = l_rti_rec.interface_transaction_id;
1086:
1087: IF (l_prev_lpn_group_id <> l_rti_rec.lpn_group_id) THEN

Line 1350: UPDATE mtl_serial_numbers

1346: END IF;
1347: END;
1348:
1349: BEGIN
1350: UPDATE mtl_serial_numbers
1351: SET lpn_txn_error_flag = 'Y'
1352: WHERE ROWID IN (SELECT msn.ROWID
1353: FROM mtl_serial_numbers msn
1354: , rcv_transactions_interface rti

Line 1353: FROM mtl_serial_numbers msn

1349: BEGIN
1350: UPDATE mtl_serial_numbers
1351: SET lpn_txn_error_flag = 'Y'
1352: WHERE ROWID IN (SELECT msn.ROWID
1353: FROM mtl_serial_numbers msn
1354: , rcv_transactions_interface rti
1355: WHERE msn.last_txn_source_id = p_group_id
1356: AND rti.group_id = p_group_id
1357: AND rti.item_id = msn.inventory_item_id);

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

1360: WHEN no_data_found THEN
1361: NULL;
1362: WHEN OTHERS THEN
1363: IF (l_debug = 1) THEN
1364: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - Exception while updating mtl_serial_numbers to error : 210',4);
1365: END IF;
1366: END;
1367:
1368: ELSIF l_transaction_type = 'RECEIVE' THEN

Line 1382: -- Delete/Clear mtl_serial_numbers_temp rows

1378: print_debug('rcv_txn_clean_up - Finished clean up : 221',4);
1379: END IF;
1380:
1381:
1382: -- Delete/Clear mtl_serial_numbers_temp rows
1383: -- Delete/Clear mtl_transaction_lots_temp rows
1384: -- If the Transaction Fails
1385:
1386: IF (l_debug = 1) THEN

Line 1391: delete from mtl_serial_numbers_temp msnt

1387: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - cleanup msnt 1',4);
1388: END IF;
1389:
1390:
1391: delete from mtl_serial_numbers_temp msnt
1392: where msnt.transaction_temp_id in
1393: ( select interface_transaction_id
1394: from rcv_transactions_interface
1395: where group_id = p_group_id )

Line 1402: delete from mtl_serial_numbers_temp msnt

1398: IF (l_debug = 1) THEN
1399: print_debug('TXN_MOBILE_TIMEOUT_CLEANUP - cleanup msnt 2',4);
1400: END IF;
1401:
1402: delete from mtl_serial_numbers_temp msnt
1403: where msnt.transaction_temp_id in
1404: ( select mtlt.serial_transaction_temp_id
1405: from mtl_transaction_lots_temp mtlt
1406: where mtlt.transaction_temp_id in (