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 3916: update mtl_system_items_b msic

3912: If p_item = 1 Then
3913:
3914: -- Update based on all models
3915:
3916: update mtl_system_items_b msic
3917: 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
3918: from mtl_system_items_b msim
3919: where msim.inventory_item_id = msic.base_item_id
3920: and msim.organization_id = msic.organization_id)

Line 3918: from mtl_system_items_b msim

3914: -- Update based on all models
3915:
3916: update mtl_system_items_b msic
3917: 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
3918: from mtl_system_items_b msim
3919: where msim.inventory_item_id = msic.base_item_id
3920: and msim.organization_id = msic.organization_id)
3921:
3922: where msic.base_item_id is not null

Line 3924: from mtl_system_items_b msim1

3920: and msim.organization_id = msic.organization_id)
3921:
3922: where msic.base_item_id is not null
3923: and 'x'= (select 'x'
3924: from mtl_system_items_b msim1
3925: where msim1.inventory_item_id = msic.base_item_id
3926: and msim1.organization_id = msic.organization_id);
3927:
3928:

Line 3934: update mtl_system_items_b msic

3930: WriteToLog(' Number of records updated = '||sql%rowcount);
3931:
3932: elsif p_item = 2 then
3933: -- update based on the category id
3934: update mtl_system_items_b msic
3935: 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
3936: from mtl_system_items_b msim
3937: where msim.inventory_item_id = msic.base_item_id
3938: and msim.organization_id = msic.organization_id)

Line 3936: from mtl_system_items_b msim

3932: elsif p_item = 2 then
3933: -- update based on the category id
3934: update mtl_system_items_b msic
3935: 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
3936: from mtl_system_items_b msim
3937: where msim.inventory_item_id = msic.base_item_id
3938: and msim.organization_id = msic.organization_id)
3939: where msic.inventory_item_id in (select msi.inventory_item_id
3940: from mtl_system_items_b msi,

Line 3940: from mtl_system_items_b msi,

3936: from mtl_system_items_b msim
3937: where msim.inventory_item_id = msic.base_item_id
3938: and msim.organization_id = msic.organization_id)
3939: where msic.inventory_item_id in (select msi.inventory_item_id
3940: from mtl_system_items_b msi,
3941: mtl_item_categories mcat
3942: where msi.base_item_id = mcat.inventory_item_id
3943: and mcat.category_id = p_cat_id)
3944: and exists (select 'x' from mtl_system_items_b msim

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

3940: from mtl_system_items_b msi,
3941: mtl_item_categories mcat
3942: where msi.base_item_id = mcat.inventory_item_id
3943: and mcat.category_id = p_cat_id)
3944: and exists (select 'x' from mtl_system_items_b msim
3945: where msim.inventory_item_id = msic.base_item_id
3946: and msim.organization_id = msic.organization_id);
3947:
3948: WriteToLog(' Number of records updated = '||sql%rowcount);

Line 3952: update mtl_system_items_b msic

3948: WriteToLog(' Number of records updated = '||sql%rowcount);
3949:
3950: elsif p_item = 3 then
3951: -- update based on config item
3952: update mtl_system_items_b msic
3953: 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
3954: from mtl_system_items_b msim
3955: where msim.inventory_item_id = msic.base_item_id
3956: and msim.organization_id = msic.organization_id)

Line 3954: from mtl_system_items_b msim

3950: elsif p_item = 3 then
3951: -- update based on config item
3952: update mtl_system_items_b msic
3953: 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
3954: from mtl_system_items_b msim
3955: where msim.inventory_item_id = msic.base_item_id
3956: and msim.organization_id = msic.organization_id)
3957: where msic.inventory_item_id = p_config_id
3958: and exists (select 'x' from mtl_system_items_b msim

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

3954: from mtl_system_items_b msim
3955: where msim.inventory_item_id = msic.base_item_id
3956: and msim.organization_id = msic.organization_id)
3957: where msic.inventory_item_id = p_config_id
3958: and exists (select 'x' from mtl_system_items_b msim
3959: where msim.inventory_item_id = msic.base_item_id
3960: and msim.organization_id = msic.organization_id);
3961: WriteToLog(' Number of records updated = '||sql%rowcount);
3962: end if;