[Home] [Help]
32: |
33: | ksarkar 19-JUL-01 Bugfix 1876999
34: | Remove semicolon from comment to improve performance .
35: | ksarkar 17-AUG-01 Bugfix 1906371
36: | Unique constraint on bom_operation_sequences will be violated
37: | when config item has selected options with same op seq number.
38: | Refer bug for details
39: |
40: | ksarkar 17-AUG-01 Bugfix 1935580
37: | when config item has selected options with same op seq number.
38: | Refer bug for details
39: |
40: | ksarkar 17-AUG-01 Bugfix 1935580
41: | Unique constraint on bom_operation_sequences will be violated
42: | hen config item has selected models with same op seq number.
43: | Refer bug for details
44: | Add bom_bill_of_materials.organization_id = pOrgId condition
45: | to select routing from correct organisation.
44: | Add bom_bill_of_materials.organization_id = pOrgId condition
45: | to select routing from correct organisation.
46: |
47: | Combining 1935580 and 1906371 ; since option rows are inserted into
48: | bom_operation_sequences after model rows , check needs to be there
49: | while inserting option rows to see whether combination of
50: | operation_seq_num - operation_type - routing_sequence_id - effectivity_date
51: | is already present in the table for the model rows .
52: |
249: +--------------------------------------------------------*/
250:
251: cursor allops is
252: select operation_sequence_id, request_id
253: from bom_operation_sequences
254: where routing_sequence_id = lCfgRtgId;
255:
256: /* ------------------------------------------------------+
257: cursor added for bugfix 1906371 and 1935580 to select
259: +--------------------------------------------------------*/
260:
261: cursor get_op_seq_num (pRtgId number) is
262: select distinct operation_seq_num,nvl(operation_type,1)
263: from bom_operation_sequences_temp -- 5336292
264: where config_routing_id=pRtgId; -- bugfix 3239267: replaced last_update_login
265:
266: -- 5336292
267: cursor bos_temp (pRtgId number ) is
265:
266: -- 5336292
267: cursor bos_temp (pRtgId number ) is
268: select operation_sequence_id,routing_sequence_id,operation_seq_num,config_routing_id
269: from bom_operation_sequences_temp
270: where config_routing_id=pRtgId;
271:
272: d_op_seq_id bom_operation_sequences_temp.operation_sequence_id%TYPE;
273: d_rtg_seq_id bom_operation_sequences_temp.routing_sequence_id%TYPE;
268: select operation_sequence_id,routing_sequence_id,operation_seq_num,config_routing_id
269: from bom_operation_sequences_temp
270: where config_routing_id=pRtgId;
271:
272: d_op_seq_id bom_operation_sequences_temp.operation_sequence_id%TYPE;
273: d_rtg_seq_id bom_operation_sequences_temp.routing_sequence_id%TYPE;
274: d_op_seq_num bom_operation_sequences_temp.operation_seq_num%TYPE;
275: d_cfg_rtg_id bom_operation_sequences_temp.config_routing_id%TYPE;
276:
269: from bom_operation_sequences_temp
270: where config_routing_id=pRtgId;
271:
272: d_op_seq_id bom_operation_sequences_temp.operation_sequence_id%TYPE;
273: d_rtg_seq_id bom_operation_sequences_temp.routing_sequence_id%TYPE;
274: d_op_seq_num bom_operation_sequences_temp.operation_seq_num%TYPE;
275: d_cfg_rtg_id bom_operation_sequences_temp.config_routing_id%TYPE;
276:
277:
270: where config_routing_id=pRtgId;
271:
272: d_op_seq_id bom_operation_sequences_temp.operation_sequence_id%TYPE;
273: d_rtg_seq_id bom_operation_sequences_temp.routing_sequence_id%TYPE;
274: d_op_seq_num bom_operation_sequences_temp.operation_seq_num%TYPE;
275: d_cfg_rtg_id bom_operation_sequences_temp.config_routing_id%TYPE;
276:
277:
278: v_program_id bom_cto_order_lines.program_id%type;
271:
272: d_op_seq_id bom_operation_sequences_temp.operation_sequence_id%TYPE;
273: d_rtg_seq_id bom_operation_sequences_temp.routing_sequence_id%TYPE;
274: d_op_seq_num bom_operation_sequences_temp.operation_seq_num%TYPE;
275: d_cfg_rtg_id bom_operation_sequences_temp.config_routing_id%TYPE;
276:
277:
278: v_program_id bom_cto_order_lines.program_id%type;
279:
706: /********************************************************************
707: NEW GFSI CODE 5336292
708: ********************************************************************/
709:
710: -- Insert eligible rows into bom_operation_sequences_temp
711: -- Note : We are not selecting distinct of ( operation_seq_num,operation_type,routing_sequence_id )
712: -- since bom_operation_sequences has operation_seq_num,operation_type,routing_sequence_id,eff_date
713: -- as unique combination key and eff_date is used in the where clause of select
714:
708: ********************************************************************/
709:
710: -- Insert eligible rows into bom_operation_sequences_temp
711: -- Note : We are not selecting distinct of ( operation_seq_num,operation_type,routing_sequence_id )
712: -- since bom_operation_sequences has operation_seq_num,operation_type,routing_sequence_id,eff_date
713: -- as unique combination key and eff_date is used in the where clause of select
714:
715:
716:
718: l_batch_id := bom_import_pub.get_batchid;
719:
720: --1st insert
721: lStmtNum := 51;
722: insert into bom_operation_sequences_temp
723: (
724: operation_sequence_id,
725: routing_sequence_id,
726: config_routing_id, -- 5336292
837: y_coordinate
838: FROM bom_cto_order_lines bcol1,
839: mtl_system_items si1,
840: bom_operational_routings or1,
841: bom_operation_sequences os1
842: WHERE bcol1.line_id = pLineId
843: AND bcol1.inventory_item_id = pModelId
844: AND si1.organization_id = pOrgId -- this is the mfg org from src_orgs
845: AND si1.inventory_item_id = bcol1.inventory_item_id
873: End if;
874:
875: --2nd insert
876: lStmtNum := 52;
877: insert into bom_operation_sequences_temp
878: (
879: operation_sequence_id,
880: routing_sequence_id,
881: config_routing_id, -- 5336292
998: mtl_system_items msi,
999: bom_inventory_components ic1,
1000: bom_bill_of_materials b1,
1001: bom_operational_routings or1,
1002: bom_operation_sequences os1
1003: WHERE bcol1.parent_ato_line_id = pLineId /*AP*/
1004: AND bcol1.item_type_code in ('CLASS','OPTION')
1005: AND bcol1.line_id <> bcol2.line_id
1006: -- bugfix 2382396 and bcol2.parent_ato_line_id = bcol1.parent_ato_line_id /*AP*/
1079: --one-to-many BOM components to Rtg operations
1080: AND os1.option_dependent_flag = 1
1081: AND nvl(os1.operation_type,1) = 1
1082: and operation_sequence_id not in(select operation_sequence_id
1083: from bom_operation_sequences_temp);
1084:
1085: If PG_DEBUG <> 0 Then
1086: oe_debug_pub.add('Number of Model option dependent operations selected = '||sql%rowcount,1);
1087: End if;
1086: oe_debug_pub.add('Number of Model option dependent operations selected = '||sql%rowcount,1);
1087: End if;
1088: --3rdnd insert
1089: lStmtNum := 53;
1090: insert into bom_operation_sequences_temp
1091: (
1092: operation_sequence_id,
1093: routing_sequence_id,
1094: config_routing_id, -- 5336292
1204: os1.implementation_date,
1205: x_coordinate,
1206: y_coordinate
1207: -- 5336292
1208: FROM bom_operation_sequences os1,
1209: bom_operational_routings or1,
1210: mtl_system_items si2,
1211: bom_inventory_components ic1,
1212: bom_bill_of_materials b1,
1266: )
1267: /* one-to-many BOM components to Rtg operations */
1268: AND nvl(os1.operation_type,1) = 1
1269: and operation_sequence_id not in(select operation_sequence_id
1270: from bom_operation_sequences_temp);
1271:
1272:
1273:
1274: If PG_DEBUG <> 0 Then
1319: oe_debug_pub.add ('create_routing_ml: ' || 'Esitmated release date lEstRelDate '|| to_char(lEstRelDate,'mm-dd-yy:hh:mi:ss'),2 );
1320: END IF;
1321:
1322: select max(routing_sequence_id) into lmodrtgseqid
1323: from bom_operation_sequences_temp -- 5336292
1324: where operation_seq_num = lmodseqnum
1325: and nvl(operation_type,1)= lmodtyp
1326: and config_routing_id = lCfgRtgId -- bugfix 3239267: replaced last_update_login
1327: and last_update_date = glast_update_date; -- 3180827
1329: IF PG_DEBUG <> 0 THEN
1330: oe_debug_pub.add ('create_routing_ml: ' || ' Max. Routing Seq Id : ' || lmodrtgseqid,2);
1331: END IF;
1332:
1333: update bom_operation_sequences_temp -- 5336292
1334: set config_routing_id = lmodnewCfgRtgId -- bugfix 3239267: replaced last_update_login
1335: where operation_seq_num = lmodseqnum
1336: and nvl(operation_type,1)= lmodtyp
1337: and routing_sequence_id=lmodrtgseqid
1387:
1388: lStmtNum := 60;
1389:
1390: IF PG_DEBUG <> 0 THEN
1391: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_sequences - 1st insert ..',5);
1392: END IF;
1393:
1394: insert into bom_operation_sequences
1395: (
1390: IF PG_DEBUG <> 0 THEN
1391: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_sequences - 1st insert ..',5);
1392: END IF;
1393:
1394: insert into bom_operation_sequences
1395: (
1396: operation_sequence_id,
1397: routing_sequence_id,
1398: operation_seq_num,
1449: x_coordinate, --bugfix 1765149
1450: y_coordinate --bugfix 1765149
1451: )
1452: select
1453: bom_operation_sequences_s.nextval, /* operation_sequence_id */
1454: lcfgrtgid, /* routing_sequence_id */
1455: os1.operation_seq_num,
1456: sysdate, /* last update date */
1457: gUserId, /* last updated by */
1505: trunc(sysdate), -- new column for 11.5.4 BOM patchset
1506: os1.x_coordinate, --bugfix 1765149
1507: os1.y_coordinate --bugfix 1765149
1508: from
1509: bom_operation_sequences_temp os1 -- 5336292
1510: where os1.config_routing_id = lmodnewcfgrtgid ; /*Bugfix 1935580 - change lCfgRtgId to lmodnewCfgRtgId */
1511: -- bugfix 3239267: replaced last_update_login
1512:
1513:
1523: +---------------------------------------------------------------*/
1524:
1525: -- 5336292 : Instead of update we will delete rows
1526: lStmtNum := 70;
1527: delete from bom_operation_sequences_temp
1528: where config_routing_id in (lCfgRtgId, lmodnewcfgrtgid);
1529:
1530: IF PG_DEBUG <> 0 THEN
1531: oe_debug_pub.add('create_routing_ml: ' || 'Deleted ' || sql%rowcount || ' rows from temp table',2);
1562: l_batch_id := bom_import_pub.get_batchid;
1563:
1564: --1st insert
1565: lStmtNum := 81;
1566: insert into bom_operation_sequences_temp
1567: ( operation_sequence_id,
1568: routing_sequence_id,
1569: config_routing_id, -- 5336292
1570: operation_seq_num,
1679: y_coordinate
1680: FROM mtl_system_items si1,
1681: bom_cto_order_lines bcol,
1682: bom_operational_routings or1,
1683: bom_operation_sequences os1
1684: WHERE bcol.parent_ato_line_id = pLineId
1685: AND si1.organization_id = pOrgId
1686: AND si1.inventory_item_id = bcol.inventory_item_id
1687: AND
1725: End if;
1726: --2nd insert
1727: lStmtNum := 82;
1728:
1729: insert into bom_operation_sequences_temp
1730: ( operation_sequence_id,
1731: routing_sequence_id,
1732: config_routing_id, -- 5336292
1733: operation_seq_num,
1845: bom_cto_order_lines bcol2, /* parents model */
1846: bom_inventory_components ic1,
1847: bom_bill_of_materials b1,
1848: bom_operational_routings or1,
1849: bom_operation_sequences os1
1850: WHERE bcol1.parent_ato_line_id = pLineId
1851: AND bcol1.item_type_code in ('CLASS','OPTION')
1852: AND bcol2.parent_ato_line_id = pLineId
1853: AND bcol2.line_id <> pLineId /*AP*/
1923: /* one-to-many BOM components to Rtg operations */
1924: AND os1.option_dependent_flag = 1
1925: AND nvl(os1.operation_type,1) = 1
1926: and operation_sequence_id not in(select operation_sequence_id
1927: from bom_operation_sequences_temp);
1928:
1929:
1930: If PG_DEBUG <> 0 Then
1931: oe_debug_pub.add('Number of option class option dependent operations selected = '||sql%rowcount,1);
1932: End if;
1933: --3rd insert
1934: lStmtNum := 83;
1935:
1936: insert into bom_operation_sequences_temp
1937: ( operation_sequence_id,
1938: routing_sequence_id,
1939: config_routing_id, -- 5336292
1940: operation_seq_num,
2048: os1.implementation_date,
2049: x_coordinate,
2050: y_coordinate
2051:
2052: FROM bom_operation_sequences os1,
2053: bom_operational_routings or1,
2054: mtl_system_items si2,
2055: bom_inventory_components ic1,
2056: bom_bill_of_materials b1,
2114: )
2115: /* one-to-many BOM components to Rtg operations */
2116: AND nvl(os1.operation_type,1) = 1
2117: and operation_sequence_id not in(select operation_sequence_id
2118: from bom_operation_sequences_temp);
2119:
2120: If PG_DEBUG <> 0 Then
2121: oe_debug_pub.add('Number of option class mandatory comps dependent operations selected = '||sql%rowcount,1);
2122: End if;
2161: oe_debug_pub.add ('create_routing_ml: ' || ' Op Seq # : ' || lopseqnum || ' Op Type : ' || loptyp ,2);
2162: END IF;
2163:
2164: select max(routing_sequence_id) into lrtgseqid
2165: from bom_operation_sequences_temp -- 5336292
2166: where operation_seq_num = lopseqnum
2167: and nvl(operation_type,1)= loptyp
2168: and config_routing_id=lCfgRtgId -- bugfix 3239267: replaced last_update_login
2169: and last_update_date = glast_update_date; -- 3180827
2172: IF PG_DEBUG <> 0 THEN
2173: oe_debug_pub.add ('create_routing_ml: ' || ' Max. Routing Seq Id : ' || lrtgseqid,2);
2174: END IF;
2175:
2176: update bom_operation_sequences_temp -- 5336292
2177: set config_routing_id = lnewCfgRtgId -- bugfix 3239267: replaced last_update_login
2178: where operation_seq_num = lopseqnum
2179: and nvl(operation_type,1)= loptyp
2180: and routing_sequence_id=lrtgseqid
2230:
2231: lStmtNum := 90;
2232:
2233: IF PG_DEBUG <> 0 THEN
2234: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_sequences - 2nd insert ..',5);
2235: END IF;
2236:
2237: insert into bom_operation_sequences
2238: (
2233: IF PG_DEBUG <> 0 THEN
2234: oe_debug_pub.add ('create_routing_ml: ' || 'Inserting into bom_operation_sequences - 2nd insert ..',5);
2235: END IF;
2236:
2237: insert into bom_operation_sequences
2238: (
2239: operation_sequence_id,
2240: routing_sequence_id,
2241: operation_seq_num,
2292: x_coordinate, --bugfix 1765149
2293: y_coordinate --bugfix 1765149
2294: )
2295: select
2296: bom_operation_sequences_s.nextval, /* operation_sequence_id */
2297: lcfgrtgid, /* routing_sequence_id */
2298: os1.operation_seq_num,
2299: sysdate, /* last update date */
2300: gUserId, /* last updated by */
2348: trunc(sysdate), -- new column for 11.5.4 BOM patchset
2349: os1.x_coordinate, --bugfix 1765149
2350: os1.y_coordinate --bugfix 1765149
2351: from
2352: bom_operation_sequences_temp os1
2353: where os1.config_routing_id = lnewCfgRtgId /*Bugfix 1906371 - change lCfgRtgId to lnewCfgRtgId */
2354: -- bugfix 3239267: replaced last_update_login
2355: and os1.operation_seq_num not in (
2356: select operation_seq_num
2353: where os1.config_routing_id = lnewCfgRtgId /*Bugfix 1906371 - change lCfgRtgId to lnewCfgRtgId */
2354: -- bugfix 3239267: replaced last_update_login
2355: and os1.operation_seq_num not in (
2356: select operation_seq_num
2357: from bom_operation_sequences bos1
2358: where bos1.routing_sequence_id = lCfgRtgId
2359: /* Bugfix 1983384 where bos1.last_update_login = lnewCfgRtgId */
2360: and nvl(bos1.operation_type,1) = nvl(os1.operation_type,1));
2361:
2367:
2368: -- New update of 3180827
2369: lStmtNum := 95;
2370: lStmtNum := 95;
2371: delete from bom_operation_sequences_temp
2372: where config_routing_id in (lCfgRtgId, lmodnewcfgrtgid);
2373:
2374: /*-------------------------------------------------------------------+
2375: Now update the process_op_seq_id and line_seq_id of
2377: Old operation_sequence_ids are available in request_id
2378: +-------------------------------------------------------------------*/
2379:
2380: lStmtNum := 100;
2381: xTableName := 'BOM_OPERATION_SEQUENCES';
2382: -- bug 6087687: Events from option class routing operations also need to
2383: -- be linked to operations on config routing.
2384: /***********************************************************************
2385: update bom_operation_sequences bos1
2381: xTableName := 'BOM_OPERATION_SEQUENCES';
2382: -- bug 6087687: Events from option class routing operations also need to
2383: -- be linked to operations on config routing.
2384: /***********************************************************************
2385: update bom_operation_sequences bos1
2386: set process_op_seq_id = (
2387: select operation_sequence_id
2388: from bom_operation_sequences bos2
2389: where bos1.process_op_seq_id = bos2.request_id
2384: /***********************************************************************
2385: update bom_operation_sequences bos1
2386: set process_op_seq_id = (
2387: select operation_sequence_id
2388: from bom_operation_sequences bos2
2389: where bos1.process_op_seq_id = bos2.request_id
2390: and bos2.routing_sequence_id = lCfgRtgId)
2391: where bos1.operation_type = 1
2392: and bos1.routing_sequence_id = lCfgRtgId;
2391: where bos1.operation_type = 1
2392: and bos1.routing_sequence_id = lCfgRtgId;
2393:
2394: lStmtNum := 110;
2395: update bom_operation_sequences bos1
2396: set line_op_seq_id = (
2397: select operation_sequence_id
2398: from bom_operation_sequences bos2
2399: where bos1.line_op_seq_id = bos2.request_id
2394: lStmtNum := 110;
2395: update bom_operation_sequences bos1
2396: set line_op_seq_id = (
2397: select operation_sequence_id
2398: from bom_operation_sequences bos2
2399: where bos1.line_op_seq_id = bos2.request_id
2400: and bos2.routing_sequence_id = lCfgRtgId)
2401: where bos1.operation_type = 1
2402: and bos1.routing_sequence_id = lCfgRtgId;
2401: where bos1.operation_type = 1
2402: and bos1.routing_sequence_id = lCfgRtgId;
2403: ***************************************************************************/
2404:
2405: update bom_operation_sequences bos1
2406: set line_op_seq_id = (
2407: select bos2.operation_sequence_id
2408: from bom_operation_sequences bos2,
2409: bom_operation_sequences bos3
2404:
2405: update bom_operation_sequences bos1
2406: set line_op_seq_id = (
2407: select bos2.operation_sequence_id
2408: from bom_operation_sequences bos2,
2409: bom_operation_sequences bos3
2410: where bos3.operation_sequence_id = bos1.line_op_seq_id
2411: and bos2.routing_sequence_id = lCfgRtgId
2412: and bos3.operation_seq_num = bos2.operation_seq_num
2405: update bom_operation_sequences bos1
2406: set line_op_seq_id = (
2407: select bos2.operation_sequence_id
2408: from bom_operation_sequences bos2,
2409: bom_operation_sequences bos3
2410: where bos3.operation_sequence_id = bos1.line_op_seq_id
2411: and bos2.routing_sequence_id = lCfgRtgId
2412: and bos3.operation_seq_num = bos2.operation_seq_num
2413: and bos2.operation_type = 3)
2414: where bos1.operation_type = 1
2415: and bos1.routing_sequence_id = lCfgRtgId;
2416:
2417: lStmtNum := 110;
2418: update bom_operation_sequences bos1
2419: set process_op_seq_id = (
2420: select bos2.operation_sequence_id
2421: from bom_operation_sequences bos2,
2422: bom_operation_sequences bos3
2417: lStmtNum := 110;
2418: update bom_operation_sequences bos1
2419: set process_op_seq_id = (
2420: select bos2.operation_sequence_id
2421: from bom_operation_sequences bos2,
2422: bom_operation_sequences bos3
2423: where bos3.operation_sequence_id = bos1.process_op_seq_id
2424: and bos2.routing_sequence_id = lCfgRtgId
2425: and bos3.operation_seq_num = bos2.operation_seq_num
2418: update bom_operation_sequences bos1
2419: set process_op_seq_id = (
2420: select bos2.operation_sequence_id
2421: from bom_operation_sequences bos2,
2422: bom_operation_sequences bos3
2423: where bos3.operation_sequence_id = bos1.process_op_seq_id
2424: and bos2.routing_sequence_id = lCfgRtgId
2425: and bos3.operation_seq_num = bos2.operation_seq_num
2426: and bos2.operation_type = 2)
2440:
2441: delete from BOM_OPERATIONAL_ROUTINGS b1
2442: where b1.routing_sequence_id not in
2443: (select routing_sequence_id
2444: from bom_operation_sequences )
2445: and b1.routing_sequence_id = lCfgRtgId;
2446:
2447: if sql%rowcount > 0 then
2448: IF PG_DEBUG <> 0 THEN
2465: set ci.operation_seq_num = 1
2466: where not exists
2467: (select 'op seq exists in config routing'
2468: from
2469: bom_operation_sequences bos,
2470: bom_operational_routings bor
2471: where bos.operation_seq_num = ci.operation_seq_num
2472: and bos.routing_sequence_id = bor.routing_sequence_id
2473: and bor.assembly_item_id = pConfigId
2650: bor.substitute_group_num,
2651: bor.setup_id, /* Bugfix2950774 */
2652: bor.principle_flag
2653: from
2654: bom_operation_sequences osi,
2655: bom_operation_resources bor
2656: where osi.routing_sequence_id = lCfgRtgId
2657: and osi.request_id = bor.operation_sequence_id;
2658: /* request_id contains model op seq_id now */
2758: NULL, /*program_application_id*/
2759: NULL, /*program_id*/
2760: NULL /*program_update_date*/
2761: from
2762: bom_operation_sequences osi,
2763: bom_sub_operation_resources bsor
2764: where osi.routing_sequence_id = lCfgRtgId
2765: and osi.request_id = bsor.operation_sequence_id;
2766: /* request_id contains model op seq_id now */
2832: bon.ATTRIBUTE13,
2833: bon.ATTRIBUTE14,
2834: bon.ATTRIBUTE15
2835: FROM bom_operation_networks bon,
2836: bom_operation_sequences bos1, /* 'from' Ops of model */
2837: bom_operation_sequences bos2, /* 'to' Ops of model */
2838: bom_operation_sequences bos3, /* 'from' Ops of config */
2839: bom_operation_sequences bos4, /* 'to' Ops of config */
2840: bom_operational_routings brif
2833: bon.ATTRIBUTE14,
2834: bon.ATTRIBUTE15
2835: FROM bom_operation_networks bon,
2836: bom_operation_sequences bos1, /* 'from' Ops of model */
2837: bom_operation_sequences bos2, /* 'to' Ops of model */
2838: bom_operation_sequences bos3, /* 'from' Ops of config */
2839: bom_operation_sequences bos4, /* 'to' Ops of config */
2840: bom_operational_routings brif
2841: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
2834: bon.ATTRIBUTE15
2835: FROM bom_operation_networks bon,
2836: bom_operation_sequences bos1, /* 'from' Ops of model */
2837: bom_operation_sequences bos2, /* 'to' Ops of model */
2838: bom_operation_sequences bos3, /* 'from' Ops of config */
2839: bom_operation_sequences bos4, /* 'to' Ops of config */
2840: bom_operational_routings brif
2841: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
2842: AND bon.to_op_seq_id = bos2.operation_sequence_id
2835: FROM bom_operation_networks bon,
2836: bom_operation_sequences bos1, /* 'from' Ops of model */
2837: bom_operation_sequences bos2, /* 'to' Ops of model */
2838: bom_operation_sequences bos3, /* 'from' Ops of config */
2839: bom_operation_sequences bos4, /* 'to' Ops of config */
2840: bom_operational_routings brif
2841: WHERE bon.from_op_seq_id = bos1.operation_sequence_id
2842: AND bon.to_op_seq_id = bos2.operation_sequence_id
2843: AND bos1.routing_sequence_id = bos2.routing_sequence_id
2885:
2886: lstmtNum := 400;
2887:
2888: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
2889: X_from_entity_name =>'BOM_OPERATION_SEQUENCES',
2890: X_from_pk1_value =>nextop.request_id,
2891: X_from_pk2_value =>'',
2892: X_from_pk3_value =>'',
2893: X_from_pk4_value =>'',
2891: X_from_pk2_value =>'',
2892: X_from_pk3_value =>'',
2893: X_from_pk4_value =>'',
2894: X_from_pk5_value =>'',
2895: X_to_entity_name =>'BOM_OPERATION_SEQUENCES',
2896: X_to_pk1_value =>nextop.operation_sequence_id,
2897: X_to_pk2_value =>'',
2898: X_to_pk3_value =>'',
2899: X_to_pk4_value =>'',
2991: and alternate_routing_designator is null
2992: and organization_id = pOrgId
2993: and serialization_start_op in
2994: (Select OPERATION_SEQ_NUM
2995: from bom_operation_sequences
2996: where routing_sequence_id = lCfgRtgId
2997: );
2998: EXCEPTION
2999: WHEN no_data_found THEN
3025: and bill_sequence_id = pCfgBillId
3026: )
3027: and serialization_start_op in
3028: (Select OPERATION_SEQ_NUM
3029: from bom_operation_sequences
3030: where routing_sequence_id = lCfgRtgId
3031: )--serial start op exists as a operation in routing(ie effective oper)
3032: )
3033: where assembly_item_id = pConfigId