DBA Data[Home] [Help]

APPS.CTO_UPDATE_CONFIGS_PK dependencies on CTO_CONFIG_ITEM_PK

Line 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

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)
4301:

Line 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

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)
4319: where msic.inventory_item_id in (select msi.inventory_item_id

Line 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

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)
4337: where msic.inventory_item_id = p_config_id