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_ATO_CONFIGURATIONS

Line 14: | BOM_ATO_CONFIGURATIONS. |

10: | FILE NAME : CTOMCFGB.pls |
11: | DESCRIPTION: |
12: | This file creates packaged functions that check for matching |
13: | configurations and insert unique configurations into |
14: | BOM_ATO_CONFIGURATIONS. |
15: | |
16: | check_config_match - checks BOM_ATO_CONFIGURATIONS for |
17: | configurations that match the ordered configuration. It |
18: | is called from the Match Configuration Workflow activity |

Line 16: | check_config_match - checks BOM_ATO_CONFIGURATIONS for |

12: | This file creates packaged functions that check for matching |
13: | configurations and insert unique configurations into |
14: | BOM_ATO_CONFIGURATIONS. |
15: | |
16: | check_config_match - checks BOM_ATO_CONFIGURATIONS for |
17: | configurations that match the ordered configuration. It |
18: | is called from the Match Configuration Workflow activity |
19: | and from the Create Configuration batch process. |
20: | |

Line 22: | BOM_ATO_CONFIGURATIONS. It is called from the Create |

18: | is called from the Match Configuration Workflow activity |
19: | and from the Create Configuration batch process. |
20: | |
21: | can_configurations - inserts unique configurations into |
22: | BOM_ATO_CONFIGURATIONS. It is called from the Create |
23: | Configuration batch process and the Create Configuration |
24: | Item and BOM workflow activity. |
25: | |
26: | To Do: Handle Errors. Need to discuss with Usha and Girish what |

Line 150: bom_ato_configurations that matches the ordered

146: x_msg_count
147: x_msg_data
148:
149: Description: This function looks for a configuration in
150: bom_ato_configurations that matches the ordered
151: configuration in oe_order_lines_all.
152:
153: *****************************************************************************/
154: PG_DEBUG Number := NVL(FND_PROFILE.value('ONT_DEBUG_LEVEL'), 0);

Line 622: from bom_ato_configurations

618: /*****************************************************************************
619: Function: check_config_match
620: Parameters: pModelLineId - line id of the top model in oe_order_lines_all
621: x_match_config_id - config id of the matching configuration
622: from bom_ato_configurations
623: x_error_message - error message if match function fails
624: x_message_name - name of error message if match
625: function fails
626:

Line 628: bom_ato_configurations that matches the ordered

624: x_message_name - name of error message if match
625: function fails
626:
627: Description: This function looks for a configuration in
628: bom_ato_configurations that matches the ordered
629: configuration in oe_order_lines_all.
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

Line 680: * Check BOM_ATO_CONFIGURATIONS for a configuration that matches the

676:
677: BEGIN
678:
679: /**************************************************************
680: * Check BOM_ATO_CONFIGURATIONS for a configuration that matches the
681: * ordered configuration in oe_order_lines_all.
682: ****************************************************************/
683:
684:

Line 761: from bom_ato_configurations bac1

757: bac1.base_model_id,
758: bac1.component_item_id,
759: bac1.component_code,
760: bac1.component_quantity
761: from bom_ato_configurations bac1
762: where bac1.config_item_id in (
763: select config_item_id
764: from BOM_ATO_CONFIGURATIONS bac3
765: where bac3.base_model_id = l_base_model_id

Line 764: from BOM_ATO_CONFIGURATIONS bac3

760: bac1.component_quantity
761: from bom_ato_configurations bac1
762: where bac1.config_item_id in (
763: select config_item_id
764: from BOM_ATO_CONFIGURATIONS bac3
765: where bac3.base_model_id = l_base_model_id
766: group by bac3.config_item_id
767: having count(*) = l_component_count
768: and sum(component_item_id) = l_component_sum

Line 780: select /+ INDEX(BAC1 BOM_ATO_CONFIGURATIONS_N1)/

776: base_model_id,
777: component_item_id,
778: component_code,
779: component_quantity)
780: select /*+ INDEX(BAC1 BOM_ATO_CONFIGURATIONS_N1)*/
781: bac1.config_item_id,
782: bac1.organization_id,
783: bac1.base_model_id,
784: bac1.component_item_id,

Line 787: from bom_ato_configurations bac1

783: bac1.base_model_id,
784: bac1.component_item_id,
785: bac1.component_code,
786: bac1.component_quantity
787: from bom_ato_configurations bac1
788: where bac1.component_item_id = bac1.base_model_id
789: and bac1.base_model_id = l_base_model_id
790: and EXISTS (SELECT 1
791: from BOM_ATO_CONFIGURATIONS bac3

Line 791: from BOM_ATO_CONFIGURATIONS bac3

787: from bom_ato_configurations bac1
788: where bac1.component_item_id = bac1.base_model_id
789: and bac1.base_model_id = l_base_model_id
790: and EXISTS (SELECT 1
791: from BOM_ATO_CONFIGURATIONS bac3
792: where bac3.base_model_id = l_base_model_id
793: and bac1.config_item_id = bac3.config_item_id
794: and bac1.base_model_id = bac3.base_model_id
795: group by bac3.config_item_id

Line 813: bom_ato_configurations bac1 --6086540: matching will be done in main table

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
817: and bac1.component_item_id = col1.inventory_item_id

Line 837: from bom_ato_configurations bac2 -- 6086540

833: and nvl(decode(col5.line_id, col1.line_id, col5.inventory_item_id,
834: col5.config_item_id),
835: col5.inventory_item_id) not in
836: (select bac2.component_item_id
837: from bom_ato_configurations bac2 -- 6086540
838: where bac2.config_item_id = bac1.config_item_id
839: and bac2.component_item_id =
840: decode(col5.config_item_id, NULL,
841: col5.inventory_item_id, decode(col5.line_id, col1.line_id,

Line 852: ( select 'Extra Options in Config' from bom_ato_configurations bac9 -- 6086540

848: Round( nvl(col5.ordered_quantity,0)/ nvl(col1.ordered_quantity,0) , 7 ) /* Decimal-Qty Support for Option Items */
849: )
850: )
851: and not exists /* Added due to Multiple Instantiation */
852: ( select 'Extra Options in Config' from bom_ato_configurations bac9 -- 6086540
853: where bac9.config_item_id = bac1.config_item_id /* v_config_item_id */
854: and ( bac9.component_item_id , bac9.component_quantity )
855: not in
856: ( select decode( col1.line_id , col9.line_id, col9.inventory_item_id ,

Line 879: FROM bom_ato_configurations

875: --l_dummy VARCHAR2(2);
876:
877: CURSOR config_rows IS
878: SELECT last_referenced_date
879: FROM bom_ato_configurations
880: WHERE config_item_id = x_config_match_id
881: FOR UPDATE NOWAIT;
882:
883: begin

Line 895: update bom_ato_configurations

891: END IF;
892:
893: l_stmt_num := 120;
894:
895: update bom_ato_configurations
896: set last_referenced_date = SYSDATE
897: where config_item_id = x_config_match_id;
898:
899: exception

Line 970: into BOM_ATO_CONFIGURATIONS for use when matching a

966: x_error_message - error message if match function fails
967: x_message_name - name of error msg if match function fails
968:
969: Description: This function inserts the configuration (model and components)
970: into BOM_ATO_CONFIGURATIONS for use when matching a
971: configuration via the Match functionality.
972:
973: It is called from the Create Item and BOM batch process.
974:

Line 1049: Insert into BOM_ATO_CONFIGURATIONS the model configuration from

1045:
1046:
1047:
1048: /******************************************************************
1049: Insert into BOM_ATO_CONFIGURATIONS the model configuration from
1050: oe_order_lines_all.
1051: ******************************************************************/
1052: l_stmt_num := 100;
1053: insert into BOM_ATO_CONFIGURATIONS(

Line 1053: insert into BOM_ATO_CONFIGURATIONS(

1049: Insert into BOM_ATO_CONFIGURATIONS the model configuration from
1050: oe_order_lines_all.
1051: ******************************************************************/
1052: l_stmt_num := 100;
1053: insert into BOM_ATO_CONFIGURATIONS(
1054: config_item_id,
1055: organization_id,
1056: base_model_id,
1057: component_item_id,