17,377
社区成员
发帖
与我相关
我的任务
分享
DECLARE
x_return_status VARCHAR2(1);
x_msg_count NUMBER;
CURSOR cur_item IS
SELECT msi.segment1,
msi.primary_uom_code,
msi.inventory_item_id,
msi.organization_id
FROM mtl_system_items_b msi, odbc_rm_test ort
WHERE msi.inventory_item_id = ort.item_id
and msi.organization_id = 1042
AND NOT EXISTS
(SELECT NULL
FROM mtl_system_items_b i2
WHERE i2.organization_id = 1683
AND msi.inventory_item_id = i2.inventory_item_id);
BEGIN
FOR rec_item IN cur_item LOOP
ego_item_pub.assign_item_to_org(p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_inventory_item_id => rec_item.inventory_item_id,
p_item_number => rec_item.segment1,
p_organization_id => 1683,
p_organization_code => 'CQV',
p_primary_uom_code => rec_item.primary_uom_code,
x_return_status => x_return_status,
x_msg_count => x_msg_count);
dbms_output.put_line(x_return_status);
END LOOP;
END;
/