APPS.CTO_UPDATE_CONFIGS_PK dependencies on DUAL

Line 721: -- cursor to select all individual (not top level) config

717:
718: IS
719:
720: --
721: -- cursor to select all individual (not top level) config
722: -- items in bac having item attribute = 3 and not in bcol_upg
723: --
724: CURSOR c_bac IS
725: -- individual configs not in bcol and having item attribute 3

Line 725: -- individual configs not in bcol and having item attribute 3

721: -- cursor to select all individual (not top level) config
722: -- items in bac having item attribute = 3 and not in bcol_upg
723: --
724: CURSOR c_bac IS
725: -- individual configs not in bcol and having item attribute 3
726: select distinct bac.config_item_id config_id
727: from bom_ato_configurations bac,
728: mtl_system_items msi
729: where NOT EXISTS

Line 743: -- individual configs not in bcol and having item attribute 3

739: -- cursor to select all top level config
740: -- items in bac having item attribute = 3 and not in bcol_upg
741: --
742: CURSOR c_bac_top IS
743: -- individual configs not in bcol and having item attribute 3
744: select distinct bac.config_item_id config_id
745: from bom_ato_configurations bac,
746: mtl_system_items msi
747: -- item attribute is 3

Line 1114: -- select all individual (not top level) config items in bac having item attribute = 3 and not in bcol_upg

1110: ;
1111: WriteToLog('Rows inserted::'|| to_char(sql%rowcount), 3);
1112:
1113: --
1114: -- select all individual (not top level) config items in bac having item attribute = 3 and not in bcol_upg
1115: -- populate into bcol_upg from bcol or bac
1116: -- mark as UPG
1117: -- mark with program_id = 99 to indicate that it was populated from bac
1118: --

Line 1548: -- cursor to select all individual (not top level) config

1544:
1545: IS
1546:
1547: --
1548: -- cursor to select all individual (not top level) config
1549: -- items in bac having item attribute = 3
1550: -- and assigned to CTO category and not in bcol_upg
1551: --
1552: CURSOR c_bac(p_cat_id number) IS

Line 1553: -- individual configs not in bcol and having item attribute 3

1549: -- items in bac having item attribute = 3
1550: -- and assigned to CTO category and not in bcol_upg
1551: --
1552: CURSOR c_bac(p_cat_id number) IS
1553: -- individual configs not in bcol and having item attribute 3
1554: select /*+ ORDERED */ distinct bac.config_item_id config_id --Bugfix 6617686 Added a hint
1555: from mtl_item_categories mcat, --Bugfix 6617686: Changed the order of tables
1556: mtl_system_items msi,
1557: bom_ato_configurations bac

Line 1577: -- individual configs not in bcol and having item attribute 3

1573: -- items in bac having item attribute = 3
1574: -- and assigned to CTO category and not in bcol_upg
1575: --
1576: CURSOR c_bac_top(p_cat_id number) IS
1577: -- individual configs not in bcol and having item attribute 3
1578: select /*+ ORDERED*/ distinct bac.config_item_id config_id --Bugfix 6617686 Added a hint
1579: from mtl_item_categories mcat, --Bugfix 6617686 Changed the order of tables
1580: mtl_system_items msi,
1581: bom_ato_configurations bac

Line 1963: -- select all individual (not top level) config items in bac having item attribute = 3 and not in bcol_upg

1959: ;
1960: WriteToLog('Rows inserted::'|| to_char(sql%rowcount), 3);
1961:
1962: --
1963: -- select all individual (not top level) config items in bac having item attribute = 3 and not in bcol_upg
1964: -- populate into bcol_upg from bcol or bac
1965: -- mark as UPG
1966: -- mark with program_id = 99 to indicate that it was populated from bac
1967: --

Line 3003: from dual;

2999:
3000: l_stmt_num := 50;
3001: select bom_cto_order_lines_s1.nextval
3002: into l_header_id
3003: from dual;
3004:
3005: -- populate top_model_line_id, ato_line_id and header_id
3006: l_stmt_num := 60;
3007: FOR i IN 1..t_bcol.count LOOP