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 MTL_SYSTEM_ITEMS_B

Line 4296: update mtl_system_items_b msic

4292: If p_item = 1 Then
4293:
4294: -- Update based on all models
4295:
4296: update mtl_system_items_b msic
4297: set (atp_components_flag,atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(nvl(msim.atp_flag,'N'),nvl(msim.atp_components_flag,'N')),CTO_CONFIG_ITEM_PK.get_atp_flag
4298: from mtl_system_items_b msim
4299: where msim.inventory_item_id = msic.base_item_id
4300: and msim.organization_id = msic.organization_id)

Line 4298: from mtl_system_items_b msim

4294: -- Update based on all models
4295:
4296: update mtl_system_items_b msic
4297: set (atp_components_flag,atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(nvl(msim.atp_flag,'N'),nvl(msim.atp_components_flag,'N')),CTO_CONFIG_ITEM_PK.get_atp_flag
4298: from mtl_system_items_b msim
4299: where msim.inventory_item_id = msic.base_item_id
4300: and msim.organization_id = msic.organization_id)
4301:
4302: where msic.base_item_id is not null

Line 4304: from mtl_system_items_b msim1

4300: and msim.organization_id = msic.organization_id)
4301:
4302: where msic.base_item_id is not null
4303: and 'x'= (select 'x'
4304: from mtl_system_items_b msim1
4305: where msim1.inventory_item_id = msic.base_item_id
4306: and msim1.organization_id = msic.organization_id);
4307:
4308:

Line 4314: update mtl_system_items_b msic

4310: WriteToLog(' Number of records updated = '||sql%rowcount);
4311:
4312: elsif p_item = 2 then
4313: -- update based on the category id
4314: update mtl_system_items_b msic
4315: set (atp_components_flag,atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(nvl(msim.atp_flag,'N'),nvl(msim.atp_components_flag,'N')),CTO_CONFIG_ITEM_PK.get_atp_flag
4316: from mtl_system_items_b msim
4317: where msim.inventory_item_id = msic.base_item_id
4318: and msim.organization_id = msic.organization_id)

Line 4316: from mtl_system_items_b msim

4312: elsif p_item = 2 then
4313: -- update based on the category id
4314: update mtl_system_items_b msic
4315: set (atp_components_flag,atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(nvl(msim.atp_flag,'N'),nvl(msim.atp_components_flag,'N')),CTO_CONFIG_ITEM_PK.get_atp_flag
4316: from mtl_system_items_b msim
4317: where msim.inventory_item_id = msic.base_item_id
4318: and msim.organization_id = msic.organization_id)
4319: where msic.inventory_item_id in (select msi.inventory_item_id
4320: from mtl_system_items_b msi,

Line 4320: from mtl_system_items_b msi,

4316: from mtl_system_items_b msim
4317: where msim.inventory_item_id = msic.base_item_id
4318: and msim.organization_id = msic.organization_id)
4319: where msic.inventory_item_id in (select msi.inventory_item_id
4320: from mtl_system_items_b msi,
4321: mtl_item_categories mcat
4322: where msi.base_item_id = mcat.inventory_item_id
4323: and mcat.category_id = p_cat_id)
4324: and exists (select 'x' from mtl_system_items_b msim

Line 4324: and exists (select 'x' from mtl_system_items_b msim

4320: from mtl_system_items_b msi,
4321: mtl_item_categories mcat
4322: where msi.base_item_id = mcat.inventory_item_id
4323: and mcat.category_id = p_cat_id)
4324: and exists (select 'x' from mtl_system_items_b msim
4325: where msim.inventory_item_id = msic.base_item_id
4326: and msim.organization_id = msic.organization_id);
4327:
4328: WriteToLog(' Number of records updated = '||sql%rowcount);

Line 4332: update mtl_system_items_b msic

4328: WriteToLog(' Number of records updated = '||sql%rowcount);
4329:
4330: elsif p_item = 3 then
4331: -- update based on config item
4332: update mtl_system_items_b msic
4333: set (atp_components_flag,atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(msim.atp_flag,msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag
4334: from mtl_system_items_b msim
4335: where msim.inventory_item_id = msic.base_item_id
4336: and msim.organization_id = msic.organization_id)

Line 4334: from mtl_system_items_b msim

4330: elsif p_item = 3 then
4331: -- update based on config item
4332: update mtl_system_items_b msic
4333: set (atp_components_flag,atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(msim.atp_flag,msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag
4334: from mtl_system_items_b msim
4335: where msim.inventory_item_id = msic.base_item_id
4336: and msim.organization_id = msic.organization_id)
4337: where msic.inventory_item_id = p_config_id
4338: and exists (select 'x' from mtl_system_items_b msim

Line 4338: and exists (select 'x' from mtl_system_items_b msim

4334: from mtl_system_items_b msim
4335: where msim.inventory_item_id = msic.base_item_id
4336: and msim.organization_id = msic.organization_id)
4337: where msic.inventory_item_id = p_config_id
4338: and exists (select 'x' from mtl_system_items_b msim
4339: where msim.inventory_item_id = msic.base_item_id
4340: and msim.organization_id = msic.organization_id);
4341: WriteToLog(' Number of records updated = '||sql%rowcount);
4342: end if;