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_UPDATE_CONFIGS_PK dependencies on BOM_ATO_CONFIGURATIONS

Line 295: from bom_ato_configurations bac

291: delete from mrp_sr_assignments
292: where assignment_set_id = l_mrp_aset_id
293: and inventory_item_id in
294: (select config_item_id
295: from bom_ato_configurations bac
296: where not exists
297: (select 'exists'
298: from bom_cto_order_lines_upg bcolu
299: where bcolu.config_item_id = bac.config_item_id)

Line 359: from bom_ato_configurations bac,

355: where assignment_set_id = l_mrp_aset_id
356: and inventory_item_id in
357: (
358: select config_item_id
359: from bom_ato_configurations bac,
360: mtl_item_categories mcat
361: where bac.base_model_id = mcat.inventory_item_id
362: and mcat.category_id = p_cat_id
363: and not exists

Line 727: from bom_ato_configurations bac,

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
730: (select 'exists'
731: from bom_cto_order_lines_upg bcolu

Line 745: from bom_ato_configurations bac,

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
748: where bac.base_model_id = msi.inventory_item_id
749: and bac.organization_id = msi.organization_id

Line 754: from bom_ato_configurations bac2

750: and nvl(msi.config_orgs, '1') = '3'
751: -- and is top parent with attribute 3
752: and NOT EXISTS
753: (select 'exists'
754: from bom_ato_configurations bac2
755: , mtl_system_items msi2
756: where bac.config_item_id = bac2.component_item_id
757: and bac2.base_model_id = msi2.inventory_item_id
758: and bac2.organization_id = msi2.organization_id

Line 992: , bom_ato_configurations bac

988: , 'UPG' --STATUS
989: , nvl(msi.config_orgs, '1')
990: from bom_cto_order_lines bcol1
991: , bom_cto_order_lines bcol2
992: , bom_ato_configurations bac
993: , oe_order_lines_all oel
994: , mtl_system_items msi
995: -- base model has item attr = 3
996: where bac.base_model_id = msi.inventory_item_id

Line 1090: from bom_ato_configurations bac

1086: , 'N' --REUSE_CONFIG
1087: , bcol.QTY_PER_PARENT_MODEL
1088: , 'UPG' --STATUS
1089: , nvl(msi.config_orgs, '1')
1090: from bom_ato_configurations bac
1091: , bom_cto_order_lines bcol
1092: , mtl_system_items msi
1093: -- base model has item attr = 3
1094: where bac.base_model_id = msi.inventory_item_id

Line 1335: , bom_ato_configurations bac

1331: , 'UPG' --STATUS
1332: , nvl(msi.CONFIG_ORGS, '1')
1333: from bom_cto_order_lines bcol1
1334: , bom_cto_order_lines bcol2
1335: , bom_ato_configurations bac
1336: , oe_order_lines_all oel
1337: , mtl_system_items msi
1338: -- base model has item attr = 3
1339: where bac.base_model_id = msi.inventory_item_id

Line 1435: from bom_ato_configurations bac

1431: , 'N' --REUSE_CONFIG
1432: , bcol.QTY_PER_PARENT_MODEL
1433: , 'UPG' --STATUS
1434: , nvl(msi.CONFIG_ORGS, '1')
1435: from bom_ato_configurations bac
1436: , bom_cto_order_lines bcol
1437: , mtl_system_items msi
1438: -- base model has item attr = 3
1439: where bac.base_model_id = msi.inventory_item_id

Line 1445: from bom_ato_configurations bac2

1441: and nvl(msi.config_orgs, '1') = '3'
1442: -- and is top parent with attribute 3
1443: and NOT EXISTS
1444: (select 'exists'
1445: from bom_ato_configurations bac2
1446: , mtl_system_items msi2
1447: where bac.config_item_id = bac2.component_item_id
1448: and bac2.base_model_id = msi2.inventory_item_id
1449: and bac2.organization_id = msi2.organization_id

Line 1557: bom_ato_configurations bac

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
1558: where NOT EXISTS
1559: (select 'exists'
1560: from bom_cto_order_lines_upg bcolu
1561: where bcolu.config_item_id = bac.config_item_id)

Line 1581: bom_ato_configurations bac

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
1582: -- item attribute is 3
1583: where bac.base_model_id = msi.inventory_item_id
1584: and bac.organization_id = msi.organization_id
1585: and nvl(msi.config_orgs, '1') = '3'

Line 1593: from bom_ato_configurations bac2

1589: and mcat.category_id = p_cat_id
1590: -- and is top parent with attribute 3
1591: and NOT EXISTS
1592: (select 'exists'
1593: from bom_ato_configurations bac2
1594: , mtl_system_items msi2
1595: where bac.config_item_id = bac2.component_item_id
1596: and bac2.base_model_id = msi2.inventory_item_id
1597: and bac2.organization_id = msi2.organization_id

Line 1828: , bom_ato_configurations bac

1824: --, bcol2.SEQUENCE
1825: , nvl(msi.config_orgs, '1')
1826: from bom_cto_order_lines bcol1
1827: , bom_cto_order_lines bcol2
1828: , bom_ato_configurations bac
1829: , oe_order_lines_all oel
1830: , mtl_system_items msi
1831: , mtl_item_categories mcat
1832: -- base model has item attr = 3

Line 1936: , bom_ato_configurations bac

1932: --, bcol.SEQUENCE
1933: , nvl(msi.config_orgs, '1')
1934: from mtl_item_categories mcat --Bugfix 6617686 Changed the order of tables
1935: , mtl_system_items msi
1936: , bom_ato_configurations bac
1937: , bom_cto_order_lines bcol
1938: -- base model has item attr = 3
1939: where bac.base_model_id = msi.inventory_item_id
1940: and bac.organization_id = msi.organization_id

Line 2199: , bom_ato_configurations bac

2195: --, bcol2.SEQUENCE
2196: , nvl(msi.CONFIG_ORGS, '1')
2197: from bom_cto_order_lines bcol1
2198: , bom_cto_order_lines bcol2
2199: , bom_ato_configurations bac
2200: , oe_order_lines_all oel
2201: , mtl_system_items msi
2202: , mtl_item_categories mcat
2203: -- base model has item attr = 3

Line 2305: from bom_ato_configurations bac

2301: , bcol.QTY_PER_PARENT_MODEL
2302: , 'UPG' --STATUS
2303: --, bcol.SEQUENCE
2304: , nvl(msi.CONFIG_ORGS, '1')
2305: from bom_ato_configurations bac
2306: , bom_cto_order_lines bcol
2307: , mtl_system_items msi
2308: , mtl_item_categories mcat
2309: -- base model has item attr = 3

Line 2320: from bom_ato_configurations bac2

2316: and mcat.category_id = p_cat_id
2317: -- and is top parent with attribute 3
2318: and NOT EXISTS
2319: (select 'exists'
2320: from bom_ato_configurations bac2
2321: , mtl_system_items msi2
2322: where bac.config_item_id = bac2.component_item_id
2323: and bac2.base_model_id = msi2.inventory_item_id
2324: and bac2.organization_id = msi2.organization_id

Line 2662: , bom_ato_configurations bac

2658: --, bcol2.SEQUENCE
2659: , nvl(msi.config_orgs, '1')
2660: from bom_cto_order_lines bcol1
2661: , bom_cto_order_lines bcol2
2662: , bom_ato_configurations bac
2663: , oe_order_lines_all oel
2664: , mtl_system_items msi
2665: where bac.config_item_id = p_config_id
2666: -- and exists in bcol

Line 2763: from bom_ato_configurations bac

2759: , 'N' --bcol.REUSE_CONFIG
2760: , bcol.QTY_PER_PARENT_MODEL
2761: , 'UPG' --STATUS
2762: , nvl(msi.config_orgs, '1')
2763: from bom_ato_configurations bac
2764: , bom_cto_order_lines bcol
2765: , mtl_system_items msi
2766: where bac.config_item_id = p_config_id
2767: and NOT EXISTS

Line 2890: from bom_ato_configurations bac,

2886: cto_update_configs_pk.bac_program_id, -- program_id
2887: 'Y', -- perform_match /* Sushant made changes to identify matched items */
2888: 'N', -- reuse_config
2889: bac.organization_id
2890: from bom_ato_configurations bac,
2891: mtl_system_items msi
2892: where bac.config_item_id = p_config_id
2893: -- and bac.component_item_id <> bac.base_model_id -- not pick up top model
2894: and msi.inventory_item_id = substr(bac.component_code, (instr(bac.component_code, '-', -1)+1)) -- bac.component_item_id

Line 2917: from bom_ato_configurations

2913:
2914: BEGIN
2915: select base_model_id
2916: into l_base_model_id
2917: from bom_ato_configurations
2918: where config_item_id = p_config_id
2919: and rownum = 1;
2920:
2921: EXCEPTION

Line 3198: from bom_ato_configurations bac,

3194: nvl(Fnd_Global.USER_ID, -1), -- created_by
3195: sysdate, -- last_update_date
3196: nvl(Fnd_Global.USER_ID, -1), -- last_updated_by
3197: cto_update_configs_pk.bac_program_id -- program_id
3198: from bom_ato_configurations bac,
3199: mtl_system_items msi
3200: where bac.config_item_id = l_curr_config_id
3201: and bac.component_item_id <> bac.base_model_id --not pick up top model
3202: and msi.inventory_item_id = bac.component_item_id