--以下代码于20180117在Tony环境实现
DECLARE
l_item_rec inv_item_grp.item_rec_type;
x_item_rec inv_item_grp.item_rec_type;
x_error_tbl inv_item_grp.error_tbl_type;
x_return_status VARCHAR2(1);
l_user_id NUMBER := 1110; --User ID, Sysadmin here
l_cur_mfg_org_id NUMBER := 83; --Current Inv Organization
-- SELECT * FROM ORG_ORGANIZATION_DEFINITIONS
-- SELECT * FROM MTL_SYSTEM_ITEMS_B MSI
BEGIN
--Initialize first, or create_by will be -1
fnd_global.apps_initialize(user_id => 1110,
resp_id => 50597,
resp_appl_id => 20003);
--Item
l_item_rec.item_number := '2010230020';
l_item_rec.inventory_item_status
DECLARE
l_item_rec inv_item_grp.item_rec_type;
x_item_rec inv_item_grp.item_rec_type;
x_error_tbl inv_item_grp.error_tbl_type;
x_return_status VARCHAR2(1);
l_user_id NUMBER := 1110; --User ID, Sysadmin here
l_cur_mfg_org_id NUMBER := 83; --Current Inv Organization
-- SELECT * FROM ORG_ORGANIZATION_DEFINITIONS
-- SELECT * FROM MTL_SYSTEM_ITEMS_B MSI
BEGIN
--Initialize first, or create_by will be -1
fnd_global.apps_initialize(user_id => 1110,
resp_id => 50597,
resp_appl_id => 20003);
--Item
l_item_rec.item_number := '2010230020';
l_item_rec.inventory_item_status