DBA Data[Home] [Help]

APPS.CTO_UPDATE_ITEMS_PK dependencies on CTO_CONFIG_ITEM_PK

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

408: If p_upgrade_mode = 2 Then
409: WriteToLog('Updating ATP attributes for configs in existing orgs');
410:
411: update mtl_system_items_b msic
412: set (msic.atp_components_flag,msic.atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(msim.atp_flag,
413: msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag
414: from mtl_system_items_b msim
415: where msim.inventory_item_id = msic.base_item_id
416: and msim.organization_id = msic.organization_id)

Line 413: msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag

409: WriteToLog('Updating ATP attributes for configs in existing orgs');
410:
411: update mtl_system_items_b msic
412: set (msic.atp_components_flag,msic.atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(msim.atp_flag,
413: msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag
414: from mtl_system_items_b msim
415: where msim.inventory_item_id = msic.base_item_id
416: and msim.organization_id = msic.organization_id)
417: where msic.inventory_item_id in

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

3401: 4, -- BOM_ITEM_TYPE:standard
3402: 'N',
3403: 'Y',
3404: m.inventory_item_id, -- Base Model ID
3405: CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(m.atp_flag, m.atp_components_flag),
3406: CTO_CONFIG_ITEM_PK.get_atp_flag,
3407: m.fixed_lead_time,
3408: m.variable_lead_time,
3409: m.wip_supply_locator_id,

Line 3406: CTO_CONFIG_ITEM_PK.get_atp_flag,

3402: 'N',
3403: 'Y',
3404: m.inventory_item_id, -- Base Model ID
3405: CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(m.atp_flag, m.atp_components_flag),
3406: CTO_CONFIG_ITEM_PK.get_atp_flag,
3407: m.fixed_lead_time,
3408: m.variable_lead_time,
3409: m.wip_supply_locator_id,
3410: m.wip_supply_type,

Line 4149: 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)),

4145: 4, -- BOM_ITEM_TYPE : standard
4146: 'N',
4147: 'Y',
4148: bcolu.inventory_item_id, -- Base Model ID
4149: 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)),
4150: decode( get_attribute_control( 'atp_flag') , 1, config.atp_flag, cto_config_item_pk.get_atp_flag) , -- ATP flag, set by evaluate_atp_attributes
4151: decode( get_attribute_control( 'fixed_lead_time') ,1 , config.fixed_lead_time, m.fixed_lead_time) ,
4152: decode( get_attribute_control( 'variable_lead_time') , 1 , config.variable_lead_time, m.variable_lead_time) ,
4153: decode( get_attribute_control( 'wip_supply_locator_id' ) , 1, config.wip_supply_locator_id, m.wip_supply_locator_id) ,

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

4146: 'N',
4147: 'Y',
4148: bcolu.inventory_item_id, -- Base Model ID
4149: 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)),
4150: decode( get_attribute_control( 'atp_flag') , 1, config.atp_flag, cto_config_item_pk.get_atp_flag) , -- ATP flag, set by evaluate_atp_attributes
4151: decode( get_attribute_control( 'fixed_lead_time') ,1 , config.fixed_lead_time, m.fixed_lead_time) ,
4152: decode( get_attribute_control( 'variable_lead_time') , 1 , config.variable_lead_time, m.variable_lead_time) ,
4153: decode( get_attribute_control( 'wip_supply_locator_id' ) , 1, config.wip_supply_locator_id, m.wip_supply_locator_id) ,
4154: decode( get_attribute_control( 'wip_supply_type' ) , 1 , config.wip_supply_type , m.wip_supply_type) ,