Oracle EBS WIP-Example Work Order Interface - Resource add(2)

2019-01-26 19:58

BOM_RESOURCES, or use package BOM_RESOURCES_PKG).

Then you will have to assign your resource to a department (please refer to package BOM_DEPARTMENT_RESOURCES_PKG).

Here is an 11i code that I know works for update. Make sure you perform both inserts. Chage load type to indicate add.

Try it insert

into wip_job_dtls_interface i

(wip_entity_id,organization_id ,group_id ,inventory_item_id_new ,inventory_item_id_old ,load_type ,operation_seq_num ,process_phase,process_status ,substitution_type ,last_update_date,last_updated_by,creation_date,created_by ,parent_header_id ,QUANTITY_PER_ASSEMBLY ) values

(396371,101--wip_entity_id,organization_id ,421827--group_id ,24951--inventory_item_id_new 01-008210 ,22676--inventory_item_id_old 01-001614-04 ,2--load_type ,70--operation_seq_num ,2,1--process_phase,process_status ,3--substitution_type1=>delete2=>add,3>modify ,sysdate,1072,sysdate,1072 ,396371--header_id ,5 --qty per assy )

insert

into wip_job_schedule_interface

(load_type, process_phase, process_status, group_id ,wip_entity_id,organization_id

,creation_date,created_by,last_update_date,last_updated_by ,header_id) values

(3 -- load type update ,2 -- process_phase ,1 -- process_status ,421827 -- group_id ,396371,101

,sysdate,1072,sysdate,1072 ,396371--header_id )


Oracle EBS WIP-Example Work Order Interface - Resource add(2).doc 将本文的Word文档下载到电脑 下载失败或者文档不完整,请联系客服人员解决!

下一篇:2013-2014学年特训班理综测试卷10919

相关阅读
本类排行
× 注册会员免费下载(下载后可以自由复制和排版)

马上注册会员

注:下载文档有可能“只有目录或者内容不全”等情况,请下载之前注意辨别,如果您已付费且无法下载或内容有问题,请联系我们协助你处理。
微信: QQ: