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_MATCH_CONFIG dependencies on BOM_CTO_ORDER_LINES

Line 192: from bom_cto_order_lines

188:
189: cursor c_model_lines is
190: --select perform_match, line_id, parent_ato_line_id, inventory_item_id
191: select line_id, parent_ato_line_id, inventory_item_id
192: from bom_cto_order_lines
193: where bom_item_type = 1
194: --and top_model_line_id = pModelLineId -- top model
195: and ato_line_id = pModelLineId
196: and nvl(wip_supply_type,0) <> 6

Line 226: This is the loop that traverses bom_cto_order_lines

222: oe_debug_pub.add('match_and_create_all_items: ' || 'CUSTOM_MATCH: ' || l_custom_match_profile, 1);
223: END IF;
224:
225: /*-----------------------------------------------------+
226: This is the loop that traverses bom_cto_order_lines
227: to match each configured assembly. If an assembly
228: does not have a match, a new item is created. If
229: it does have a match, we make create that item
230: in all the sourcing organizations if it does not exist.

Line 238: from bom_cto_order_lines

234: lXConfigId := NULL;
235:
236: select perform_match
237: into lPerformMatch
238: from bom_cto_order_lines
239: where line_id = lNextRec.line_id;
240:
241: IF PG_DEBUG <> 0 THEN
242: oe_debug_pub.add('match_and_create_all_items: ' || 'Match_and_create_all_items: Processing line_id '

Line 331: update bom_cto_order_lines

327: if (lStatus = 1) then
328:
329: begin
330:
331: update bom_cto_order_lines
332: set perform_match = 'N'
333: where line_id = lNextRec.parent_ato_line_id
334: and perform_match = 'Y';
335: -- if the update fails, its not an error

Line 478: update bom_cto_order_lines

474: end if;
475:
476: begin
477:
478: update bom_cto_order_lines
479: set perform_match = 'N'
480: where line_id = lNextRec.parent_ato_line_id
481: and perform_match = 'Y';
482: -- if the update fails, its not an error

Line 568: update bom_cto_order_lines

564:
565: end if; -- end lNextRec.Perform_match
566:
567: lStmtNum := 160;
568: update bom_cto_order_lines
569: set config_item_id = lXConfigId
570: where line_id = lNextRec.line_id;
571:
572: end loop;

Line 634: bom_cto_order_lines, the condition

630:
631: Bugfix 1553467 : If an ATO model is part of a PTO model (see fig below),
632: then, the link_to_line_id of ATO model will be the line_id of
633: the PTO model. Since the PTO options are not inserted in
634: bom_cto_order_lines, the condition
635: "and colp.line_id = nvl(col1.link_to_line_id, col1.line_id)"
636: will fail.
637: Removed "colp" from the FROM clause and added a new condition after
638: commenting the old. Search on 1553467.

Line 723: from bom_cto_order_lines_gt

719: inventory_item_id
720: )
721: )
722: into l_component_count, l_component_sum
723: from bom_cto_order_lines_gt
724: where parent_ato_line_id = p_model_line_id
725: or line_id = p_model_line_id;
726:
727:

Line 732: from bom_cto_order_lines_gt

728:
729: l_stmt_num := 120;
730: select inventory_item_id
731: into l_base_model_id
732: from bom_cto_order_lines_gt
733: where line_id = p_model_line_id;
734:
735: IF PG_DEBUG <> 0 THEN
736: oe_debug_pub.add('l_component_count = '||l_component_count ||' l_component_sum = '||l_component_sum);

Line 811: from bom_cto_order_lines_gt col1, /* model */

807: -- If the config item is INACTIVE in even one orgn, we will not consider that configuration for matching.
808:
809: select /*+ ordered */ bac1.config_item_id -- 6086540: added the ordered hint
810: into x_config_match_id
811: from bom_cto_order_lines_gt col1, /* model */
812: bom_ato_configs_temp bact1, --6086540: use the GTT for filtering based on approx match
813: bom_ato_configurations bac1 --6086540: matching will be done in main table
814: where col1.line_id = p_model_line_id
815: and bac1.base_model_id = col1.inventory_item_id

Line 829: from bom_cto_order_lines_gt col5

825: and msi.inventory_item_status_code = nvl(bp.bom_delete_status_code,'NULL')
826: )
827: and not exists
828: (select 'Extra Options in Order'
829: from bom_cto_order_lines_gt col5
830: where (col5.parent_ato_line_id = col1.line_id
831: or col5.line_id = col1.line_id) -- to pick up top model
832: and col5.ordered_quantity > 0
833: and nvl(decode(col5.line_id, col1.line_id, col5.inventory_item_id,

Line 859: from bom_cto_order_lines_gt col9

855: not in
856: ( select decode( col1.line_id , col9.line_id, col9.inventory_item_id ,
857: nvl( col9.config_item_id, col9.inventory_item_id )),
858: Round( nvl( col9.ordered_quantity, 0)/nvl( col1.ordered_quantity, 0 ), 7 ) /* Decimal-Qty Support for Option Items */
859: from bom_cto_order_lines_gt col9
860: where col9.parent_ato_line_id = col1.line_id or col9.line_id = col1.line_id
861: )
862: )
863: and rownum = 1;

Line 978: bom_cto_order_lines, the condition

974:
975: Bugfix 1553467 : If an ATO model is part of a PTO model (see fig below),
976: then, the link_to_line_id of ATO model will be the line_id of
977: the PTO model. Since the PTO options are not inserted in
978: bom_cto_order_lines, the condition
979: "and bcolParent.line_id = NVL(bcolModel.link_to_line_id, bcolModel.line_id); "
980: will fail.
981:
982: Removed "bcolParent" from the FROM clause and added a new condition after

Line 1031: FROM bom_cto_order_lines bcol,

1027: l_stmt_num := 10;
1028: BEGIN
1029: SELECT 'Y'
1030: INTO l_ato_flag
1031: FROM bom_cto_order_lines bcol,
1032: mtl_system_items msi
1033: WHERE bcol.line_id = p_model_line_id
1034: AND bcol.config_item_id = msi.inventory_item_id
1035: AND msi.replenish_to_order_flag = 'Y'

Line 1103: -- bugfix 1553467: bom_cto_order_lines bcolParent, /* Parent of Model, if any */

1099: prg_appid,
1100: prg_id,
1101: SYSDATE
1102: from
1103: -- bugfix 1553467: bom_cto_order_lines bcolParent, /* Parent of Model, if any */
1104: bom_cto_order_lines bcolModel, /* Model */
1105: bom_cto_order_lines bcolOptions /* Options */
1106: where bcolModel.line_id = p_model_line_id
1107: and (bcolOptions.parent_ato_line_id = bcolModel.line_id or

Line 1104: bom_cto_order_lines bcolModel, /* Model */

1100: prg_id,
1101: SYSDATE
1102: from
1103: -- bugfix 1553467: bom_cto_order_lines bcolParent, /* Parent of Model, if any */
1104: bom_cto_order_lines bcolModel, /* Model */
1105: bom_cto_order_lines bcolOptions /* Options */
1106: where bcolModel.line_id = p_model_line_id
1107: and (bcolOptions.parent_ato_line_id = bcolModel.line_id or
1108: bcolOptions.line_id = bcolModel.line_id);

Line 1105: bom_cto_order_lines bcolOptions /* Options */

1101: SYSDATE
1102: from
1103: -- bugfix 1553467: bom_cto_order_lines bcolParent, /* Parent of Model, if any */
1104: bom_cto_order_lines bcolModel, /* Model */
1105: bom_cto_order_lines bcolOptions /* Options */
1106: where bcolModel.line_id = p_model_line_id
1107: and (bcolOptions.parent_ato_line_id = bcolModel.line_id or
1108: bcolOptions.line_id = bcolModel.line_id);
1109: --and bcolOptions.ordered_quantity >

Line 1894: from bom_cto_order_lines_gt

1890: IS
1891:
1892: cursor c_model_lines is
1893: select line_id, parent_ato_line_id, inventory_item_id
1894: from bom_cto_order_lines_gt
1895: where bom_item_type = '1'
1896: and ato_line_id = p_ato_line_id
1897: and nvl(wip_supply_type,0) <> 6
1898: and ato_line_id is not null -- could be a PTO

Line 1942: from bom_cto_order_lines_gt

1938: lXConfigId := NULL;
1939: lStmtNum :=20;
1940: select perform_match
1941: into lPerformMatch
1942: from bom_cto_order_lines_gt
1943: where line_id = lNextRec.line_id;
1944:
1945:
1946:

Line 1957: update bom_cto_order_lines_gt

1953:
1954: if (lPerformMatch = 'U') then
1955:
1956: lStmtNum:=30;
1957: update bom_cto_order_lines_gt
1958: set perform_match = 'U'
1959: where line_id = lNextRec.parent_ato_line_id
1960: and perform_match in ('Y','C');
1961: -- if the update fails, its not an error

Line 2076: update bom_cto_order_lines_gt

2072: if (lStatus = 1 and lXConfigId is null) then
2073:
2074:
2075: lStmtNum:=60;
2076: update bom_cto_order_lines_gt
2077: set perform_match = 'U'
2078: where line_id = lNextRec.line_id
2079: and perform_match in ('Y','C');
2080: -- if the update fails, its not an error

Line 2087: update bom_cto_order_lines_gt

2083:
2084: oe_debug_pub.add('perform_match: ' || 'rowcount : ' || to_char(sql%rowcount), 1);
2085:
2086: lStmtNum:=70;
2087: update bom_cto_order_lines_gt
2088: set perform_match = 'U'
2089: where line_id = lNextRec.parent_ato_line_id
2090: and perform_match in ( 'Y','C');
2091: -- if the update fails, its not an error

Line 2101: update bom_cto_order_lines_gt

2097: elsif (lStatus = 1 and lXConfigId is not null) then
2098:
2099:
2100: lStmtNum:=80;
2101: update bom_cto_order_lines_gt
2102: set config_item_id = lXConfigId
2103: where line_id = lNextRec.line_id;
2104:
2105: --

Line 2151: update bom_cto_order_lines_gt

2147:
2148:
2149: /* Fix for bug 3533192 */
2150:
2151: update bom_cto_order_lines_gt
2152: set perform_match = 'Y'
2153: where ato_line_id = p_ato_line_id
2154: and inventory_item_id in
2155: ( select inventory_item_id

Line 2156: from bom_cto_order_lines_gt

2152: set perform_match = 'Y'
2153: where ato_line_id = p_ato_line_id
2154: and inventory_item_id in
2155: ( select inventory_item_id
2156: from bom_cto_order_lines_gt
2157: where ato_line_id = p_ato_line_id
2158: and bom_item_type = '1'
2159: and wip_supply_type <> 6
2160: and perform_match = 'U'

Line 2313: FROM bom_cto_order_lines_gt

2309: CURSOR c_single_ato is
2310: SELECT line_id,
2311: parent_ato_line_id,
2312: reuse_config
2313: FROM bom_cto_order_lines_gt
2314: --added nvl, bugfix 3530054
2315: WHERE nvl(wip_supply_type,1) <>6 --non phantom ato models
2316: AND bom_item_type = '1' --used inverted commas to use index N5
2317: AND ato_line_id = p_ato_line_id;

Line 2324: FROM bom_cto_order_lines_gt

2320: CURSOR c_bulk is
2321: SELECT line_id,
2322: parent_ato_line_id,
2323: reuse_config
2324: FROM bom_cto_order_lines_gt
2325: ----added nvl, bugfix 3530054
2326: WHERE nvl(wip_supply_type,1) <>6 --non phantom
2327: AND bom_item_type = '1' ; --'1' for using idx_N5 --ato models
2328:

Line 2338: FROM bom_cto_order_lines_gt

2334: wip_supply_type,
2335: bom_item_type,
2336: qty_per_parent_model,
2337: reuse_config
2338: FROM bom_cto_order_lines_gt
2339: WHERE ato_line_id = p_ato_line_id;
2340:
2341: CURSOR c_debug is
2342: SELECT

Line 2350: FROM bom_cto_order_lines_gt

2346: qty_per_parent_model,
2347: config_creation,
2348: ship_from_org_id,
2349: validation_org
2350: FROM bom_cto_order_lines_gt
2351: WHERE reuse_config is not null;
2352:
2353:
2354:

Line 2386: UPDATE bom_cto_order_lines_gt

2382: lStmtNum := 20;
2383:
2384:
2385:
2386: UPDATE bom_cto_order_lines_gt
2387: SET reuse_config = 'Y'
2388: WHERE ato_line_id = p_ato_line_id
2389: AND bom_item_type = '1' --'1' uses idx_n5 --identifies non-phantom
2390: --need a nvl as for top most ato model there is no value

Line 2403: FROM bom_cto_order_lines_gt

2399: qty_per_parent_model
2400: BULK COLLECT INTO
2401: l_temp_line_id,
2402: l_qty_per_parent_model
2403: FROM bom_cto_order_lines_gt
2404: WHERE ato_line_id = p_ato_line_id;
2405:
2406: oe_debug_pub.add('LINE_ID >>QTY_PER_PARENT_MODEL',5);
2407:

Line 2442: UPDATE bom_cto_order_lines_gt

2438: END IF;
2439:
2440:
2441: lStmtNum := 40;
2442: UPDATE bom_cto_order_lines_gt
2443: SET reuse_config = 'Y'
2444: WHERE bom_item_type = '1' --used idx_n5 --identifies non-phantom
2445: AND nvl(WIP_SUPPLY_TYPE,1) <> 6;
2446:

Line 2452: FROM bom_cto_order_lines_gt

2448: --returning into cluase doesnot supoort distinct
2449: lStmtNum:=50;
2450: SELECT distinct(ato_line_id)
2451: BULK COLLECT INTO l_ato_line_tbl
2452: FROM bom_cto_order_lines_gt
2453: WHERE top_model_line_id is not null;
2454: END IF;
2455:
2456: l_ato_last_index := l_ato_line_tbl.count;

Line 2474: FROM bom_cto_order_lines bcol,

2470: -- rkaza. 12/06/2005. bug 4520992. Fp'ed bug 4493512.
2471: -- Added hint as per Perf team so that bcolgt drives the query
2472: SELECT /*+ leading(BCGT) use_nl(BCGT BCOL) */ distinct(bcol.ato_line_id)
2473: BULK COLLECT INTO l_bcol_ato_line_tbl
2474: FROM bom_cto_order_lines bcol,
2475: bom_cto_order_lines_gt bcgt
2476: WHERE bcgt.line_id = bcol.line_id
2477: AND bcol.qty_per_parent_model is null;
2478:

Line 2475: bom_cto_order_lines_gt bcgt

2471: -- Added hint as per Perf team so that bcolgt drives the query
2472: SELECT /*+ leading(BCGT) use_nl(BCGT BCOL) */ distinct(bcol.ato_line_id)
2473: BULK COLLECT INTO l_bcol_ato_line_tbl
2474: FROM bom_cto_order_lines bcol,
2475: bom_cto_order_lines_gt bcgt
2476: WHERE bcgt.line_id = bcol.line_id
2477: AND bcol.qty_per_parent_model is null;
2478:
2479: EXCEPTION

Line 2493: UPDATE bom_cto_order_lines child

2489:
2490: END IF;
2491:
2492: FORALL j IN 1..l_bcol_ato_line_tbl.last
2493: UPDATE bom_cto_order_lines child
2494: SET qty_per_parent_model =
2495: --used round to be consistent with can_configuration code
2496: ( SELECT ROUND(child.ordered_quantity/parent.ordered_quantity,7)
2497: FROM bom_cto_order_lines parent

Line 2497: FROM bom_cto_order_lines parent

2493: UPDATE bom_cto_order_lines child
2494: SET qty_per_parent_model =
2495: --used round to be consistent with can_configuration code
2496: ( SELECT ROUND(child.ordered_quantity/parent.ordered_quantity,7)
2497: FROM bom_cto_order_lines parent
2498: WHERE child.parent_ato_line_id= parent.line_id
2499: )
2500: --to filter out ato item order lines
2501: WHERE top_model_line_id is not null

Line 2510: UPDATE bom_cto_order_lines_gt bcol_gt

2506:
2507: --bugfix 3503764
2508: --need config_creation as part of fix 3503764
2509: --in core reuse sql
2510: UPDATE bom_cto_order_lines_gt bcol_gt
2511: SET config_creation =
2512: --used round to be consistent with can_configuration code
2513: ( SELECT nvl(mtl.config_orgs,1)--3555026
2514: FROM mtl_system_items mtl

Line 2527: UPDATE bom_cto_order_lines_gt bcolt

2523:
2524:
2525: lStmtNum := 60;
2526: FORALL i in 1..l_ato_last_index
2527: UPDATE bom_cto_order_lines_gt bcolt
2528: SET bcolt.reuse_config = 'N'
2529: WHERE
2530: line_id in (
2531:

Line 2535: FROM bom_cto_order_lines_gt bcol_gt1,

2531:
2532: --bugfix start 3503764
2533: --if ware house is different then reuse = N
2534: (SELECT bcol_gt1.line_id
2535: FROM bom_cto_order_lines_gt bcol_gt1,
2536: bom_cto_order_lines bcol
2537: WHERE bcol.line_id = l_ato_line_tbl(i)
2538: AND bcol_gt1.config_creation in (1,2)
2539: AND bcol_gt1.ato_line_id = l_ato_line_tbl(i)

Line 2536: bom_cto_order_lines bcol

2532: --bugfix start 3503764
2533: --if ware house is different then reuse = N
2534: (SELECT bcol_gt1.line_id
2535: FROM bom_cto_order_lines_gt bcol_gt1,
2536: bom_cto_order_lines bcol
2537: WHERE bcol.line_id = l_ato_line_tbl(i)
2538: AND bcol_gt1.config_creation in (1,2)
2539: AND bcol_gt1.ato_line_id = l_ato_line_tbl(i)
2540: AND bcol_gt1.ship_from_org_id <> bcol.ship_from_org_id

Line 2548: from bom_cto_order_lines_gt bcolt1

2544: --end bugfix 3503764
2545:
2546: UNION
2547: ( Select parent_ato_line_id
2548: from bom_cto_order_lines_gt bcolt1
2549: Where (bcolt1.line_id,
2550: bcolt1.qty_per_parent_model,
2551: bcolt1.inventory_item_id)
2552: not in ( Select line_id,

Line 2555: from bom_cto_order_lines

2551: bcolt1.inventory_item_id)
2552: not in ( Select line_id,
2553: qty_per_parent_model,
2554: inventory_item_id
2555: from bom_cto_order_lines
2556: where ato_line_id = l_ato_line_tbl(i) )
2557: --filters out pure ato item lines
2558: AND bcolt1.top_model_line_id is not null
2559: AND bcolt1.ato_line_id = l_ato_line_tbl(i)

Line 2564: from bom_cto_order_lines bcol2

2560: )
2561: -- bugfix 3381658 start
2562: UNION
2563: (Select parent_ato_line_id
2564: from bom_cto_order_lines bcol2
2565: Where (bcol2.line_id,
2566: bcol2.qty_per_parent_model,
2567: bcol2.inventory_item_id)
2568: not in ( Select bcolgt.line_id,

Line 2571: from bom_cto_order_lines_gt bcolgt

2567: bcol2.inventory_item_id)
2568: not in ( Select bcolgt.line_id,
2569: bcolgt.qty_per_parent_model,
2570: bcolgt.inventory_item_id
2571: from bom_cto_order_lines_gt bcolgt
2572: where ato_line_id = l_ato_line_tbl(i) )
2573: --filters out pure ato item lines
2574: AND bcol2.top_model_line_id is not null
2575: AND bcol2.ato_line_id = l_ato_line_tbl(i)

Line 2679: UPDATE bom_cto_order_lines_gt

2675:
2676: END LOOP;
2677:
2678: FORALL i in g_model_line_tbl.FIRST..g_model_line_tbl.LAST
2679: UPDATE bom_cto_order_lines_gt
2680: SET reuse_config = 'N'
2681: WHERE line_id = g_model_line_tbl(i);
2682: END IF;--g_model_line exists
2683:

Line 2709: UPDATE /+ INDEX (bcolt BOM_CTO_ORDER_LINES_GT_N5) /bom_cto_order_lines_gt bcolt

2705: --SQL statement which accesses other tables.
2706: --In such cases, the join order may not be optimal due to the lack
2707: --of stats on the temp table, hence hints should be used to ensure the optimal join order.
2708:
2709: UPDATE /*+ INDEX (bcolt BOM_CTO_ORDER_LINES_GT_N5) */bom_cto_order_lines_gt bcolt
2710: SET bcolt.config_item_id =
2711: (SELECT bcol.config_item_id
2712: FROM bom_cto_order_lines bcol
2713: WHERE bcolt.line_id = bcol.line_id

Line 2712: FROM bom_cto_order_lines bcol

2708:
2709: UPDATE /*+ INDEX (bcolt BOM_CTO_ORDER_LINES_GT_N5) */bom_cto_order_lines_gt bcolt
2710: SET bcolt.config_item_id =
2711: (SELECT bcol.config_item_id
2712: FROM bom_cto_order_lines bcol
2713: WHERE bcolt.line_id = bcol.line_id
2714: )
2715: WHERE bcolt.bom_item_type = '1'--used idx_n5
2716: AND nvl(bcolt.WIP_SUPPLY_TYPE,1) <>6

Line 2728: UPDATE /+ INDEX (bcolt BOM_CTO_ORDER_LINES_GT_N5) /bom_cto_order_lines_gt bcolt

2724: --SQL statement which accesses other tables.
2725: --In such cases, the join order may not be optimal due to the lack
2726: --of stats on the temp table, hence hints should be used to ensure the optimal join order.
2727:
2728: UPDATE /*+ INDEX (bcolt BOM_CTO_ORDER_LINES_GT_N5) */bom_cto_order_lines_gt bcolt
2729: SET bcolt.config_item_id =
2730: (SELECT bcol.config_item_id
2731: FROM bom_cto_order_lines bcol
2732: WHERE bcolt.line_id = bcol.line_id

Line 2731: FROM bom_cto_order_lines bcol

2727:
2728: UPDATE /*+ INDEX (bcolt BOM_CTO_ORDER_LINES_GT_N5) */bom_cto_order_lines_gt bcolt
2729: SET bcolt.config_item_id =
2730: (SELECT bcol.config_item_id
2731: FROM bom_cto_order_lines bcol
2732: WHERE bcolt.line_id = bcol.line_id
2733: )
2734: WHERE bcolt.bom_item_type = '1' --used inverted commas, so that index is used
2735: AND nvl(bcolt.WIP_SUPPLY_TYPE,1) <>6

Line 2837: UPDATE bom_cto_order_lines_gt bcol

2833:
2834:
2835:
2836: lStmtNum:=20;
2837: UPDATE bom_cto_order_lines_gt bcol
2838: SET (bcol.wip_supply_type,
2839: bcol.bom_item_type )=
2840: (SELECT wip_supply_type,
2841: bom_item_type

Line 2860: FROM bom_cto_order_lines_gt;

2856: wip_supply_type
2857: BULK COLLECT INTO
2858: p_match_rec_of_tab.bom_item_type,
2859: p_match_rec_of_tab.wip_supply_type
2860: FROM bom_cto_order_lines_gt;
2861:
2862: oe_debug_pub.add('rowcount after select for BIT,WST=>'||sql%rowcount,5);
2863:
2864: --rowcount of bom_itemtype,wip_supply_typ after select l_rowcount;

Line 2947: UPDATE bom_cto_order_lines_gt

2943: lStmtNum:=80;
2944: --update the remaining columns into bcol_temp
2945:
2946: FORALL i IN 1..l_last_index
2947: UPDATE bom_cto_order_lines_gt
2948: SET PARENT_ATO_LINE_ID = p_match_rec_of_tab.PARENT_ATO_LINE_ID(i),
2949: GOP_PARENT_ATO_LINE_ID = p_match_rec_of_tab.GOP_PARENT_ATO_LINE_ID(i),
2950: PLAN_LEVEL = p_match_rec_of_tab.PLAN_LEVEL (i)
2951: WHERE line_id = p_match_rec_of_tab.LINE_ID(i);

Line 3042: delete from bom_cto_order_lines_gt;

3038: -- bcolgt into the pl/sql table. But since bcol gt has more rows than
3039: -- the pl/sql table, incorrect configs are matched to models.
3040: -- So executing a complete delete here from bcol gt.
3041:
3042: delete from bom_cto_order_lines_gt;
3043:
3044: IF PG_DEBUG <> 0 THEN
3045: oe_debug_pub.add('insert into bcol_gt',5);
3046: END IF;

Line 3051: INSERT INTO bom_cto_order_lines_gt

3047:
3048:
3049: lStmtNum:=20;
3050: FORALL i in 1..l_last_index
3051: INSERT INTO bom_cto_order_lines_gt
3052: (
3053: ATO_LINE_ID,
3054: BOM_ITEM_TYPE,
3055: COMPONENT_CODE,

Line 3460: FROM bom_cto_order_lines_gt

3456: SELECT line_id,
3457: parent_ato_line_id,
3458: ato_line_id,
3459: perform_match
3460: FROM bom_cto_order_lines_gt
3461: WHERE bom_item_type = '1' -- put in inverted commas to use hint
3462: AND nvl(wip_supply_type,1)<> 6;
3463:
3464:

Line 3483: UPDATE /+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N5) / bom_cto_order_lines_gt bcol

3479: --SQL statement which accesses other tables.
3480: --In such cases, the join order may not be optimal due to the lack
3481: --of stats on the temp table, hence hints should be used to ensure the optimal join order.
3482:
3483: UPDATE /*+ INDEX (bcol BOM_CTO_ORDER_LINES_GT_N5) */ bom_cto_order_lines_gt bcol
3484: SET bcol.perform_match=
3485: (SELECT config_match
3486: FROM mtl_system_items_b mtl
3487: WHERE mtl.inventory_item_id = bcol.inventory_item_id

Line 3568: UPDATE bom_cto_order_lines_gt

3564: END IF;
3565:
3566: lStmtNum := 50;
3567: FORALL i IN 1..l_match_flag_rec_of_tab.line_id.count
3568: UPDATE bom_cto_order_lines_gt
3569: SET perform_match = l_match_flag_rec_of_tab.match_flag(i)
3570: WHERE line_id = l_match_flag_rec_of_tab.line_id (i);
3571:
3572: