APPS.CTO_UPDATE_CONFIGS_PK dependencies on DUAL

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

904:
905: IS
906:
907: --
908: -- cursor to select all individual (not top level) config
909: -- items in bac having item attribute = 3 and not in bcol_upg
910: --
911: CURSOR c_bac IS
912: -- individual configs not in bcol and having item attribute 3

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

908: -- cursor to select all individual (not top level) config
909: -- items in bac having item attribute = 3 and not in bcol_upg
910: --
911: CURSOR c_bac IS
912: -- individual configs not in bcol and having item attribute 3
913: select distinct bac.config_item_id config_id
914: from bom_ato_configurations bac,
915: mtl_system_items msi
916: where NOT EXISTS

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

926: -- cursor to select all top level config
927: -- items in bac having item attribute = 3 and not in bcol_upg
928: --
929: CURSOR c_bac_top IS
930: -- individual configs not in bcol and having item attribute 3
931: select distinct bac.config_item_id config_id
932: from bom_ato_configurations bac,
933: mtl_system_items msi
934: -- item attribute is 3

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

1319: ;
1320: WriteToLog('Rows inserted::'|| to_char(sql%rowcount), 3);*/
1321:
1322: --
1323: -- select all individual (not top level) config items in bac having item attribute = 3 and not in bcol_upg
1324: -- populate into bcol_upg from bcol or bac
1325: -- mark as UPG
1326: -- mark with program_id = 99 to indicate that it was populated from bac
1327: --

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

1759:
1760: IS
1761:
1762: --
1763: -- cursor to select all individual (not top level) config
1764: -- items in bac having item attribute = 3
1765: -- and assigned to CTO category and not in bcol_upg
1766: --
1767: CURSOR c_bac(p_cat_id number) IS

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

1764: -- items in bac having item attribute = 3
1765: -- and assigned to CTO category and not in bcol_upg
1766: --
1767: CURSOR c_bac(p_cat_id number) IS
1768: -- individual configs not in bcol and having item attribute 3
1769: select /*+ ORDERED */ distinct bac.config_item_id config_id --Bugfix 6617686 Added a hint
1770: from mtl_item_categories mcat, --Bugfix 6617686: Changed the order of tables
1771: mtl_system_items msi,
1772: bom_ato_configurations bac

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

1788: -- items in bac having item attribute = 3
1789: -- and assigned to CTO category and not in bcol_upg
1790: --
1791: CURSOR c_bac_top(p_cat_id number, p_category_set_id number) IS
1792: -- individual configs not in bcol and having item attribute 3
1793: select distinct bac.config_item_id config_id --Bugfix 6617686 Added a hint
1794: from mtl_item_categories mcat, --Bugfix 6617686 Changed the order of tables
1795: mtl_system_items msi,
1796: bom_ato_configurations bac

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

2180: ;
2181: WriteToLog('Rows inserted::'|| to_char(sql%rowcount), 3);*/
2182:
2183: --
2184: -- select all individual (not top level) config items in bac having item attribute = 3 and not in bcol_upg
2185: -- populate into bcol_upg from bcol or bac
2186: -- mark as UPG
2187: -- mark with program_id = 99 to indicate that it was populated from bac
2188: --

Line 3253: from dual;

3249: IF l_skip_config = 0 then --Bugfix 13362916
3250: l_stmt_num := 50;
3251: select bom_cto_order_lines_s1.nextval
3252: into l_header_id
3253: from dual;
3254:
3255: -- populate top_model_line_id, ato_line_id and header_id
3256: l_stmt_num := 60;
3257: FOR i IN 1..t_bcol.count LOOP