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.CTO_ITEM_PK dependencies on BOM_CTO_ORDER_LINES

Line 100: p_ato_line_id in bom_cto_order_lines.ato_line_id%type ,

96: g_bom_org_list CTO_OSS_SOURCE_PK.bom_org_list_tab ; /* line_id, inventory_item_id, org_id */
97:
98: /*
99: procedure perform_match(
100: p_ato_line_id in bom_cto_order_lines.ato_line_id%type ,
101: x_match_found out NOCOPY varchar2,
102: x_matching_config_id out NOCOPY number,
103: x_error_message out NOCOPY VARCHAR2,
104: x_message_name out NOCOPY varchar2

Line 149: from bom_cto_order_lines bcol, bom_cto_src_orgs bcso

145:
146: cursor c_copy_src_rules IS
147: select bcso.rcv_org_id, bcso.organization_id, bcol.config_creation, bcso.create_src_rules
148: , bcso.model_item_id , bcso.config_item_id
149: from bom_cto_order_lines bcol, bom_cto_src_orgs bcso
150: where bcol.ato_line_id = pTopAtoLineId
151: and bcol.bom_item_type = '1' and nvl( bcol.wip_supply_type , 1 ) <> '6'
152: and bcol.option_specific = 'N'
153: and bcol.line_id = bcso.line_id ; /*Do not copy sourcing assignments for OSS Items*/

Line 160: from bom_cto_order_lines bcol, bom_cto_src_orgs bcso, bom_cto_model_orgs bcmo

156: and bcso.reference_id is null
157: UNION
158: select bcso.rcv_org_id, bcso.organization_id, bcol.config_creation, bcso.create_src_rules
159: , bcso.inventory_item_id, bcso.config_item_id
160: from bom_cto_order_lines bcol, bom_cto_src_orgs bcso, bom_cto_model_orgs bcmo
161: where bcol.ato_line_id = pTopAtoLineId
162: and bcol.bom_item_type = '1' and nvl( bcol.wip_supply_type , 1 ) <> '6'
163: and bcol.option_specific = 'N'
164: and bcol.line_id = bcso.line_id

Line 197: from bom_cto_order_lines

193: ship_from_org_id,
194: perform_match,
195: config_item_id,
196: config_creation, plan_level , link_to_line_id
197: from bom_cto_order_lines
198: where top_model_line_id = pTopAtoLineId;
199:
200:
201: BEGIN

Line 212: delete /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) /

208:
209: if( p_mode = 'AUTOCONFIG' ) then
210:
211:
212: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
213: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
214:
215: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
216:

Line 213: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;

209: if( p_mode = 'AUTOCONFIG' ) then
210:
211:
212: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
213: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
214:
215: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
216:
217:

Line 215: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;

211:
212: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
213: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
214:
215: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
216:
217:
218: begin
219:

Line 222: where exists ( select line_id from bom_cto_order_lines

218: begin
219:
220: select 'Y' into v_bcol_data_exists
221: from dual
222: where exists ( select line_id from bom_cto_order_lines
223: where line_id = pTopAtoLineId ) ;
224:
225:
226:

Line 242: -- populate bom_cto_order_lines

238:
239:
240:
241: --
242: -- populate bom_cto_order_lines
243: -- populating bcol using ato_line_id instead of top_model_line_id
244: -- change to support multiple ATO models under a PTO model
245: --
246:

Line 259: -- delete from bom_cto_order_lines where ato_line_id = pTopAtoLineId ;

255:
256: if( p_mode = 'AUTOCONFIG' ) then
257:
258:
259: -- delete from bom_cto_order_lines where ato_line_id = pTopAtoLineId ;
260:
261: IF PG_DEBUG <> 0 THEN
262: oe_debug_pub.add('Create_And_Link_Item: ' || ' deleted ' || SQL%ROWCOUNT ||
263: ' from bcol ' || to_char(pTopAtoLineId), 2);

Line 314: update bom_cto_order_lines

310:
311:
312: oe_debug_pub.add( 'came into PRECONFIG UPDATE BCOL QUERY ' , 1 ) ;
313:
314: update bom_cto_order_lines
315: set perform_match = 'Y'
316: where ato_line_id = pTopAtoLineId
317: and inventory_item_id in
318: ( select inventory_item_id

Line 319: from bom_cto_order_lines

315: set perform_match = 'Y'
316: where ato_line_id = pTopAtoLineId
317: and inventory_item_id in
318: ( select inventory_item_id
319: from bom_cto_order_lines
320: where ato_line_id = pTopAtoLineId
321: and bom_item_type = '1'
322: and wip_supply_type <> 6
323: and perform_match = 'U'

Line 361: select count(*) into v_reuse_bcol_count from bom_cto_order_lines

357: END IF; --Bugfix 6642016
358:
359: if ( nvl(lReuseProfile,1) = 1 ) then ----Bugfix 6642016
360:
361: select count(*) into v_reuse_bcol_count from bom_cto_order_lines
362: where ato_line_id = pTopAtoLineId ;
363:
364:
365: IF PG_DEBUG <> 0 THEN

Line 390: select /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

386:
387:
388: /* Bug 3441482 */
389: begin
390: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
391: bcol.ship_from_org_id , bcolgt.ship_from_org_id
392: into v_bcol_ship_from_org_id, v_bcolgt_ship_from_org_id
393: from bom_cto_order_lines bcol, bom_cto_order_lines_gt bcolgt
394: where bcol.line_id = bcolgt.line_id and bcol.line_id = pTopAtoLineId ;

Line 393: from bom_cto_order_lines bcol, bom_cto_order_lines_gt bcolgt

389: begin
390: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
391: bcol.ship_from_org_id , bcolgt.ship_from_org_id
392: into v_bcol_ship_from_org_id, v_bcolgt_ship_from_org_id
393: from bom_cto_order_lines bcol, bom_cto_order_lines_gt bcolgt
394: where bcol.line_id = bcolgt.line_id and bcol.line_id = pTopAtoLineId ;
395:
396: exception
397: when others then

Line 412: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) /

408: , 5);
409: END IF;
410:
411: /* Bug 3441482 */
412: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
413: bom_cto_order_lines_gt bcolgt set option_specific =
414: ( select option_specific from bom_cto_order_lines bcol
415: where bcolgt.line_id = bcol.line_id )
416: where bcolgt.ato_line_id = pTopAtoLineId ;

Line 413: bom_cto_order_lines_gt bcolgt set option_specific =

409: END IF;
410:
411: /* Bug 3441482 */
412: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
413: bom_cto_order_lines_gt bcolgt set option_specific =
414: ( select option_specific from bom_cto_order_lines bcol
415: where bcolgt.line_id = bcol.line_id )
416: where bcolgt.ato_line_id = pTopAtoLineId ;
417:

Line 414: ( select option_specific from bom_cto_order_lines bcol

410:
411: /* Bug 3441482 */
412: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
413: bom_cto_order_lines_gt bcolgt set option_specific =
414: ( select option_specific from bom_cto_order_lines bcol
415: where bcolgt.line_id = bcol.line_id )
416: where bcolgt.ato_line_id = pTopAtoLineId ;
417:
418:

Line 427: delete from bom_cto_order_lines where ato_line_id = pTopAtoLineId ;

423:
424:
425: /* delete from bcol */
426:
427: delete from bom_cto_order_lines where ato_line_id = pTopAtoLineId ;
428:
429: IF PG_DEBUG <> 0 THEN
430: oe_debug_pub.add('Create_And_Link_Item: ' ||
431: ' deleting from bcol ' || to_char(sql%rowcount) , 5);

Line 438: insert into bom_cto_order_lines (

434: lStmtNum := 30 ;
435:
436: /* copy bcol_temp data to bcol */
437:
438: insert into bom_cto_order_lines (
439: LINE_ID
440: ,HEADER_ID
441: ,TOP_MODEL_LINE_ID
442: ,LINK_TO_LINE_ID

Line 471: select /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) /

467: ,REUSE_CONFIG
468: ,OPTION_SPECIFIC
469: ,QTY_PER_PARENT_MODEL
470: ,CONFIG_CREATION)
471: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
472: LINE_ID
473: ,HEADER_ID
474: ,TOP_MODEL_LINE_ID
475: ,LINK_TO_LINE_ID

Line 504: from bom_cto_order_lines_gt

500: ,REUSE_CONFIG
501: ,nvl( option_specific, 'N' )
502: ,QTY_PER_PARENT_MODEL
503: ,CONFIG_CREATION
504: from bom_cto_order_lines_gt
505: where ato_line_id = pTopAtoLineId ;
506: /* add ods and reuse flag */
507:
508: IF PG_DEBUG <> 0 THEN

Line 523: insert into bom_cto_order_lines_gt (

519:
520: oe_debug_pub.add('Create_And_Link_Item: ' || 'copy bcol to bcol_gt ', 5);
521: /* copy bcol data to bcol_temp for matching */
522:
523: insert into bom_cto_order_lines_gt (
524: LINE_ID
525: ,HEADER_ID
526: ,TOP_MODEL_LINE_ID
527: ,LINK_TO_LINE_ID

Line 591: from bom_cto_order_lines

587: ,OPTION_SPECIFIC
588: ,QTY_PER_PARENT_MODEL
589: ,CONFIG_CREATION
590: ,SHIP_FROM_ORG_ID --for bugfix3555026
591: from bom_cto_order_lines
592: where ato_line_id = pTopAtoLineId ;
593:
594: oe_debug_pub.add('Create_And_Link_Item: ' || ' copied bcol to bcol gt rows ' || SQL%ROWCOUNT , 5);
595: end if ; /* bcol data exists */

Line 610: from bom_cto_order_lines

606:
607: begin
608: select reuse_config, config_item_id , config_creation
609: into v_reuse_config_flag, v_reuse_config_item_id , v_reuse_config_creation
610: from bom_cto_order_lines
611: where line_id = pTopAtoLineId ;
612:
613: IF PG_DEBUG <> 0 THEN
614: oe_debug_pub.add('Create_And_Link_Item: ' ||

Line 767: select /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

763:
764:
765: lStmtNum := 55 ;
766:
767: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
768: perform_match , config_item_id into x_match_found , x_top_matched_item_id
769: from bom_cto_order_lines_gt
770: where line_id = pTopAtoLineId ;
771:

Line 769: from bom_cto_order_lines_gt

765: lStmtNum := 55 ;
766:
767: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
768: perform_match , config_item_id into x_match_found , x_top_matched_item_id
769: from bom_cto_order_lines_gt
770: where line_id = pTopAtoLineId ;
771:
772:
773: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM:: perform match data ' ||

Line 797: update bom_cto_order_lines bcol

793: oe_debug_pub.add('Create_And_Link_Item: ' || ' Going to Synch up BCOL with data from BCOL_GT for matched info ' , 5);
794:
795:
796:
797: update bom_cto_order_lines bcol
798: set ( bcol.perform_match, bcol.config_item_id ) =
799: ( select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
800: bcol_gt.perform_match, bcol_gt.config_item_id
801: from bom_cto_order_lines_gt bcol_gt

Line 799: ( select /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

795:
796:
797: update bom_cto_order_lines bcol
798: set ( bcol.perform_match, bcol.config_item_id ) =
799: ( select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
800: bcol_gt.perform_match, bcol_gt.config_item_id
801: from bom_cto_order_lines_gt bcol_gt
802: where bcol.line_id = bcol_gt.line_id )
803: where bcol.ato_line_id = pTopAtoLineId ;

Line 801: from bom_cto_order_lines_gt bcol_gt

797: update bom_cto_order_lines bcol
798: set ( bcol.perform_match, bcol.config_item_id ) =
799: ( select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
800: bcol_gt.perform_match, bcol_gt.config_item_id
801: from bom_cto_order_lines_gt bcol_gt
802: where bcol.line_id = bcol_gt.line_id )
803: where bcol.ato_line_id = pTopAtoLineId ;
804:
805:

Line 1192: from bom_cto_order_lines

1188: inventory_item_id,
1189: config_item_id,
1190: parent_ato_line_id,
1191: config_creation
1192: from bom_cto_order_lines
1193: where ato_line_id = pTopAtoLineId
1194: and ( bom_item_type = '1' )
1195: and nvl(wip_supply_type,0) <> '6'
1196: order by plan_level desc; -- added order by clause for wt/vol project

Line 1222: v_bcmo_config_orgs bom_cto_order_lines.config_creation%type ;

1218:
1219: v_bcso_group_reference_id number ;
1220:
1221:
1222: v_bcmo_config_orgs bom_cto_order_lines.config_creation%type ;
1223:
1224: v_model_item_status number ;
1225: v_config_item_status number ;
1226: l_token CTO_MSG_PUB.token_tbl;

Line 1302: from bom_cto_order_lines

1298: /* check for perform match flag */
1299:
1300: select perform_match
1301: into v_perform_match
1302: from bom_cto_order_lines
1303: where line_id = v_model_lines.line_id;
1304:
1305:
1306: oe_debug_pub.add ('Create_All_items: ' || 'perform_match ' || v_perform_match , 1);

Line 1451: update bom_cto_order_lines

1447: if (v_parent_ato_line_id = v_ato_line_id or v_update_count = 0 ) then
1448: exit;
1449: end if;
1450:
1451: update bom_cto_order_lines
1452: set perform_match = 'U' /* Unsuccessful Match */
1453: where line_id = v_parent_ato_line_id
1454: and perform_match = 'Y'
1455: returning parent_ato_line_id , ato_line_id

Line 1476: update bom_cto_order_lines

1472: else /* Match Found */
1473:
1474: /* update matched config in bcol and bcol_temp */
1475:
1476: update bom_cto_order_lines
1477: set config_item_id = lXConfigId
1478: where line_id = v_model_lines.line_id
1479: returning config_creation into v_bcmo_config_orgs ;
1480:

Line 1491: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

1487: || ' config_orgs ' || v_bcmo_config_orgs
1488: || ' rows ' || SQL%ROWCOUNT, 1);
1489:
1490:
1491: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1492: bom_cto_order_lines_gt
1493: set config_item_id = lXConfigId
1494: where line_id = v_model_lines.line_id ;
1495:

Line 1492: bom_cto_order_lines_gt

1488: || ' rows ' || SQL%ROWCOUNT, 1);
1489:
1490:
1491: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1492: bom_cto_order_lines_gt
1493: set config_item_id = lXConfigId
1494: where line_id = v_model_lines.line_id ;
1495:
1496: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId

Line 1640: update bom_cto_order_lines

1636:
1637:
1638: /* update newly created config in bcol and bcol_temp */
1639:
1640: update bom_cto_order_lines
1641: set config_item_id = lXConfigId
1642: where line_id = v_model_lines.line_id
1643: returning perform_match into v_perform_match;
1644:

Line 1652: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

1648:
1649:
1650: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);
1651:
1652: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1653: bom_cto_order_lines_gt
1654: set config_item_id = lXConfigId
1655: where line_id = v_model_lines.line_id ;
1656:

Line 1653: bom_cto_order_lines_gt

1649:
1650: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);
1651:
1652: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1653: bom_cto_order_lines_gt
1654: set config_item_id = lXConfigId
1655: where line_id = v_model_lines.line_id ;
1656:
1657:

Line 1826: update bom_cto_order_lines

1822:
1823:
1824: /* update newly created config in bcol and bcol_temp */
1825:
1826: update bom_cto_order_lines
1827: set config_item_id = lXConfigId
1828: where line_id = v_model_lines.line_id ;
1829:
1830:

Line 1836: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

1832: || ' for ' || v_model_lines.line_id , 1);
1833:
1834:
1835:
1836: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1837: bom_cto_order_lines_gt
1838: set config_item_id = lXConfigId
1839: where line_id = v_model_lines.line_id ;
1840:

Line 1837: bom_cto_order_lines_gt

1833:
1834:
1835:
1836: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1837: bom_cto_order_lines_gt
1838: set config_item_id = lXConfigId
1839: where line_id = v_model_lines.line_id ;
1840:
1841:

Line 1958: update bom_cto_order_lines

1954:
1955:
1956: /* update newly created config in bcol and bcol_temp */
1957:
1958: update bom_cto_order_lines
1959: set config_item_id = lXConfigId
1960: where line_id = v_model_lines.line_id ;
1961:
1962:

Line 2038: p_ato_line_id in bom_cto_order_lines.ato_line_id%type ,

2034: END Create_All_Items;
2035:
2036:
2037: procedure perform_match(
2038: p_ato_line_id in bom_cto_order_lines.ato_line_id%type ,
2039: x_match_found out NOCOPY varchar2,
2040: x_matching_config_id out NOCOPY number,
2041: x_error_message out NOCOPY VARCHAR2,
2042: x_message_name out NOCOPY varchar2

Line 2081: from bom_cto_order_lines

2077:
2078:
2079: cursor c_model_lines is
2080: select line_id, parent_ato_line_id
2081: from bom_cto_order_lines
2082: where bom_item_type = '1'
2083: and ato_line_id = p_ato_line_id
2084: and nvl(wip_supply_type,0) <> 6
2085: order by plan_level desc;

Line 2099: select count(*) into v_bcol_count from bom_cto_order_lines

2095: begin
2096:
2097:
2098:
2099: select count(*) into v_bcol_count from bom_cto_order_lines
2100: where ato_line_id = p_ato_line_id ;
2101:
2102:
2103: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */

Line 2103: select /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) /

2099: select count(*) into v_bcol_count from bom_cto_order_lines
2100: where ato_line_id = p_ato_line_id ;
2101:
2102:
2103: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
2104: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt
2105: where ato_line_id = p_ato_line_id ;
2106:
2107:

Line 2104: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt

2100: where ato_line_id = p_ato_line_id ;
2101:
2102:
2103: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
2104: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt
2105: where ato_line_id = p_ato_line_id ;
2106:
2107:
2108: oe_debug_pub.add( ' perform_match bcol count ' || v_bcol_count , 1 ) ;

Line 2128: from bom_cto_order_lines

2124:
2125:
2126:
2127: select perform_match into l_perform_match
2128: from bom_cto_order_lines
2129: where line_id = l_next_rec.line_id ;
2130:
2131:
2132: oe_debug_pub.add( ' perform_match: line_id ' || l_next_rec.line_id || ' match ' || l_perform_match , 1 ) ;

Line 2139: update bom_cto_order_lines set perform_match = 'U'

2135: if( l_perform_match = 'U' ) then
2136:
2137: begin
2138:
2139: update bom_cto_order_lines set perform_match = 'U'
2140: where perform_match = 'Y'
2141: and line_id = l_next_rec.parent_ato_line_id ;
2142:
2143: exception

Line 2214: update bom_cto_order_lines

2210:
2211:
2212: /* update the perform match column to 'U' so that this item is canned */
2213: begin
2214: update bom_cto_order_lines
2215: set perform_match = 'U'
2216: where line_id = l_next_rec.line_id
2217: and perform_match = 'Y';
2218:

Line 2232: update bom_cto_order_lines

2228: is attempted against its parent and it is canned
2229: */
2230:
2231: begin
2232: update bom_cto_order_lines
2233: set perform_match = 'U'
2234: where line_id = l_next_rec.parent_ato_line_id
2235: and perform_match = 'Y';
2236:

Line 2258: update bom_cto_order_lines

2254: || to_char(l_next_rec.line_id)
2255: || ' is ' || to_char(l_x_config_id) ,1);
2256:
2257:
2258: update bom_cto_order_lines
2259: set config_item_id = l_x_config_id
2260: where line_id = l_next_rec.line_id;
2261:
2262:

Line 2266: update /+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) /

2262:
2263:
2264: oe_debug_pub.add( 'perform_match: bcol update ' || SQL%rowcount , 1 ) ;
2265:
2266: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2267: bom_cto_order_lines_gt
2268: set config_item_id = l_x_config_id
2269: where line_id = l_next_rec.line_id;
2270:

Line 2267: bom_cto_order_lines_gt

2263:
2264: oe_debug_pub.add( 'perform_match: bcol update ' || SQL%rowcount , 1 ) ;
2265:
2266: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2267: bom_cto_order_lines_gt
2268: set config_item_id = l_x_config_id
2269: where line_id = l_next_rec.line_id;
2270:
2271:

Line 2330: from bom_cto_order_lines

2326:
2327: cursor c_item_behavior
2328: is
2329: select config_creation , line_id , parent_ato_line_id
2330: from bom_cto_order_lines
2331: where ato_line_id = p_ato_line_id
2332: and bom_item_type = '1' and nvl(wip_supply_type, 1 ) <> 6
2333: order by plan_level desc ;
2334:

Line 2336: v_config_creation bom_cto_order_lines.config_creation%type ;

2332: and bom_item_type = '1' and nvl(wip_supply_type, 1 ) <> 6
2333: order by plan_level desc ;
2334:
2335:
2336: v_config_creation bom_cto_order_lines.config_creation%type ;
2337: v_line_id number ;
2338: v_parent_ato_line_id number ;
2339: v_last_config_creation bom_cto_order_lines.config_creation%type ;
2340:

Line 2339: v_last_config_creation bom_cto_order_lines.config_creation%type ;

2335:
2336: v_config_creation bom_cto_order_lines.config_creation%type ;
2337: v_line_id number ;
2338: v_parent_ato_line_id number ;
2339: v_last_config_creation bom_cto_order_lines.config_creation%type ;
2340:
2341:
2342: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;
2343:

Line 2342: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;

2338: v_parent_ato_line_id number ;
2339: v_last_config_creation bom_cto_order_lines.config_creation%type ;
2340:
2341:
2342: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;
2343:
2344: item_behavior_violated exception ;
2345:
2346: t_bcol TAB_BCOL ;