DBA Data[Home] [Help]

APPS.CTO_UPDATE_ITEMS_PK dependencies on CTO_CONFIG_ITEM_PK

Line 452: set (msic.atp_components_flag,msic.atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(msim.atp_flag,

448: If p_upgrade_mode = 2 Then
449: WriteToLog('Updating ATP attributes for configs in existing orgs');
450:
451: update mtl_system_items_b msic
452: set (msic.atp_components_flag,msic.atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(msim.atp_flag,
453: msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag
454: from mtl_system_items_b msim
455: where msim.inventory_item_id = msic.base_item_id
456: and msim.organization_id = msic.organization_id)

Line 453: msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag

449: WriteToLog('Updating ATP attributes for configs in existing orgs');
450:
451: update mtl_system_items_b msic
452: set (msic.atp_components_flag,msic.atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(msim.atp_flag,
453: msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag
454: from mtl_system_items_b msim
455: where msim.inventory_item_id = msic.base_item_id
456: and msim.organization_id = msic.organization_id)
457: where msic.inventory_item_id in

Line 3609: CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(m.atp_flag, m.atp_components_flag),

3605: 4, -- BOM_ITEM_TYPE:standard
3606: 'N',
3607: 'Y',
3608: m.inventory_item_id, -- Base Model ID
3609: CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(m.atp_flag, m.atp_components_flag),
3610: CTO_CONFIG_ITEM_PK.get_atp_flag,
3611: m.fixed_lead_time,
3612: m.variable_lead_time,
3613: m.wip_supply_locator_id,

Line 3610: CTO_CONFIG_ITEM_PK.get_atp_flag,

3606: 'N',
3607: 'Y',
3608: m.inventory_item_id, -- Base Model ID
3609: CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(m.atp_flag, m.atp_components_flag),
3610: CTO_CONFIG_ITEM_PK.get_atp_flag,
3611: m.fixed_lead_time,
3612: m.variable_lead_time,
3613: m.wip_supply_locator_id,
3614: m.wip_supply_type,

Line 4393: decode( get_attribute_control( 'atp_components_flag') , 1, config.atp_components_flag, CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(m.atp_flag, m.atp_components_flag)),

4389: 4, -- BOM_ITEM_TYPE : standard
4390: 'N',
4391: 'Y',
4392: bcolu.inventory_item_id, -- Base Model ID
4393: decode( get_attribute_control( 'atp_components_flag') , 1, config.atp_components_flag, CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(m.atp_flag, m.atp_components_flag)),
4394: decode( get_attribute_control( 'atp_flag') , 1, config.atp_flag, cto_config_item_pk.get_atp_flag) , -- ATP flag, set by evaluate_atp_attributes
4395: decode( get_attribute_control( 'fixed_lead_time') ,1 , config.fixed_lead_time, m.fixed_lead_time) ,
4396: decode( get_attribute_control( 'variable_lead_time') , 1 , config.variable_lead_time, m.variable_lead_time) ,
4397: decode( get_attribute_control( 'wip_supply_locator_id' ) , 1, config.wip_supply_locator_id, m.wip_supply_locator_id) ,

Line 4394: decode( get_attribute_control( 'atp_flag') , 1, config.atp_flag, cto_config_item_pk.get_atp_flag) , -- ATP flag, set by evaluate_atp_attributes

4390: 'N',
4391: 'Y',
4392: bcolu.inventory_item_id, -- Base Model ID
4393: decode( get_attribute_control( 'atp_components_flag') , 1, config.atp_components_flag, CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(m.atp_flag, m.atp_components_flag)),
4394: decode( get_attribute_control( 'atp_flag') , 1, config.atp_flag, cto_config_item_pk.get_atp_flag) , -- ATP flag, set by evaluate_atp_attributes
4395: decode( get_attribute_control( 'fixed_lead_time') ,1 , config.fixed_lead_time, m.fixed_lead_time) ,
4396: decode( get_attribute_control( 'variable_lead_time') , 1 , config.variable_lead_time, m.variable_lead_time) ,
4397: decode( get_attribute_control( 'wip_supply_locator_id' ) , 1, config.wip_supply_locator_id, m.wip_supply_locator_id) ,
4398: decode( get_attribute_control( 'wip_supply_type' ) , 1 , config.wip_supply_type , m.wip_supply_type) ,