DBA Data[Home] [Help]

APPS.CTO_UPDATE_CONFIGS_PK dependencies on CTO_CONFIG_ITEM_PK

Line 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

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

Line 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

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

Line 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

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