APPS.CTO_MATCH_CONFIG dependencies on BOM_ATO_CONFIGS_TEMP

Line 699: The first sql shall insert into bom_ato_configs_temp the "approximate"

695: in FP. Correction is the usage of decode function. Abhimanyu, will obsolete
696: the bug 4526218 and create a new patch for it.
697:
698: Bug4526218 begin: performance issue- Broke the match sql into two parts.
699: The first sql shall insert into bom_ato_configs_temp the "approximate"
700: matching configurations. For "approximate" match, it must have the same
701: count of components and the sum of component item ids must be equal.
702:
703: The second sql shall work on the filtered set of probable match candidate

Line 715: delete bom_ato_configs_temp;

711: oe_debug_pub.add ('check_config_match :: start time : '||to_char(l_start_time, 'MM-DD-YYYY HH24:MI:SS'));
712: END IF;
713:
714: l_stmt_num := 100;
715: delete bom_ato_configs_temp;
716:
717: l_stmt_num := 110;
718: select count(*), sum( nvl( decode(line_id, p_model_line_id, inventory_item_id, config_item_id),
719: inventory_item_id

Line 748: insert into bom_ato_configs_temp(

744: -- instead of the IN operator
745: -- ntungare
746: --
747: /*
748: insert into bom_ato_configs_temp(
749: config_item_id,
750: organization_id,
751: base_model_id,
752: component_item_id,

Line 773: insert into bom_ato_configs_temp(

769: )
770: and bac1.component_item_id = bac1.base_model_id; --6086540: load just 1 record per config item
771: */
772:
773: insert into bom_ato_configs_temp(
774: config_item_id,
775: organization_id,
776: base_model_id,
777: component_item_id,

Line 802: oe_debug_pub.add ('check_config_match :: after bom_ato_configs_temp insert time : '||to_char(sysdate, 'MM-DD-YYYY HH24:MI:SS'));

798:
799:
800: IF PG_DEBUG <> 0 THEN
801: oe_debug_pub.add ('Rows inserted into gtt :'||sql%rowcount);
802: oe_debug_pub.add ('check_config_match :: after bom_ato_configs_temp insert time : '||to_char(sysdate, 'MM-DD-YYYY HH24:MI:SS'));
803: END IF;
804:
805: l_stmt_num := 140;
806:

Line 812: bom_ato_configs_temp bact1, --6086540: use the GTT for filtering based on approx match

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
816: and bact1.base_model_id = col1.inventory_item_id