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: -- Bugfix 14270815: Sourcing rules should get created for CIB = 1,2 configs

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

171: and bcso.reference_id is null
172: UNION
173: select bcso.rcv_org_id, bcso.organization_id, bcol.config_creation, bcso.create_src_rules
174: , bcso.inventory_item_id, bcso.config_item_id
175: from bom_cto_order_lines bcol, bom_cto_src_orgs bcso, bom_cto_model_orgs bcmo
176: where bcol.ato_line_id = pTopAtoLineId
177: and bcol.bom_item_type = '1' and nvl( bcol.wip_supply_type , 1 ) <> '6'
178: and bcol.option_specific = 'N'
179: and bcol.line_id = bcso.line_id

Line 212: from bom_cto_order_lines

208: ship_from_org_id,
209: perform_match,
210: config_item_id,
211: config_creation, plan_level , link_to_line_id
212: from bom_cto_order_lines
213: where top_model_line_id = pTopAtoLineId;
214:
215:
216: BEGIN

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

223:
224: if( p_mode = 'AUTOCONFIG' ) then
225:
226:
227: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
228: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
229:
230: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
231:

Line 228: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;

224: if( p_mode = 'AUTOCONFIG' ) then
225:
226:
227: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
228: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
229:
230: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
231:
232:

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

226:
227: delete /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
228: from bom_cto_order_lines_gt where ato_line_id = pTopAtoLineId ;
229:
230: oe_debug_pub.add( ' Deleted from bom_cto_order_lines_gt ' || SQL%ROWCOUNT , 1 ) ;
231:
232:
233: begin
234:

Line 237: where exists ( select line_id from bom_cto_order_lines

233: begin
234:
235: select 'Y' into v_bcol_data_exists
236: from dual
237: where exists ( select line_id from bom_cto_order_lines
238: where line_id = pTopAtoLineId ) ;
239:
240:
241:

Line 257: -- populate bom_cto_order_lines

253:
254:
255:
256: --
257: -- populate bom_cto_order_lines
258: -- populating bcol using ato_line_id instead of top_model_line_id
259: -- change to support multiple ATO models under a PTO model
260: --
261:

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

270:
271: if( p_mode = 'AUTOCONFIG' ) then
272:
273:
274: -- delete from bom_cto_order_lines where ato_line_id = pTopAtoLineId ;
275:
276: IF PG_DEBUG <> 0 THEN
277: oe_debug_pub.add('Create_And_Link_Item: ' || ' deleted ' || SQL%ROWCOUNT ||
278: ' from bcol ' || to_char(pTopAtoLineId), 2);

Line 329: update bom_cto_order_lines

325:
326:
327: oe_debug_pub.add( 'came into PRECONFIG UPDATE BCOL QUERY ' , 1 ) ;
328:
329: update bom_cto_order_lines
330: set perform_match = 'Y'
331: where ato_line_id = pTopAtoLineId
332: and inventory_item_id in
333: ( select inventory_item_id

Line 334: from bom_cto_order_lines

330: set perform_match = 'Y'
331: where ato_line_id = pTopAtoLineId
332: and inventory_item_id in
333: ( select inventory_item_id
334: from bom_cto_order_lines
335: where ato_line_id = pTopAtoLineId
336: and bom_item_type = '1'
337: and wip_supply_type <> 6
338: and perform_match = 'U'

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

372: END IF; --Bugfix 6642016
373:
374: if ( nvl(lReuseProfile,1) = 1 ) then ----Bugfix 6642016
375:
376: select count(*) into v_reuse_bcol_count from bom_cto_order_lines
377: where ato_line_id = pTopAtoLineId ;
378:
379:
380: IF PG_DEBUG <> 0 THEN

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

401:
402:
403: /* Bug 3441482 */
404: begin
405: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
406: bcol.ship_from_org_id , bcolgt.ship_from_org_id
407: into v_bcol_ship_from_org_id, v_bcolgt_ship_from_org_id
408: from bom_cto_order_lines bcol, bom_cto_order_lines_gt bcolgt
409: where bcol.line_id = bcolgt.line_id and bcol.line_id = pTopAtoLineId ;

Line 408: from bom_cto_order_lines bcol, bom_cto_order_lines_gt bcolgt

404: begin
405: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
406: bcol.ship_from_org_id , bcolgt.ship_from_org_id
407: into v_bcol_ship_from_org_id, v_bcolgt_ship_from_org_id
408: from bom_cto_order_lines bcol, bom_cto_order_lines_gt bcolgt
409: where bcol.line_id = bcolgt.line_id and bcol.line_id = pTopAtoLineId ;
410:
411: exception
412: when others then

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

428: l_oss_check_reqd := 1;
429: end if;
430:
431: /* Bug 3441482 */
432: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
433: bom_cto_order_lines_gt bcolgt set option_specific =
434: ( select option_specific from bom_cto_order_lines bcol
435: where bcolgt.line_id = bcol.line_id )
436: where bcolgt.ato_line_id = pTopAtoLineId ;

Line 433: bom_cto_order_lines_gt bcolgt set option_specific =

429: end if;
430:
431: /* Bug 3441482 */
432: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
433: bom_cto_order_lines_gt bcolgt set option_specific =
434: ( select option_specific from bom_cto_order_lines bcol
435: where bcolgt.line_id = bcol.line_id )
436: where bcolgt.ato_line_id = pTopAtoLineId ;
437:

Line 434: ( select option_specific from bom_cto_order_lines bcol

430:
431: /* Bug 3441482 */
432: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
433: bom_cto_order_lines_gt bcolgt set option_specific =
434: ( select option_specific from bom_cto_order_lines bcol
435: where bcolgt.line_id = bcol.line_id )
436: where bcolgt.ato_line_id = pTopAtoLineId ;
437:
438:

Line 447: delete from bom_cto_order_lines where ato_line_id = pTopAtoLineId ;

443:
444:
445: /* delete from bcol */
446:
447: delete from bom_cto_order_lines where ato_line_id = pTopAtoLineId ;
448:
449: IF PG_DEBUG <> 0 THEN
450: oe_debug_pub.add('Create_And_Link_Item: ' ||
451: ' deleting from bcol ' || to_char(sql%rowcount) , 5);

Line 458: insert into bom_cto_order_lines (

454: lStmtNum := 30 ;
455:
456: /* copy bcol_temp data to bcol */
457:
458: insert into bom_cto_order_lines (
459: LINE_ID
460: ,HEADER_ID
461: ,TOP_MODEL_LINE_ID
462: ,LINK_TO_LINE_ID

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

487: ,REUSE_CONFIG
488: ,OPTION_SPECIFIC
489: ,QTY_PER_PARENT_MODEL
490: ,CONFIG_CREATION)
491: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
492: LINE_ID
493: ,HEADER_ID
494: ,TOP_MODEL_LINE_ID
495: ,LINK_TO_LINE_ID

Line 524: from bom_cto_order_lines_gt

520: ,REUSE_CONFIG
521: ,nvl( option_specific, 'N' )
522: ,QTY_PER_PARENT_MODEL
523: ,CONFIG_CREATION
524: from bom_cto_order_lines_gt
525: where ato_line_id = pTopAtoLineId ;
526: /* add ods and reuse flag */
527:
528: IF PG_DEBUG <> 0 THEN

Line 543: insert into bom_cto_order_lines_gt (

539:
540: oe_debug_pub.add('Create_And_Link_Item: ' || 'copy bcol to bcol_gt ', 5);
541: /* copy bcol data to bcol_temp for matching */
542:
543: insert into bom_cto_order_lines_gt (
544: LINE_ID
545: ,HEADER_ID
546: ,TOP_MODEL_LINE_ID
547: ,LINK_TO_LINE_ID

Line 611: from bom_cto_order_lines

607: ,OPTION_SPECIFIC
608: ,QTY_PER_PARENT_MODEL
609: ,CONFIG_CREATION
610: ,SHIP_FROM_ORG_ID --for bugfix3555026
611: from bom_cto_order_lines
612: where ato_line_id = pTopAtoLineId ;
613:
614: oe_debug_pub.add('Create_And_Link_Item: ' || ' copied bcol to bcol gt rows ' || SQL%ROWCOUNT , 5);
615: end if ; /* bcol data exists */

Line 630: from bom_cto_order_lines

626:
627: begin
628: select reuse_config, config_item_id , config_creation
629: into v_reuse_config_flag, v_reuse_config_item_id , v_reuse_config_creation
630: from bom_cto_order_lines
631: where line_id = pTopAtoLineId ;
632:
633: IF PG_DEBUG <> 0 THEN
634: oe_debug_pub.add('Create_And_Link_Item: ' ||

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

817:
818:
819: lStmtNum := 55 ;
820:
821: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
822: perform_match , config_item_id into x_match_found , x_top_matched_item_id
823: from bom_cto_order_lines_gt
824: where line_id = pTopAtoLineId ;
825:

Line 823: from bom_cto_order_lines_gt

819: lStmtNum := 55 ;
820:
821: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
822: perform_match , config_item_id into x_match_found , x_top_matched_item_id
823: from bom_cto_order_lines_gt
824: where line_id = pTopAtoLineId ;
825:
826:
827: oe_debug_pub.add( 'CREATE_AND_LINK_ITEM:: perform match data ' ||

Line 851: update bom_cto_order_lines bcol

847: oe_debug_pub.add('Create_And_Link_Item: ' || ' Going to Synch up BCOL with data from BCOL_GT for matched info ' , 5);
848:
849:
850:
851: update bom_cto_order_lines bcol
852: set ( bcol.perform_match, bcol.config_item_id ) =
853: ( select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
854: bcol_gt.perform_match, bcol_gt.config_item_id
855: from bom_cto_order_lines_gt bcol_gt

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

849:
850:
851: update bom_cto_order_lines bcol
852: set ( bcol.perform_match, bcol.config_item_id ) =
853: ( select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
854: bcol_gt.perform_match, bcol_gt.config_item_id
855: from bom_cto_order_lines_gt bcol_gt
856: where bcol.line_id = bcol_gt.line_id )
857: where bcol.ato_line_id = pTopAtoLineId ;

Line 855: from bom_cto_order_lines_gt bcol_gt

851: update bom_cto_order_lines bcol
852: set ( bcol.perform_match, bcol.config_item_id ) =
853: ( select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
854: bcol_gt.perform_match, bcol_gt.config_item_id
855: from bom_cto_order_lines_gt bcol_gt
856: where bcol.line_id = bcol_gt.line_id )
857: where bcol.ato_line_id = pTopAtoLineId ;
858:
859:

Line 1249: from bom_cto_order_lines

1245: inventory_item_id,
1246: config_item_id,
1247: parent_ato_line_id,
1248: config_creation
1249: from bom_cto_order_lines
1250: where ato_line_id = pTopAtoLineId
1251: and ( bom_item_type = '1' )
1252: and nvl(wip_supply_type,0) <> '6'
1253: order by plan_level desc; -- added order by clause for wt/vol project

Line 1279: v_bcmo_config_orgs bom_cto_order_lines.config_creation%type ;

1275:
1276: v_bcso_group_reference_id number ;
1277:
1278:
1279: v_bcmo_config_orgs bom_cto_order_lines.config_creation%type ;
1280:
1281: v_model_item_status number ;
1282: v_config_item_status number ;
1283: l_token CTO_MSG_PUB.token_tbl;

Line 1359: from bom_cto_order_lines

1355: /* check for perform match flag */
1356:
1357: select perform_match
1358: into v_perform_match
1359: from bom_cto_order_lines
1360: where line_id = v_model_lines.line_id;
1361:
1362:
1363: oe_debug_pub.add ('Create_All_items: ' || 'perform_match ' || v_perform_match , 1);

Line 1508: update bom_cto_order_lines

1504: if (v_parent_ato_line_id = v_ato_line_id or v_update_count = 0 ) then
1505: exit;
1506: end if;
1507:
1508: update bom_cto_order_lines
1509: set perform_match = 'U' /* Unsuccessful Match */
1510: where line_id = v_parent_ato_line_id
1511: and perform_match = 'Y'
1512: returning parent_ato_line_id , ato_line_id

Line 1533: update bom_cto_order_lines

1529: else /* Match Found */
1530:
1531: /* update matched config in bcol and bcol_temp */
1532:
1533: update bom_cto_order_lines
1534: set config_item_id = lXConfigId
1535: where line_id = v_model_lines.line_id
1536: returning config_creation into v_bcmo_config_orgs ;
1537:

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

1544: || ' config_orgs ' || v_bcmo_config_orgs
1545: || ' rows ' || SQL%ROWCOUNT, 1);
1546:
1547:
1548: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1549: bom_cto_order_lines_gt
1550: set config_item_id = lXConfigId
1551: where line_id = v_model_lines.line_id ;
1552:

Line 1549: bom_cto_order_lines_gt

1545: || ' rows ' || SQL%ROWCOUNT, 1);
1546:
1547:
1548: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1549: bom_cto_order_lines_gt
1550: set config_item_id = lXConfigId
1551: where line_id = v_model_lines.line_id ;
1552:
1553: oe_debug_pub.add ('Create_All_items: ' || 'updated bcol_gt ' || lXConfigId

Line 1697: update bom_cto_order_lines

1693:
1694:
1695: /* update newly created config in bcol and bcol_temp */
1696:
1697: update bom_cto_order_lines
1698: set config_item_id = lXConfigId
1699: where line_id = v_model_lines.line_id
1700: returning perform_match into v_perform_match;
1701:

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

1705:
1706:
1707: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);
1708:
1709: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1710: bom_cto_order_lines_gt
1711: set config_item_id = lXConfigId
1712: where line_id = v_model_lines.line_id ;
1713:

Line 1710: bom_cto_order_lines_gt

1706:
1707: oe_debug_pub.add('Create_All_Items: ' || 'V_PERFORM_MATCH IS ::'|| v_perform_match, 1);
1708:
1709: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1710: bom_cto_order_lines_gt
1711: set config_item_id = lXConfigId
1712: where line_id = v_model_lines.line_id ;
1713:
1714:

Line 1886: update bom_cto_order_lines

1882:
1883:
1884: /* update newly created config in bcol and bcol_temp */
1885:
1886: update bom_cto_order_lines
1887: set config_item_id = lXConfigId
1888: where line_id = v_model_lines.line_id ;
1889:
1890:

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

1892: || ' for ' || v_model_lines.line_id , 1);
1893:
1894:
1895:
1896: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1897: bom_cto_order_lines_gt
1898: set config_item_id = lXConfigId
1899: where line_id = v_model_lines.line_id ;
1900:

Line 1897: bom_cto_order_lines_gt

1893:
1894:
1895:
1896: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
1897: bom_cto_order_lines_gt
1898: set config_item_id = lXConfigId
1899: where line_id = v_model_lines.line_id ;
1900:
1901:

Line 2018: update bom_cto_order_lines

2014:
2015:
2016: /* update newly created config in bcol and bcol_temp */
2017:
2018: update bom_cto_order_lines
2019: set config_item_id = lXConfigId
2020: where line_id = v_model_lines.line_id ;
2021:
2022:

Line 2106: p_ato_line_id in bom_cto_order_lines.ato_line_id%type ,

2102: END Create_All_Items;
2103:
2104:
2105: procedure perform_match(
2106: p_ato_line_id in bom_cto_order_lines.ato_line_id%type ,
2107: x_match_found out NOCOPY varchar2,
2108: x_matching_config_id out NOCOPY number,
2109: x_error_message out NOCOPY VARCHAR2,
2110: x_message_name out NOCOPY varchar2

Line 2149: from bom_cto_order_lines

2145:
2146:
2147: cursor c_model_lines is
2148: select line_id, parent_ato_line_id
2149: from bom_cto_order_lines
2150: where bom_item_type = '1'
2151: and ato_line_id = p_ato_line_id
2152: and nvl(wip_supply_type,0) <> 6
2153: order by plan_level desc;

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

2163: begin
2164:
2165:
2166:
2167: select count(*) into v_bcol_count from bom_cto_order_lines
2168: where ato_line_id = p_ato_line_id ;
2169:
2170:
2171: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */

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

2167: select count(*) into v_bcol_count from bom_cto_order_lines
2168: where ato_line_id = p_ato_line_id ;
2169:
2170:
2171: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
2172: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt
2173: where ato_line_id = p_ato_line_id ;
2174:
2175:

Line 2172: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt

2168: where ato_line_id = p_ato_line_id ;
2169:
2170:
2171: select /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_N1) */
2172: count(*) into v_bcol_gt_count from bom_cto_order_lines_gt
2173: where ato_line_id = p_ato_line_id ;
2174:
2175:
2176: oe_debug_pub.add( ' perform_match bcol count ' || v_bcol_count , 1 ) ;

Line 2196: from bom_cto_order_lines

2192:
2193:
2194:
2195: select perform_match into l_perform_match
2196: from bom_cto_order_lines
2197: where line_id = l_next_rec.line_id ;
2198:
2199:
2200: oe_debug_pub.add( ' perform_match: line_id ' || l_next_rec.line_id || ' match ' || l_perform_match , 1 ) ;

Line 2207: update bom_cto_order_lines set perform_match = 'U'

2203: if( l_perform_match = 'U' ) then
2204:
2205: begin
2206:
2207: update bom_cto_order_lines set perform_match = 'U'
2208: where perform_match = 'Y'
2209: and line_id = l_next_rec.parent_ato_line_id ;
2210:
2211: exception

Line 2282: update bom_cto_order_lines

2278:
2279:
2280: /* update the perform match column to 'U' so that this item is canned */
2281: begin
2282: update bom_cto_order_lines
2283: set perform_match = 'U'
2284: where line_id = l_next_rec.line_id
2285: and perform_match = 'Y';
2286:

Line 2300: update bom_cto_order_lines

2296: is attempted against its parent and it is canned
2297: */
2298:
2299: begin
2300: update bom_cto_order_lines
2301: set perform_match = 'U'
2302: where line_id = l_next_rec.parent_ato_line_id
2303: and perform_match = 'Y';
2304:

Line 2326: update bom_cto_order_lines

2322: || to_char(l_next_rec.line_id)
2323: || ' is ' || to_char(l_x_config_id) ,1);
2324:
2325:
2326: update bom_cto_order_lines
2327: set config_item_id = l_x_config_id
2328: where line_id = l_next_rec.line_id;
2329:
2330:

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

2330:
2331:
2332: oe_debug_pub.add( 'perform_match: bcol update ' || SQL%rowcount , 1 ) ;
2333:
2334: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2335: bom_cto_order_lines_gt
2336: set config_item_id = l_x_config_id
2337: where line_id = l_next_rec.line_id;
2338:

Line 2335: bom_cto_order_lines_gt

2331:
2332: oe_debug_pub.add( 'perform_match: bcol update ' || SQL%rowcount , 1 ) ;
2333:
2334: update /*+ INDEX (BOM_CTO_ORDER_LINES_GT BOM_CTO_ORDER_LINES_GT_U1) */
2335: bom_cto_order_lines_gt
2336: set config_item_id = l_x_config_id
2337: where line_id = l_next_rec.line_id;
2338:
2339:

Line 2398: from bom_cto_order_lines

2394:
2395: cursor c_item_behavior
2396: is
2397: select config_creation , line_id , parent_ato_line_id
2398: from bom_cto_order_lines
2399: where ato_line_id = p_ato_line_id
2400: and bom_item_type = '1' and nvl(wip_supply_type, 1 ) <> 6
2401: order by plan_level desc ;
2402:

Line 2404: v_config_creation bom_cto_order_lines.config_creation%type ;

2400: and bom_item_type = '1' and nvl(wip_supply_type, 1 ) <> 6
2401: order by plan_level desc ;
2402:
2403:
2404: v_config_creation bom_cto_order_lines.config_creation%type ;
2405: v_line_id number ;
2406: v_parent_ato_line_id number ;
2407: v_last_config_creation bom_cto_order_lines.config_creation%type ;
2408:

Line 2407: v_last_config_creation bom_cto_order_lines.config_creation%type ;

2403:
2404: v_config_creation bom_cto_order_lines.config_creation%type ;
2405: v_line_id number ;
2406: v_parent_ato_line_id number ;
2407: v_last_config_creation bom_cto_order_lines.config_creation%type ;
2408:
2409:
2410: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;
2411:

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

2406: v_parent_ato_line_id number ;
2407: v_last_config_creation bom_cto_order_lines.config_creation%type ;
2408:
2409:
2410: TYPE TAB_BCOL is TABLE of bom_cto_order_lines%rowtype index by binary_integer ;
2411:
2412: item_behavior_violated exception ;
2413:
2414: t_bcol TAB_BCOL ;