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.BOM_COPY_ROUTING dependencies on BOM_OPERATION_SEQUENCES

Line 53: FROM bom_operation_sequences

49: sql_stmt_num := 1;
50:
51: SELECT COUNT (*)
52: INTO total_opseqs
53: FROM bom_operation_sequences
54: WHERE routing_sequence_id = from_rtg_seq_id
55: AND NVL (eco_for_production, 2) = 2
56: AND (display_option = 1
57: OR (display_option = 2

Line 74: FROM bom_operation_sequences a,

70: sql_stmt_num := 2;
71:
72: SELECT COUNT (*)
73: INTO total_resources
74: FROM bom_operation_sequences a,
75: bom_operation_resources b
76: WHERE a.routing_sequence_id = from_rtg_seq_id
77: AND NVL (a.eco_for_production, 2) = 2
78: AND (display_option = 1

Line 99: FROM bom_operation_sequences a,

95: sql_stmt_num := 4;
96:
97: SELECT DISTINCT COUNT (*)
98: INTO total_sub_resources
99: FROM bom_operation_sequences a,
100: bom_operation_resources b,
101: bom_sub_operation_resources c
102: WHERE a.routing_sequence_id = from_rtg_seq_id
103: AND NVL (a.eco_for_production, 2) = 2

Line 127: FROM bom_operation_sequences a,

123: sql_stmt_num := 3;
124:
125: SELECT COUNT (*)
126: INTO total_instructions
127: FROM bom_operation_sequences a,
128: fnd_attached_documents b
129: WHERE a.routing_sequence_id = from_rtg_seq_id
130: AND NVL (a.eco_for_production, 2) = 2
131: AND (display_option = 1

Line 145: AND b.entity_name = 'BOM_OPERATION_SEQUENCES';

141: )
142: )
143: )
144: AND a.operation_sequence_id = b.pk1_value
145: AND b.entity_name = 'BOM_OPERATION_SEQUENCES';
146:
147: --begin bug fix 3473851
148: sql_stmt_num := 5;
149:

Line 265: FROM bom_operation_sequences

261: CURSOR source_rtg
262: IS
263: SELECT operation_sequence_id,
264: last_updated_by
265: FROM bom_operation_sequences
266: WHERE routing_sequence_id = to_sequence_id
267: AND NVL (eco_for_production, 2) = 2;
268:
269: CURSOR process_op

Line 273: FROM bom_operation_sequences

269: CURSOR process_op
270: IS
271: SELECT operation_sequence_id,
272: operation_seq_num
273: FROM bom_operation_sequences
274: WHERE routing_sequence_id = x_from_sequence_id -- Bug 2642427
275: AND NVL (eco_for_production, 2) = 2
276: AND operation_type = 2;
277:

Line 282: FROM bom_operation_sequences

278: CURSOR line_op
279: IS
280: SELECT operation_sequence_id,
281: operation_seq_num
282: FROM bom_operation_sequences
283: WHERE routing_sequence_id = x_from_sequence_id -- Bug 2642427
284: AND NVL (eco_for_production, 2) = 2
285: AND operation_type = 3;
286:

Line 292: FROM bom_operation_sequences

288: CURSOR update_st_op
289: IS
290: SELECT standard_operation_id,
291: operation_sequence_id
292: FROM bom_operation_sequences
293: WHERE routing_sequence_id = to_sequence_id;
294: l_from_item_id NUMBER;
295: BEGIN
296: SAVEPOINT begin_routing_copy;

Line 344: INSERT INTO bom_operation_sequences

340: ELSE
341: l_curr_date := p_trgt_eff_date; -- Routing can be copied to particular from TTMO flow - R12
342: END IF;
343:
344: INSERT INTO bom_operation_sequences
345: (operation_sequence_id,
346: routing_sequence_id,
347: operation_seq_num,
348: last_update_date,

Line 422: SELECT bom_operation_sequences_s.NEXTVAL,

418: show_lot_attrib,
419: track_multiple_res_usage_dates,
420: check_skill --added for bug 7597474
421: )
422: SELECT bom_operation_sequences_s.NEXTVAL,
423: to_sequence_id,
424: a.operation_seq_num,
425: l_curr_date,
426: a.operation_sequence_id,

Line 583: FROM bom_operation_sequences a, -- from op

579: a.show_scrap_code,
580: a.show_lot_attrib,
581: a.track_multiple_res_usage_dates,
582: a.check_skill --added for bug 7597474
583: FROM bom_operation_sequences a, -- from op
584: bom_departments b, -- from op's dept
585: bom_departments c -- to op's dept
586: WHERE a.routing_sequence_id = x_from_sequence_id
587: AND NVL (a.eco_for_production, 2) = 2

Line 626: FROM bom_operation_sequences bos

622: )
623: AND NOT EXISTS -- Bug 5151332 Disabled operations should not get copied in ECO context
624: (
625: SELECT 1
626: FROM bom_operation_sequences bos
627: WHERE bos.routing_sequence_id = a.routing_sequence_id
628: AND bos.old_operation_sequence_id = a.operation_sequence_id
629: AND bos.change_notice = p_context_eco
630: AND bos.acd_type = 3

Line 679: FROM bom_operation_sequences a, -- from op

675: fnd_global.conc_request_id,
676: NULL,
677: fnd_global.conc_program_id,
678: sysdate
679: FROM bom_operation_sequences a, -- from op
680: bom_departments b, -- from op's dept
681: bom_departments c -- to op's dept
682: WHERE a.routing_sequence_id = x_from_sequence_id
683: AND (display_option = 1 /* ALL */

Line 720: FROM bom_operation_sequences bos

716: )
717: AND NOT EXISTS -- Bug 5151332 Disabled operations should not get copied in ECO context
718: (
719: SELECT 1
720: FROM bom_operation_sequences bos
721: WHERE bos.routing_sequence_id = a.routing_sequence_id
722: AND bos.old_operation_sequence_id = a.operation_sequence_id
723: AND bos.change_notice = p_context_eco
724: AND bos.acd_type = 3

Line 747: FROM bom_operation_sequences a, -- from op

743: fnd_global.conc_request_id,
744: NULL,
745: fnd_global.conc_program_id,
746: sysdate
747: FROM bom_operation_sequences a, -- from op
748: bom_departments b, -- from op's dept
749: bom_departments c -- to op's dept
750: WHERE a.routing_sequence_id = x_from_sequence_id
751: AND (display_option = 1 /* ALL */

Line 788: FROM bom_operation_sequences bos

784: )
785: AND NOT EXISTS -- Bug 5151332 Disabled operations should not get copied in ECO context
786: (
787: SELECT 1
788: FROM bom_operation_sequences bos
789: WHERE bos.routing_sequence_id = a.routing_sequence_id
790: AND bos.old_operation_sequence_id = a.operation_sequence_id
791: AND bos.change_notice = p_context_eco
792: AND bos.acd_type = 3

Line 831: FROM bom_operation_sequences a

827: fnd_global.conc_request_id,
828: NULL,
829: fnd_global.conc_program_id,
830: sysdate
831: FROM bom_operation_sequences a
832: WHERE a.routing_sequence_id = x_from_sequence_id
833: AND (display_option = 1 /* ALL */
834: OR (display_option = 2 /* CURRENT */
835: AND a.effectivity_date <= rev_date

Line 866: FROM bom_operation_sequences bos

862: )
863: AND NOT EXISTS -- Bug 5151332 Disabled operations should not get copied in ECO context
864: (
865: SELECT 1
866: FROM bom_operation_sequences bos
867: WHERE bos.routing_sequence_id = a.routing_sequence_id
868: AND bos.old_operation_sequence_id = a.operation_sequence_id
869: AND bos.change_notice = p_context_eco
870: AND bos.acd_type = 3

Line 909: FROM bom_operation_sequences a

905: fnd_global.conc_request_id,
906: NULL,
907: fnd_global.conc_program_id,
908: sysdate
909: FROM bom_operation_sequences a
910: WHERE a.routing_sequence_id = x_from_sequence_id
911: AND (display_option = 1 /* ALL */
912: OR (display_option = 2 /* CURRENT */
913: AND a.effectivity_date <= rev_date

Line 985: UPDATE bom_operation_sequences

981: -- BUG 3936049
982: AND NVL (a.operation_type, -99) = NVL (b.operation_type,
983: -99); -- BUG 3936049
984:
985: UPDATE bom_operation_sequences
986: SET standard_operation_id = new_st_op_id,
987: minimum_transfer_quantity = min_qty,
988: backflush_flag = back_flag,
989: option_dependent_flag = opt_flag,

Line 999: UPDATE bom_operation_sequences

995: copy_ops_update := copy_ops_update + 1;
996: EXCEPTION
997: WHEN NO_DATA_FOUND
998: THEN
999: UPDATE bom_operation_sequences
1000: SET standard_operation_id = NULL
1001: WHERE routing_sequence_id = to_sequence_id
1002: AND operation_sequence_id = p_op_seq_id;
1003: END;

Line 1040: from bom_operation_skills SKL, bom_operation_sequences SEQ1, bom_operation_sequences SEQ2

1036: user_id,
1037: user_id,
1038: sysdate
1039:
1040: from bom_operation_skills SKL, bom_operation_sequences SEQ1, bom_operation_sequences SEQ2
1041: where SEQ1.routing_sequence_id = from_sequence_id
1042: and SEQ2.routing_sequence_id = to_sequence_id
1043: and SKL.operation_sequence_id = SEQ1.operation_sequence_id
1044: and SEQ1.operation_seq_num = SEQ2.operation_seq_num

Line 1048: from bom_operation_sequences

1044: and SEQ1.operation_seq_num = SEQ2.operation_seq_num
1045:
1046: and SKL.operation_sequence_id in
1047: (select operation_sequence_id
1048: from bom_operation_sequences
1049: where routing_sequence_id = from_sequence_id
1050: );
1051: --End bug fix for bug 7597474
1052:

Line 1065: FROM bom_operation_sequences

1061:
1062: BEGIN
1063: SELECT operation_sequence_id
1064: INTO new_p_op_seq_id
1065: FROM bom_operation_sequences
1066: WHERE routing_sequence_id = to_sequence_id
1067: AND operation_type = 2
1068: AND NVL (eco_for_production, 2) = 2
1069: AND operation_seq_num = p_op_seq_num;

Line 1076: UPDATE bom_operation_sequences

1072: THEN
1073: NULL;
1074: END;
1075:
1076: UPDATE bom_operation_sequences
1077: SET process_op_seq_id = new_p_op_seq_id
1078: WHERE operation_type = 1
1079: AND routing_sequence_id = to_sequence_id
1080: AND process_op_seq_id = p_op_seq_id;

Line 1095: FROM bom_operation_sequences

1091:
1092: BEGIN
1093: SELECT operation_sequence_id
1094: INTO new_l_op_seq_id
1095: FROM bom_operation_sequences
1096: WHERE routing_sequence_id = to_sequence_id
1097: AND operation_type = 3
1098: AND NVL (eco_for_production, 2) = 2
1099: AND operation_seq_num = l_op_seq_num;

Line 1106: UPDATE bom_operation_sequences

1102: THEN
1103: NULL;
1104: END;
1105:
1106: UPDATE bom_operation_sequences
1107: SET line_op_seq_id = new_l_op_seq_id
1108: WHERE operation_type = 1
1109: AND routing_sequence_id = to_sequence_id
1110: AND line_op_seq_id = l_op_seq_id;

Line 1185: bom_operation_sequences bos4, -- dest to op

1181: NULL,
1182: fnd_global.conc_program_id,
1183: sysdate
1184: FROM bom_operation_networks bon,
1185: bom_operation_sequences bos4, -- dest to op
1186: bom_operation_sequences bos3, -- dest from op
1187: bom_operation_sequences bos2, -- src to op
1188: bom_operation_sequences bos1 -- src from op
1189: WHERE bon.from_op_seq_id = bos1.operation_sequence_id

Line 1186: bom_operation_sequences bos3, -- dest from op

1182: fnd_global.conc_program_id,
1183: sysdate
1184: FROM bom_operation_networks bon,
1185: bom_operation_sequences bos4, -- dest to op
1186: bom_operation_sequences bos3, -- dest from op
1187: bom_operation_sequences bos2, -- src to op
1188: bom_operation_sequences bos1 -- src from op
1189: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
1190: AND bon.to_op_seq_id = bos2.operation_sequence_id

Line 1187: bom_operation_sequences bos2, -- src to op

1183: sysdate
1184: FROM bom_operation_networks bon,
1185: bom_operation_sequences bos4, -- dest to op
1186: bom_operation_sequences bos3, -- dest from op
1187: bom_operation_sequences bos2, -- src to op
1188: bom_operation_sequences bos1 -- src from op
1189: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
1190: AND bon.to_op_seq_id = bos2.operation_sequence_id
1191: AND bos1.routing_sequence_id = bos2.routing_sequence_id

Line 1188: bom_operation_sequences bos1 -- src from op

1184: FROM bom_operation_networks bon,
1185: bom_operation_sequences bos4, -- dest to op
1186: bom_operation_sequences bos3, -- dest from op
1187: bom_operation_sequences bos2, -- src to op
1188: bom_operation_sequences bos1 -- src from op
1189: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
1190: AND bon.to_op_seq_id = bos2.operation_sequence_id
1191: AND bos1.routing_sequence_id = bos2.routing_sequence_id
1192: AND bos1.routing_sequence_id = x_from_sequence_id

Line 1272: bom_operation_sequences bos4, -- dest to op

1268: NULL,
1269: fnd_global.conc_program_id,
1270: sysdate
1271: FROM bom_operation_networks bon,
1272: bom_operation_sequences bos4, -- dest to op
1273: bom_operation_sequences bos3, -- dest from op
1274: bom_operation_sequences bos2, -- src to op
1275: bom_operation_sequences bos1, -- src from op
1276: mfg_lookups mfgl

Line 1273: bom_operation_sequences bos3, -- dest from op

1269: fnd_global.conc_program_id,
1270: sysdate
1271: FROM bom_operation_networks bon,
1272: bom_operation_sequences bos4, -- dest to op
1273: bom_operation_sequences bos3, -- dest from op
1274: bom_operation_sequences bos2, -- src to op
1275: bom_operation_sequences bos1, -- src from op
1276: mfg_lookups mfgl
1277: WHERE bon.from_op_seq_id = bos1.operation_sequence_id

Line 1274: bom_operation_sequences bos2, -- src to op

1270: sysdate
1271: FROM bom_operation_networks bon,
1272: bom_operation_sequences bos4, -- dest to op
1273: bom_operation_sequences bos3, -- dest from op
1274: bom_operation_sequences bos2, -- src to op
1275: bom_operation_sequences bos1, -- src from op
1276: mfg_lookups mfgl
1277: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
1278: AND bon.to_op_seq_id = bos2.operation_sequence_id

Line 1275: bom_operation_sequences bos1, -- src from op

1271: FROM bom_operation_networks bon,
1272: bom_operation_sequences bos4, -- dest to op
1273: bom_operation_sequences bos3, -- dest from op
1274: bom_operation_sequences bos2, -- src to op
1275: bom_operation_sequences bos1, -- src from op
1276: mfg_lookups mfgl
1277: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
1278: AND bon.to_op_seq_id = bos2.operation_sequence_id
1279: AND bos1.routing_sequence_id = bos2.routing_sequence_id

Line 1314: bom_operation_sequences bos4, -- dest to op

1310: NULL,
1311: fnd_global.conc_program_id,
1312: sysdate
1313: FROM bom_operation_networks bon,
1314: bom_operation_sequences bos4, -- dest to op
1315: bom_operation_sequences bos3, -- dest from op
1316: bom_operation_sequences bos2, -- src to op
1317: bom_operation_sequences bos1, -- src from op
1318: mfg_lookups mfgl

Line 1315: bom_operation_sequences bos3, -- dest from op

1311: fnd_global.conc_program_id,
1312: sysdate
1313: FROM bom_operation_networks bon,
1314: bom_operation_sequences bos4, -- dest to op
1315: bom_operation_sequences bos3, -- dest from op
1316: bom_operation_sequences bos2, -- src to op
1317: bom_operation_sequences bos1, -- src from op
1318: mfg_lookups mfgl
1319: WHERE bon.from_op_seq_id = bos1.operation_sequence_id

Line 1316: bom_operation_sequences bos2, -- src to op

1312: sysdate
1313: FROM bom_operation_networks bon,
1314: bom_operation_sequences bos4, -- dest to op
1315: bom_operation_sequences bos3, -- dest from op
1316: bom_operation_sequences bos2, -- src to op
1317: bom_operation_sequences bos1, -- src from op
1318: mfg_lookups mfgl
1319: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
1320: AND bon.to_op_seq_id = bos2.operation_sequence_id

Line 1317: bom_operation_sequences bos1, -- src from op

1313: FROM bom_operation_networks bon,
1314: bom_operation_sequences bos4, -- dest to op
1315: bom_operation_sequences bos3, -- dest from op
1316: bom_operation_sequences bos2, -- src to op
1317: bom_operation_sequences bos1, -- src from op
1318: mfg_lookups mfgl
1319: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
1320: AND bon.to_op_seq_id = bos2.operation_sequence_id
1321: AND bos1.routing_sequence_id = bos2.routing_sequence_id

Line 1373: bom_operation_sequences bos4, -- dest to op

1369: NULL,
1370: fnd_global.conc_program_id,
1371: sysdate
1372: FROM bom_operation_networks bon,
1373: bom_operation_sequences bos4, -- dest to op
1374: bom_operation_sequences bos3, -- dest from op
1375: bom_operation_sequences bos2, -- src to op
1376: bom_operation_sequences bos1, -- src from op
1377: mfg_lookups mfgl

Line 1374: bom_operation_sequences bos3, -- dest from op

1370: fnd_global.conc_program_id,
1371: sysdate
1372: FROM bom_operation_networks bon,
1373: bom_operation_sequences bos4, -- dest to op
1374: bom_operation_sequences bos3, -- dest from op
1375: bom_operation_sequences bos2, -- src to op
1376: bom_operation_sequences bos1, -- src from op
1377: mfg_lookups mfgl
1378: WHERE bon.from_op_seq_id = bos1.operation_sequence_id

Line 1375: bom_operation_sequences bos2, -- src to op

1371: sysdate
1372: FROM bom_operation_networks bon,
1373: bom_operation_sequences bos4, -- dest to op
1374: bom_operation_sequences bos3, -- dest from op
1375: bom_operation_sequences bos2, -- src to op
1376: bom_operation_sequences bos1, -- src from op
1377: mfg_lookups mfgl
1378: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
1379: AND bon.to_op_seq_id = bos2.operation_sequence_id

Line 1376: bom_operation_sequences bos1, -- src from op

1372: FROM bom_operation_networks bon,
1373: bom_operation_sequences bos4, -- dest to op
1374: bom_operation_sequences bos3, -- dest from op
1375: bom_operation_sequences bos2, -- src to op
1376: bom_operation_sequences bos1, -- src from op
1377: mfg_lookups mfgl
1378: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
1379: AND bon.to_op_seq_id = bos2.operation_sequence_id
1380: AND bos1.routing_sequence_id = bos2.routing_sequence_id

Line 1415: bom_operation_sequences bos4, -- dest to op

1411: NULL,
1412: fnd_global.conc_program_id,
1413: sysdate
1414: FROM bom_operation_networks bon,
1415: bom_operation_sequences bos4, -- dest to op
1416: bom_operation_sequences bos3, -- dest from op
1417: bom_operation_sequences bos2, -- src to op
1418: bom_operation_sequences bos1, -- src from op
1419: mfg_lookups mfgl

Line 1416: bom_operation_sequences bos3, -- dest from op

1412: fnd_global.conc_program_id,
1413: sysdate
1414: FROM bom_operation_networks bon,
1415: bom_operation_sequences bos4, -- dest to op
1416: bom_operation_sequences bos3, -- dest from op
1417: bom_operation_sequences bos2, -- src to op
1418: bom_operation_sequences bos1, -- src from op
1419: mfg_lookups mfgl
1420: WHERE bon.from_op_seq_id = bos1.operation_sequence_id

Line 1417: bom_operation_sequences bos2, -- src to op

1413: sysdate
1414: FROM bom_operation_networks bon,
1415: bom_operation_sequences bos4, -- dest to op
1416: bom_operation_sequences bos3, -- dest from op
1417: bom_operation_sequences bos2, -- src to op
1418: bom_operation_sequences bos1, -- src from op
1419: mfg_lookups mfgl
1420: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
1421: AND bon.to_op_seq_id = bos2.operation_sequence_id

Line 1418: bom_operation_sequences bos1, -- src from op

1414: FROM bom_operation_networks bon,
1415: bom_operation_sequences bos4, -- dest to op
1416: bom_operation_sequences bos3, -- dest from op
1417: bom_operation_sequences bos2, -- src to op
1418: bom_operation_sequences bos1, -- src from op
1419: mfg_lookups mfgl
1420: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
1421: AND bon.to_op_seq_id = bos2.operation_sequence_id
1422: AND bos1.routing_sequence_id = bos2.routing_sequence_id

Line 1449: (x_from_entity_name => 'BOM_OPERATION_SEQUENCES',

1445: FOR x_op IN source_rtg
1446: LOOP
1447: sql_stmt_num := 201;
1448: fnd_attached_documents2_pkg.copy_attachments
1449: (x_from_entity_name => 'BOM_OPERATION_SEQUENCES',
1450: x_from_pk1_value => x_op.last_updated_by,
1451: x_from_pk2_value => '',
1452: x_from_pk3_value => '',
1453: x_from_pk4_value => '',

Line 1455: x_to_entity_name => 'BOM_OPERATION_SEQUENCES',

1451: x_from_pk2_value => '',
1452: x_from_pk3_value => '',
1453: x_from_pk4_value => '',
1454: x_from_pk5_value => '',
1455: x_to_entity_name => 'BOM_OPERATION_SEQUENCES',
1456: x_to_pk1_value => x_op.operation_sequence_id,
1457: x_to_pk2_value => '',
1458: x_to_pk3_value => '',
1459: x_to_pk4_value => '',

Line 1599: FROM bom_operation_sequences a,

1595: DECODE (p_routing_or_eco, 1, NULL, 1),
1596: -- Add is the action for ECO
1597: NULL --b.original_system_reference
1598: --bug 14332194 end
1599: FROM bom_operation_sequences a,
1600: bom_operation_resources b,
1601: bom_resources c,
1602: bom_resources d
1603: -- ,BOM_DEPARTMENT_RESOURCES E

Line 1649: FROM bom_operation_sequences a,

1645: fnd_global.conc_request_id,
1646: NULL,
1647: fnd_global.conc_program_id,
1648: sysdate
1649: FROM bom_operation_sequences a,
1650: bom_operation_resources b,
1651: bom_operation_sequences fbor,
1652: bom_resources c,
1653: bom_resources d

Line 1651: bom_operation_sequences fbor,

1647: fnd_global.conc_program_id,
1648: sysdate
1649: FROM bom_operation_sequences a,
1650: bom_operation_resources b,
1651: bom_operation_sequences fbor,
1652: bom_resources c,
1653: bom_resources d
1654: WHERE a.routing_sequence_id = to_sequence_id
1655: AND a.last_updated_by = b.operation_sequence_id

Line 1679: FROM bom_operation_sequences a,

1675: fnd_global.conc_request_id,
1676: NULL,
1677: fnd_global.conc_program_id,
1678: sysdate
1679: FROM bom_operation_sequences a,
1680: bom_operation_resources b,
1681: bom_operation_sequences fbor,
1682: bom_resources c,
1683: bom_resources d

Line 1681: bom_operation_sequences fbor,

1677: fnd_global.conc_program_id,
1678: sysdate
1679: FROM bom_operation_sequences a,
1680: bom_operation_resources b,
1681: bom_operation_sequences fbor,
1682: bom_resources c,
1683: bom_resources d
1684: WHERE a.routing_sequence_id = to_sequence_id
1685: AND a.last_updated_by = b.operation_sequence_id

Line 1740: FROM bom_operation_sequences

1736: FROM bom_setup_types
1737: WHERE setup_id = a.setup_id))
1738: WHERE a.operation_sequence_id IN (
1739: SELECT operation_sequence_id
1740: FROM bom_operation_sequences
1741: WHERE routing_sequence_id =
1742: to_sequence_id);
1743: END IF;
1744:

Line 1852: bom_operation_sequences a, /Added for Bug 6828461/

1848: DECODE (p_routing_or_eco, 1, NULL, 1),
1849: NULL
1850: --bug 14332194 end
1851: FROM /*BOM_OPERATION_RESOURCES A, Commented for Bug 6828461*/
1852: bom_operation_sequences a, /*Added for Bug 6828461*/
1853: bom_sub_operation_resources b,
1854: bom_resources c,
1855: bom_resources d
1856: WHERE A.ROUTING_SEQUENCE_ID = to_sequence_id /*Added for performance improvement for bug 6828461*/

Line 1901: bom_operation_sequences fbor,

1897: NULL,
1898: fnd_global.conc_program_id,
1899: sysdate
1900: FROM bom_operation_resources a,
1901: bom_operation_sequences fbor,
1902: bom_sub_operation_resources b,
1903: bom_resources c,
1904: bom_resources d
1905: WHERE a.last_updated_by = b.operation_sequence_id

Line 1931: bom_operation_sequences fbor,

1927: NULL,
1928: fnd_global.conc_program_id,
1929: sysdate
1930: FROM bom_operation_resources a,
1931: bom_operation_sequences fbor,
1932: bom_sub_operation_resources b,
1933: bom_resources c,
1934: bom_resources d
1935: WHERE a.last_updated_by = b.operation_sequence_id

Line 1983: FROM bom_operation_sequences

1979: FROM bom_setup_types
1980: WHERE setup_id = a.setup_id))
1981: WHERE a.operation_sequence_id IN (
1982: SELECT operation_sequence_id
1983: FROM bom_operation_sequences
1984: WHERE routing_sequence_id =
1985: to_sequence_id);
1986: END IF;
1987:

Line 1993: UPDATE bom_operation_sequences

1989:
1990: -- UPDATE LAST_UPDATED_BY COLUMN USED TO STORE COPY_FROM OP_SEQ_IDS
1991: sql_stmt_num := 55;
1992:
1993: UPDATE bom_operation_sequences
1994: SET last_updated_by = user_id
1995: WHERE routing_sequence_id = to_sequence_id;
1996:
1997: -- Bug Fix 2991810

Line 2005: FROM bom_operation_sequences

2001: SET last_updated_by = user_id,
2002: created_by = user_id
2003: WHERE operation_sequence_id IN (
2004: SELECT operation_sequence_id
2005: FROM bom_operation_sequences
2006: WHERE routing_sequence_id =
2007: to_sequence_id);
2008:
2009: sql_stmt_num := 39;

Line 2014: bom_operation_sequences a

2010:
2011: SELECT COUNT (*)
2012: INTO copy_instrs
2013: FROM fnd_attached_documents b,
2014: bom_operation_sequences a
2015: WHERE a.routing_sequence_id = to_sequence_id
2016: AND a.operation_sequence_id = b.pk1_value
2017: AND b.entity_name = 'BOM_OPERATION_SEQUENCES';
2018:

Line 2017: AND b.entity_name = 'BOM_OPERATION_SEQUENCES';

2013: FROM fnd_attached_documents b,
2014: bom_operation_sequences a
2015: WHERE a.routing_sequence_id = to_sequence_id
2016: AND a.operation_sequence_id = b.pk1_value
2017: AND b.entity_name = 'BOM_OPERATION_SEQUENCES';
2018:
2019: --begin bug fix 3473851
2020: sql_stmt_num := 40;
2021:

Line 2379: FROM bom_operation_sequences

2375: CURSOR source_rtg
2376: IS
2377: SELECT operation_sequence_id,
2378: last_updated_by
2379: FROM bom_operation_sequences
2380: WHERE routing_sequence_id = to_sequence_id
2381: AND NVL (eco_for_production, 2) = 2;
2382:
2383: CURSOR process_op

Line 2387: FROM bom_operation_sequences

2383: CURSOR process_op
2384: IS
2385: SELECT operation_sequence_id,
2386: operation_seq_num
2387: FROM bom_operation_sequences
2388: WHERE routing_sequence_id = x_from_sequence_id -- Bug 2642427
2389: AND NVL (eco_for_production, 2) = 2
2390: AND operation_type = 2;
2391:

Line 2396: FROM bom_operation_sequences

2392: CURSOR line_op
2393: IS
2394: SELECT operation_sequence_id,
2395: operation_seq_num
2396: FROM bom_operation_sequences
2397: WHERE routing_sequence_id = x_from_sequence_id -- Bug 2642427
2398: AND NVL (eco_for_production, 2) = 2
2399: AND operation_type = 3;
2400:

Line 2406: FROM bom_operation_sequences

2402: CURSOR update_st_op
2403: IS
2404: SELECT standard_operation_id,
2405: operation_sequence_id
2406: FROM bom_operation_sequences
2407: WHERE routing_sequence_id = to_sequence_id;
2408: l_from_item_id NUMBER;
2409: BEGIN
2410: SAVEPOINT begin_routing_copy;

Line 2458: INSERT INTO bom_operation_sequences

2454: ELSE
2455: l_curr_date := p_trgt_eff_date; -- Routing can be copied to particular from TTMO flow - R12
2456: END IF;
2457:
2458: INSERT INTO bom_operation_sequences
2459: (operation_sequence_id,
2460: routing_sequence_id,
2461: operation_seq_num,
2462: last_update_date,

Line 2536: SELECT bom_operation_sequences_s.NEXTVAL,

2532: show_lot_attrib,
2533: track_multiple_res_usage_dates,
2534: check_skill --added for bug 7597474
2535: )
2536: SELECT bom_operation_sequences_s.NEXTVAL,
2537: to_sequence_id,
2538: a.operation_seq_num,
2539: l_curr_date,
2540: a.operation_sequence_id,

Line 2627: FROM bom_operation_sequences a, -- from op

2623: a.show_scrap_code,
2624: a.show_lot_attrib,
2625: a.track_multiple_res_usage_dates,
2626: a.check_skill --added for bug 7597474
2627: FROM bom_operation_sequences a, -- from op
2628: bom_departments b, -- from op's dept
2629: bom_departments c -- to op's dept
2630: WHERE a.routing_sequence_id = x_from_sequence_id
2631: AND NVL (a.eco_for_production, 2) = 2

Line 2650: FROM bom_operation_sequences bos

2646: )
2647: AND NOT EXISTS -- Bug 5151332 Disabled operations should not get copied in ECO context
2648: (
2649: SELECT 1
2650: FROM bom_operation_sequences bos
2651: WHERE bos.routing_sequence_id = a.routing_sequence_id
2652: AND bos.old_operation_sequence_id = a.operation_sequence_id
2653: AND bos.change_notice = p_context_eco
2654: AND bos.acd_type = 3

Line 2703: FROM bom_operation_sequences a, -- from op

2699: fnd_global.conc_request_id,
2700: NULL,
2701: fnd_global.conc_program_id,
2702: sysdate
2703: FROM bom_operation_sequences a, -- from op
2704: bom_departments b, -- from op's dept
2705: bom_departments c -- to op's dept
2706: WHERE a.routing_sequence_id = x_from_sequence_id
2707: AND ( ( p_cpy_disable_fields = 'Y' AND a.effectivity_date <= rev_date) -- For first revised item we can have past eff comps as eff on the target date

Line 2724: FROM bom_operation_sequences bos

2720: )
2721: AND NOT EXISTS -- Bug 5151332 Disabled operations should not get copied in ECO context
2722: (
2723: SELECT 1
2724: FROM bom_operation_sequences bos
2725: WHERE bos.routing_sequence_id = a.routing_sequence_id
2726: AND bos.old_operation_sequence_id = a.operation_sequence_id
2727: AND bos.change_notice = p_context_eco
2728: AND bos.acd_type = 3

Line 2751: FROM bom_operation_sequences a, -- from op

2747: fnd_global.conc_request_id,
2748: NULL,
2749: fnd_global.conc_program_id,
2750: sysdate
2751: FROM bom_operation_sequences a, -- from op
2752: bom_departments b -- from op's dept
2753: WHERE a.routing_sequence_id = x_from_sequence_id
2754: AND ( ( p_cpy_disable_fields = 'Y' AND a.effectivity_date <= rev_date) -- For first revised item we can have past eff comps as eff on the target date
2755: OR ( p_cpy_disable_fields = 'N' AND a.effectivity_date = rev_date )

Line 2767: FROM bom_operation_sequences bos

2763: )
2764: AND NOT EXISTS -- Bug 5151332 Disabled operations should not get copied in ECO context
2765: (
2766: SELECT 1
2767: FROM bom_operation_sequences bos
2768: WHERE bos.routing_sequence_id = a.routing_sequence_id
2769: AND bos.old_operation_sequence_id = a.operation_sequence_id
2770: AND bos.change_notice = p_context_eco
2771: AND bos.acd_type = 3

Line 2810: FROM bom_operation_sequences a

2806: fnd_global.conc_request_id,
2807: NULL,
2808: fnd_global.conc_program_id,
2809: sysdate
2810: FROM bom_operation_sequences a
2811: WHERE a.routing_sequence_id = x_from_sequence_id
2812: AND ( ( p_cpy_disable_fields = 'Y' AND a.effectivity_date <= rev_date) -- For first revised item we can have past eff comps as eff on the target date
2813: OR ( p_cpy_disable_fields = 'N' AND a.effectivity_date = rev_date )
2814: )

Line 2825: FROM bom_operation_sequences bos

2821: )
2822: AND NOT EXISTS -- Bug 5151332 Disabled operations should not get copied in ECO context
2823: (
2824: SELECT 1
2825: FROM bom_operation_sequences bos
2826: WHERE bos.routing_sequence_id = a.routing_sequence_id
2827: AND bos.old_operation_sequence_id = a.operation_sequence_id
2828: AND bos.change_notice = p_context_eco
2829: AND bos.acd_type = 3

Line 2869: FROM bom_operation_sequences a

2865: fnd_global.conc_request_id,
2866: NULL,
2867: fnd_global.conc_program_id,
2868: sysdate
2869: FROM bom_operation_sequences a
2870: WHERE a.routing_sequence_id = x_from_sequence_id
2871: AND ( ( p_cpy_disable_fields = 'Y' AND a.effectivity_date <= rev_date) -- For first revised item we can have past eff comps as eff on the target date
2872: OR ( p_cpy_disable_fields = 'N' AND a.effectivity_date = rev_date )
2873: )

Line 2925: UPDATE bom_operation_sequences

2921: -- BUG 3936049
2922: AND NVL (a.operation_type, -99) = NVL (b.operation_type,
2923: -99); -- BUG 3936049
2924:
2925: UPDATE bom_operation_sequences
2926: SET standard_operation_id = new_st_op_id,
2927: minimum_transfer_quantity = min_qty,
2928: backflush_flag = back_flag,
2929: option_dependent_flag = opt_flag,

Line 2939: UPDATE bom_operation_sequences

2935: copy_ops_update := copy_ops_update + 1;
2936: EXCEPTION
2937: WHEN NO_DATA_FOUND
2938: THEN
2939: UPDATE bom_operation_sequences
2940: SET standard_operation_id = NULL
2941: WHERE routing_sequence_id = to_sequence_id
2942: AND operation_sequence_id = p_op_seq_id;
2943: END;

Line 2980: from bom_operation_skills SKL, bom_operation_sequences SEQ1, bom_operation_sequences SEQ2

2976: user_id,
2977: user_id,
2978: sysdate
2979:
2980: from bom_operation_skills SKL, bom_operation_sequences SEQ1, bom_operation_sequences SEQ2
2981: where SEQ1.routing_sequence_id = from_sequence_id
2982: and SEQ2.routing_sequence_id = to_sequence_id
2983: and SKL.operation_sequence_id = SEQ1.operation_sequence_id
2984: and SEQ1.operation_seq_num = SEQ2.operation_seq_num

Line 2988: from bom_operation_sequences

2984: and SEQ1.operation_seq_num = SEQ2.operation_seq_num
2985:
2986: and SKL.operation_sequence_id in
2987: (select operation_sequence_id
2988: from bom_operation_sequences
2989: where routing_sequence_id = from_sequence_id
2990: );
2991: --End bug fix for bug 7597474
2992:

Line 3005: FROM bom_operation_sequences

3001:
3002: BEGIN
3003: SELECT operation_sequence_id
3004: INTO new_p_op_seq_id
3005: FROM bom_operation_sequences
3006: WHERE routing_sequence_id = to_sequence_id
3007: AND operation_type = 2
3008: AND NVL (eco_for_production, 2) = 2
3009: AND operation_seq_num = p_op_seq_num;

Line 3016: UPDATE bom_operation_sequences

3012: THEN
3013: NULL;
3014: END;
3015:
3016: UPDATE bom_operation_sequences
3017: SET process_op_seq_id = new_p_op_seq_id
3018: WHERE operation_type = 1
3019: AND routing_sequence_id = to_sequence_id
3020: AND process_op_seq_id = p_op_seq_id;

Line 3035: FROM bom_operation_sequences

3031:
3032: BEGIN
3033: SELECT operation_sequence_id
3034: INTO new_l_op_seq_id
3035: FROM bom_operation_sequences
3036: WHERE routing_sequence_id = to_sequence_id
3037: AND operation_type = 3
3038: AND NVL (eco_for_production, 2) = 2
3039: AND operation_seq_num = l_op_seq_num;

Line 3046: UPDATE bom_operation_sequences

3042: THEN
3043: NULL;
3044: END;
3045:
3046: UPDATE bom_operation_sequences
3047: SET line_op_seq_id = new_l_op_seq_id
3048: WHERE operation_type = 1
3049: AND routing_sequence_id = to_sequence_id
3050: AND line_op_seq_id = l_op_seq_id;

Line 3125: bom_operation_sequences bos4, -- dest to op

3121: NULL,
3122: fnd_global.conc_program_id,
3123: sysdate
3124: FROM bom_operation_networks bon,
3125: bom_operation_sequences bos4, -- dest to op
3126: bom_operation_sequences bos3, -- dest from op
3127: bom_operation_sequences bos2, -- src to op
3128: bom_operation_sequences bos1 -- src from op
3129: WHERE bon.from_op_seq_id = bos1.operation_sequence_id

Line 3126: bom_operation_sequences bos3, -- dest from op

3122: fnd_global.conc_program_id,
3123: sysdate
3124: FROM bom_operation_networks bon,
3125: bom_operation_sequences bos4, -- dest to op
3126: bom_operation_sequences bos3, -- dest from op
3127: bom_operation_sequences bos2, -- src to op
3128: bom_operation_sequences bos1 -- src from op
3129: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
3130: AND bon.to_op_seq_id = bos2.operation_sequence_id

Line 3127: bom_operation_sequences bos2, -- src to op

3123: sysdate
3124: FROM bom_operation_networks bon,
3125: bom_operation_sequences bos4, -- dest to op
3126: bom_operation_sequences bos3, -- dest from op
3127: bom_operation_sequences bos2, -- src to op
3128: bom_operation_sequences bos1 -- src from op
3129: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
3130: AND bon.to_op_seq_id = bos2.operation_sequence_id
3131: AND bos1.routing_sequence_id = bos2.routing_sequence_id

Line 3128: bom_operation_sequences bos1 -- src from op

3124: FROM bom_operation_networks bon,
3125: bom_operation_sequences bos4, -- dest to op
3126: bom_operation_sequences bos3, -- dest from op
3127: bom_operation_sequences bos2, -- src to op
3128: bom_operation_sequences bos1 -- src from op
3129: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
3130: AND bon.to_op_seq_id = bos2.operation_sequence_id
3131: AND bos1.routing_sequence_id = bos2.routing_sequence_id
3132: AND bos1.routing_sequence_id = x_from_sequence_id

Line 3213: bom_operation_sequences bos4, -- dest to op

3209: NULL,
3210: fnd_global.conc_program_id,
3211: sysdate
3212: FROM bom_operation_networks bon,
3213: bom_operation_sequences bos4, -- dest to op
3214: bom_operation_sequences bos3, -- dest from op
3215: bom_operation_sequences bos2, -- src to op
3216: bom_operation_sequences bos1, -- src from op
3217: mfg_lookups mfgl

Line 3214: bom_operation_sequences bos3, -- dest from op

3210: fnd_global.conc_program_id,
3211: sysdate
3212: FROM bom_operation_networks bon,
3213: bom_operation_sequences bos4, -- dest to op
3214: bom_operation_sequences bos3, -- dest from op
3215: bom_operation_sequences bos2, -- src to op
3216: bom_operation_sequences bos1, -- src from op
3217: mfg_lookups mfgl
3218: WHERE bon.from_op_seq_id = bos1.operation_sequence_id

Line 3215: bom_operation_sequences bos2, -- src to op

3211: sysdate
3212: FROM bom_operation_networks bon,
3213: bom_operation_sequences bos4, -- dest to op
3214: bom_operation_sequences bos3, -- dest from op
3215: bom_operation_sequences bos2, -- src to op
3216: bom_operation_sequences bos1, -- src from op
3217: mfg_lookups mfgl
3218: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
3219: AND bon.to_op_seq_id = bos2.operation_sequence_id

Line 3216: bom_operation_sequences bos1, -- src from op

3212: FROM bom_operation_networks bon,
3213: bom_operation_sequences bos4, -- dest to op
3214: bom_operation_sequences bos3, -- dest from op
3215: bom_operation_sequences bos2, -- src to op
3216: bom_operation_sequences bos1, -- src from op
3217: mfg_lookups mfgl
3218: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
3219: AND bon.to_op_seq_id = bos2.operation_sequence_id
3220: AND bos1.routing_sequence_id = bos2.routing_sequence_id

Line 3256: bom_operation_sequences bos4, -- dest to op

3252: NULL,
3253: fnd_global.conc_program_id,
3254: sysdate
3255: FROM bom_operation_networks bon,
3256: bom_operation_sequences bos4, -- dest to op
3257: bom_operation_sequences bos3, -- dest from op
3258: bom_operation_sequences bos2, -- src to op
3259: bom_operation_sequences bos1, -- src from op
3260: mfg_lookups mfgl

Line 3257: bom_operation_sequences bos3, -- dest from op

3253: fnd_global.conc_program_id,
3254: sysdate
3255: FROM bom_operation_networks bon,
3256: bom_operation_sequences bos4, -- dest to op
3257: bom_operation_sequences bos3, -- dest from op
3258: bom_operation_sequences bos2, -- src to op
3259: bom_operation_sequences bos1, -- src from op
3260: mfg_lookups mfgl
3261: WHERE bon.from_op_seq_id = bos1.operation_sequence_id

Line 3258: bom_operation_sequences bos2, -- src to op

3254: sysdate
3255: FROM bom_operation_networks bon,
3256: bom_operation_sequences bos4, -- dest to op
3257: bom_operation_sequences bos3, -- dest from op
3258: bom_operation_sequences bos2, -- src to op
3259: bom_operation_sequences bos1, -- src from op
3260: mfg_lookups mfgl
3261: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
3262: AND bon.to_op_seq_id = bos2.operation_sequence_id

Line 3259: bom_operation_sequences bos1, -- src from op

3255: FROM bom_operation_networks bon,
3256: bom_operation_sequences bos4, -- dest to op
3257: bom_operation_sequences bos3, -- dest from op
3258: bom_operation_sequences bos2, -- src to op
3259: bom_operation_sequences bos1, -- src from op
3260: mfg_lookups mfgl
3261: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
3262: AND bon.to_op_seq_id = bos2.operation_sequence_id
3263: AND bos1.routing_sequence_id = bos2.routing_sequence_id

Line 3316: bom_operation_sequences bos4, -- dest to op

3312: NULL,
3313: fnd_global.conc_program_id,
3314: sysdate
3315: FROM bom_operation_networks bon,
3316: bom_operation_sequences bos4, -- dest to op
3317: bom_operation_sequences bos3, -- dest from op
3318: bom_operation_sequences bos2, -- src to op
3319: bom_operation_sequences bos1, -- src from op
3320: mfg_lookups mfgl

Line 3317: bom_operation_sequences bos3, -- dest from op

3313: fnd_global.conc_program_id,
3314: sysdate
3315: FROM bom_operation_networks bon,
3316: bom_operation_sequences bos4, -- dest to op
3317: bom_operation_sequences bos3, -- dest from op
3318: bom_operation_sequences bos2, -- src to op
3319: bom_operation_sequences bos1, -- src from op
3320: mfg_lookups mfgl
3321: WHERE bon.from_op_seq_id = bos1.operation_sequence_id

Line 3318: bom_operation_sequences bos2, -- src to op

3314: sysdate
3315: FROM bom_operation_networks bon,
3316: bom_operation_sequences bos4, -- dest to op
3317: bom_operation_sequences bos3, -- dest from op
3318: bom_operation_sequences bos2, -- src to op
3319: bom_operation_sequences bos1, -- src from op
3320: mfg_lookups mfgl
3321: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
3322: AND bon.to_op_seq_id = bos2.operation_sequence_id

Line 3319: bom_operation_sequences bos1, -- src from op

3315: FROM bom_operation_networks bon,
3316: bom_operation_sequences bos4, -- dest to op
3317: bom_operation_sequences bos3, -- dest from op
3318: bom_operation_sequences bos2, -- src to op
3319: bom_operation_sequences bos1, -- src from op
3320: mfg_lookups mfgl
3321: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
3322: AND bon.to_op_seq_id = bos2.operation_sequence_id
3323: AND bos1.routing_sequence_id = bos2.routing_sequence_id

Line 3359: bom_operation_sequences bos4, -- dest to op

3355: NULL,
3356: fnd_global.conc_program_id,
3357: sysdate
3358: FROM bom_operation_networks bon,
3359: bom_operation_sequences bos4, -- dest to op
3360: bom_operation_sequences bos3, -- dest from op
3361: bom_operation_sequences bos2, -- src to op
3362: bom_operation_sequences bos1, -- src from op
3363: mfg_lookups mfgl

Line 3360: bom_operation_sequences bos3, -- dest from op

3356: fnd_global.conc_program_id,
3357: sysdate
3358: FROM bom_operation_networks bon,
3359: bom_operation_sequences bos4, -- dest to op
3360: bom_operation_sequences bos3, -- dest from op
3361: bom_operation_sequences bos2, -- src to op
3362: bom_operation_sequences bos1, -- src from op
3363: mfg_lookups mfgl
3364: WHERE bon.from_op_seq_id = bos1.operation_sequence_id

Line 3361: bom_operation_sequences bos2, -- src to op

3357: sysdate
3358: FROM bom_operation_networks bon,
3359: bom_operation_sequences bos4, -- dest to op
3360: bom_operation_sequences bos3, -- dest from op
3361: bom_operation_sequences bos2, -- src to op
3362: bom_operation_sequences bos1, -- src from op
3363: mfg_lookups mfgl
3364: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
3365: AND bon.to_op_seq_id = bos2.operation_sequence_id

Line 3362: bom_operation_sequences bos1, -- src from op

3358: FROM bom_operation_networks bon,
3359: bom_operation_sequences bos4, -- dest to op
3360: bom_operation_sequences bos3, -- dest from op
3361: bom_operation_sequences bos2, -- src to op
3362: bom_operation_sequences bos1, -- src from op
3363: mfg_lookups mfgl
3364: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
3365: AND bon.to_op_seq_id = bos2.operation_sequence_id
3366: AND bos1.routing_sequence_id = bos2.routing_sequence_id

Line 3494: FROM bom_operation_sequences a,

3490: DECODE(p_routing_or_eco, 1, NULL, p_e_change_notice),
3491: DECODE(p_routing_or_eco, 1, NULL, 1),
3492: NULL
3493: --bug 14380725 end
3494: FROM bom_operation_sequences a,
3495: bom_operation_resources b,
3496: bom_resources c,
3497: bom_resources d
3498: -- ,BOM_DEPARTMENT_RESOURCES E

Line 3545: FROM bom_operation_sequences a,

3541: fnd_global.conc_request_id,
3542: NULL,
3543: fnd_global.conc_program_id,
3544: sysdate
3545: FROM bom_operation_sequences a,
3546: bom_operation_resources b,
3547: bom_operation_sequences fbor,
3548: bom_resources c,
3549: bom_resources d

Line 3547: bom_operation_sequences fbor,

3543: fnd_global.conc_program_id,
3544: sysdate
3545: FROM bom_operation_sequences a,
3546: bom_operation_resources b,
3547: bom_operation_sequences fbor,
3548: bom_resources c,
3549: bom_resources d
3550: WHERE a.routing_sequence_id = to_sequence_id
3551: AND a.last_updated_by = b.operation_sequence_id

Line 3576: FROM bom_operation_sequences a,

3572: fnd_global.conc_request_id,
3573: NULL,
3574: fnd_global.conc_program_id,
3575: sysdate
3576: FROM bom_operation_sequences a,
3577: bom_operation_resources b,
3578: bom_operation_sequences fbor,
3579: bom_resources c,
3580: bom_resources d

Line 3578: bom_operation_sequences fbor,

3574: fnd_global.conc_program_id,
3575: sysdate
3576: FROM bom_operation_sequences a,
3577: bom_operation_resources b,
3578: bom_operation_sequences fbor,
3579: bom_resources c,
3580: bom_resources d
3581: WHERE a.routing_sequence_id = to_sequence_id
3582: AND a.last_updated_by = b.operation_sequence_id

Line 3638: FROM bom_operation_sequences

3634: FROM bom_setup_types
3635: WHERE setup_id = a.setup_id))
3636: WHERE a.operation_sequence_id IN (
3637: SELECT operation_sequence_id
3638: FROM bom_operation_sequences
3639: WHERE routing_sequence_id =
3640: to_sequence_id);
3641: END IF;
3642:

Line 3752: bom_operation_sequences bos

3748: FROM bom_operation_resources a,
3749: bom_sub_operation_resources b,
3750: bom_resources c,
3751: bom_resources d,
3752: bom_operation_sequences bos
3753: WHERE a.last_updated_by = b.operation_sequence_id
3754: AND bos.operation_sequence_id = b.operation_sequence_id
3755: AND bos.revised_item_sequence_id = p_rev_item_seq_id
3756: AND a.created_by = b.schedule_seq_num

Line 3799: bom_operation_sequences fbor,

3795: NULL,
3796: fnd_global.conc_program_id,
3797: sysdate
3798: FROM bom_operation_resources a,
3799: bom_operation_sequences fbor,
3800: bom_sub_operation_resources b,
3801: bom_resources c,
3802: bom_resources d
3803: WHERE a.last_updated_by = b.operation_sequence_id

Line 3830: bom_operation_sequences fbor,

3826: NULL,
3827: fnd_global.conc_program_id,
3828: sysdate
3829: FROM bom_operation_resources a,
3830: bom_operation_sequences fbor,
3831: bom_sub_operation_resources b,
3832: bom_resources c,
3833: bom_resources d
3834: WHERE a.last_updated_by = b.operation_sequence_id

Line 3883: FROM bom_operation_sequences

3879: FROM bom_setup_types
3880: WHERE setup_id = a.setup_id))
3881: WHERE a.operation_sequence_id IN (
3882: SELECT operation_sequence_id
3883: FROM bom_operation_sequences
3884: WHERE routing_sequence_id =
3885: to_sequence_id);
3886: END IF;
3887:

Line 3893: UPDATE bom_operation_sequences

3889:
3890: -- UPDATE LAST_UPDATED_BY COLUMN USED TO STORE COPY_FROM OP_SEQ_IDS
3891: sql_stmt_num := 55;
3892:
3893: UPDATE bom_operation_sequences
3894: SET last_updated_by = user_id
3895: WHERE routing_sequence_id = to_sequence_id;
3896:
3897: -- Bug Fix 2991810

Line 3905: FROM bom_operation_sequences

3901: SET last_updated_by = user_id,
3902: created_by = user_id
3903: WHERE operation_sequence_id IN (
3904: SELECT operation_sequence_id
3905: FROM bom_operation_sequences
3906: WHERE routing_sequence_id =
3907: to_sequence_id);
3908:
3909: sql_stmt_num := 39;

Line 3914: bom_operation_sequences a

3910:
3911: SELECT COUNT (*)
3912: INTO copy_instrs
3913: FROM fnd_attached_documents b,
3914: bom_operation_sequences a
3915: WHERE a.routing_sequence_id = to_sequence_id
3916: AND a.operation_sequence_id = b.pk1_value
3917: AND b.entity_name = 'BOM_OPERATION_SEQUENCES';
3918:

Line 3917: AND b.entity_name = 'BOM_OPERATION_SEQUENCES';

3913: FROM fnd_attached_documents b,
3914: bom_operation_sequences a
3915: WHERE a.routing_sequence_id = to_sequence_id
3916: AND a.operation_sequence_id = b.pk1_value
3917: AND b.entity_name = 'BOM_OPERATION_SEQUENCES';
3918:
3919: --begin bug fix 3473851
3920: sql_stmt_num := 40;
3921:

Line 3970: FROM bom_operation_sequences

3966: CURSOR source_rtg
3967: IS
3968: SELECT operation_sequence_id,
3969: last_updated_by
3970: FROM bom_operation_sequences
3971: WHERE routing_sequence_id = p_to_sequence_id
3972: AND NVL (eco_for_production, 2) = 2;
3973: BEGIN
3974:

Line 3979: (x_from_entity_name => 'BOM_OPERATION_SEQUENCES',

3975: BEGIN
3976: FOR x_op IN source_rtg
3977: LOOP
3978: fnd_attached_documents2_pkg.copy_attachments
3979: (x_from_entity_name => 'BOM_OPERATION_SEQUENCES',
3980: x_from_pk1_value => x_op.last_updated_by,
3981: x_from_pk2_value => '',
3982: x_from_pk3_value => '',
3983: x_from_pk4_value => '',

Line 3985: x_to_entity_name => 'BOM_OPERATION_SEQUENCES',

3981: x_from_pk2_value => '',
3982: x_from_pk3_value => '',
3983: x_from_pk4_value => '',
3984: x_from_pk5_value => '',
3985: x_to_entity_name => 'BOM_OPERATION_SEQUENCES',
3986: x_to_pk1_value => x_op.operation_sequence_id,
3987: x_to_pk2_value => '',
3988: x_to_pk3_value => '',
3989: x_to_pk4_value => '',

Line 4030: UPDATE bom_operation_sequences bos

4026: ,p_to_sequence_id IN NUMBER )
4027: IS
4028: BEGIN
4029:
4030: UPDATE bom_operation_sequences bos
4031: SET last_updated_by = p_user_id
4032: WHERE bos.routing_sequence_id = p_to_sequence_id;
4033:
4034: END;