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

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 )

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库Oracle EBS WIP-Example Work Order Interface - Resource add(2)在线全文阅读。