DBA Data[Home] [Help]

APPS.INV_RECEIVING_TRANSACTION dependencies on FND_GLOBAL

Line 523: last_updated_by = fnd_global.user_id,

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,
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 ,

Line 541: last_updated_by = fnd_global.user_id,

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,
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 ,

Line 562: last_updated_by = fnd_global.user_id,

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,
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

Line 579: last_updated_by = fnd_global.user_id,

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,
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

Line 675: last_updated_by = fnd_global.user_id,

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,
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

Line 694: last_updated_by = fnd_global.user_id,

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,
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 ,

Line 719: last_updated_by = fnd_global.user_id,

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,
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

Line 736: last_updated_by = fnd_global.user_id,

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,
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

Line 829: last_updated_by = fnd_global.user_id,

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,
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

Line 848: last_updated_by = fnd_global.user_id,

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,
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 ,

Line 873: last_updated_by = fnd_global.user_id,

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,
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

Line 890: last_updated_by = fnd_global.user_id,

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,
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

Line 985: last_updated_by = fnd_global.user_id,

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,
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 ,

Line 1003: last_updated_by = fnd_global.user_id,

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,
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 ,

Line 1028: last_updated_by = fnd_global.user_id,

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,
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

Line 1045: last_updated_by = fnd_global.user_id,

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,
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