[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
FROM wip_operations
WHERE wip_entity_id = p_wip_entity_id
AND organization_id = p_organization_id;
SELECT *
FROM wip_operation_networks
WHERE organization_id = p_organization_id
AND wip_entity_id = p_wip_entity_id;
SELECT *
FROM wip_operation_resources
WHERE organization_id = p_organization_id
AND wip_entity_id = p_wip_entity_id;
SELECT *
FROM wip_requirement_operations
WHERE wip_entity_id = p_wip_entity_id
AND organization_id = p_organization_id;
select stock_enabled_flag,list_price_per_unit
into l_stock_enabled_flag,l_list_price_per_unit
from mtl_system_items
where inventory_item_id = l_wip_requirement_row.inventory_item_id
and organization_id = l_wip_requirement_row.organization_id;
UPDATE mtl_system_items
SET EAM_ACTIVITY_TYPE_CODE = p_activity_type_code,
EAM_ACTIVITY_CAUSE_CODE = p_activity_cause_code,
EAM_ACT_SHUTDOWN_STATUS = p_shutdown_type_code,
EAM_ACT_NOTIFICATION_FLAG = p_notification_req_flag,
EAM_ACTIVITY_SOURCE_CODE = p_activity_source_code
WHERE inventory_item_id = l_x_master_item_rec.inventory_item_id
AND organization_id = l_x_master_item_rec.organization_id;
UPDATE mtl_system_items
SET EAM_ACTIVITY_TYPE_CODE = p_activity_type_code,
EAM_ACTIVITY_CAUSE_CODE = p_activity_cause_code,
EAM_ACT_SHUTDOWN_STATUS = p_shutdown_type_code,
EAM_ACT_NOTIFICATION_FLAG = p_notification_req_flag,
EAM_ACTIVITY_SOURCE_CODE = p_activity_source_code
WHERE inventory_item_id = l_x_curr_item_rec.inventory_item_id
AND organization_id = l_x_curr_item_rec.organization_id;
-- Step 5: Update Association to Asset Numbers for the newly created activity
IF p_association_copy_option <> 1 THEN
-- p_association_copy_option <> 1 (NONE), call private package to create association
EAM_ActivityAssociation_PVT.Create_Association(
p_api_version => 1.0,
x_return_status => l_x_assoc_return_status,
x_msg_count => l_x_assoc_msg_count,
x_msg_data => l_x_assoc_msg_data,
p_target_org_id => l_x_curr_item_rec.organization_id,
p_target_activity_id => l_x_curr_item_rec.inventory_item_id,
p_wip_entity_id => l_x_work_order_rec.wip_entity_id,
p_association_copy_option => p_association_copy_option,
x_act_num_association_tbl => l_x_act_num_association_tbl,
x_activity_association_tbl => l_x_activity_association_tbl
);
UPDATE mtl_system_items
SET EAM_ACTIVITY_TYPE_CODE = p_activity_type_code,
EAM_ACTIVITY_CAUSE_CODE = p_activity_cause_code,
EAM_ACT_SHUTDOWN_STATUS = p_shutdown_type_code,
EAM_ACT_NOTIFICATION_FLAG = p_notification_req_flag,
EAM_ACTIVITY_SOURCE_CODE = p_activity_source_code
WHERE inventory_item_id = l_x_master_item_rec.inventory_item_id
AND organization_id = l_x_master_item_rec.organization_id;
UPDATE mtl_system_items
SET EAM_ACTIVITY_TYPE_CODE = p_activity_type_code,
EAM_ACTIVITY_CAUSE_CODE = p_activity_cause_code,
EAM_ACT_SHUTDOWN_STATUS = p_shutdown_type_code,
EAM_ACT_NOTIFICATION_FLAG = p_notification_req_flag,
EAM_ACTIVITY_SOURCE_CODE = p_activity_source_code
WHERE inventory_item_id = l_x_curr_item_rec.inventory_item_id
AND organization_id = l_x_curr_item_rec.organization_id;
-- Step 5: Update Association to Asset Numbers for the newly created activity
EAM_ActivityUtilities_PVT.Write_Debug('-------- Beginning Copy Association --------');
SELECT segment1, segment2, segment3, segment4, segment5, segment6, segment7,
segment8, segment9, segment10, segment11, segment12, segment13, segment14,
segment15, segment16, segment17, segment18, segment19, segment20, description,
eam_activity_type_code, eam_activity_cause_code, eam_activity_source_code,
eam_act_notification_flag, eam_act_shutdown_status, eam_item_type
INTO l_item_rec.segment1, l_item_rec.segment2, l_item_rec.segment3, l_item_rec.segment4,
l_item_rec.segment5, l_item_rec.segment6, l_item_rec.segment7, l_item_rec.segment8,
l_item_rec.segment9, l_item_rec.segment10, l_item_rec.segment11, l_item_rec.segment12,
l_item_rec.segment13, l_item_rec.segment14, l_item_rec.segment15, l_item_rec.segment16,
l_item_rec.segment17, l_item_rec.segment18, l_item_rec.segment19, l_item_rec.segment20,
l_item_rec.description, l_item_rec.eam_activity_type_code,
l_item_rec.eam_activity_cause_code, l_item_rec.eam_activity_source_code,
l_item_rec.eam_act_notification_flag, l_item_rec.eam_act_shutdown_status,
l_item_rec.eam_item_type
FROM mtl_system_items_b
WHERE organization_id = l_master_organization_id
AND inventory_item_id = p_activity_id;
SELECT segment1, segment2, segment3, segment4, segment5, segment6, segment7,
segment8, segment9, segment10, segment11, segment12, segment13, segment14,
segment15, segment16, segment17, segment18, segment19, segment20, description,
eam_activity_type_code, eam_activity_cause_code, eam_activity_source_code,
eam_act_notification_flag, eam_act_shutdown_status, eam_item_type
INTO l_item_rec.segment1, l_item_rec.segment2, l_item_rec.segment3, l_item_rec.segment4,
l_item_rec.segment5, l_item_rec.segment6, l_item_rec.segment7, l_item_rec.segment8,
l_item_rec.segment9, l_item_rec.segment10, l_item_rec.segment11, l_item_rec.segment12,
l_item_rec.segment13, l_item_rec.segment14, l_item_rec.segment15, l_item_rec.segment16,
l_item_rec.segment17, l_item_rec.segment18, l_item_rec.segment19, l_item_rec.segment20,
l_item_rec.description, l_item_rec.eam_activity_type_code,
l_item_rec.eam_activity_cause_code, l_item_rec.eam_activity_source_code,
l_item_rec.eam_act_notification_flag, l_item_rec.eam_act_shutdown_status,
l_item_rec.eam_item_type
FROM mtl_system_items_b
WHERE inventory_item_id = p_activity_id
AND ROWNUM = 1;