[Home] [Help]
1109: AND routing_sequence_id = to_sequence_id
1110: AND line_op_seq_id = l_op_seq_id;
1111: END LOOP;
1112:
1113: INSERT INTO bom_operation_networks
1114: (from_op_seq_id,
1115: to_op_seq_id,
1116: transition_type,
1117: planning_pct,
1180: fnd_global.conc_request_id,
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
1267: fnd_global.conc_request_id,
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
1309: fnd_global.conc_request_id,
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
1368: fnd_global.conc_request_id,
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
1410: fnd_global.conc_request_id,
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
3049: AND routing_sequence_id = to_sequence_id
3050: AND line_op_seq_id = l_op_seq_id;
3051: END LOOP;
3052:
3053: INSERT INTO bom_operation_networks
3054: (from_op_seq_id,
3055: to_op_seq_id,
3056: transition_type,
3057: planning_pct,
3120: fnd_global.conc_request_id,
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
3208: fnd_global.conc_request_id,
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
3251: fnd_global.conc_request_id,
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
3311: fnd_global.conc_request_id,
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
3354: fnd_global.conc_request_id,
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