insert into wsm.wsm_lot_move_txn_interface
(status,last_update_date,
last_updated_by,creation_date,
created_by,group_id,
source_line_id,organization_id,
header_id,wip_entity_id,
wip_entity_name,jump_flag,
transaction_type,transaction_uom,
entity_type,transaction_date,
fm_operation_seq_num,
fm_operation_code,
fm_department_id,
fm_department_code,fm_intraoperation_step_type,
to_operation_seq_num,to_operation_code,
to_department_id,to_department_code,
to_intraoperation_step_type,transaction_quantity,
scrap_quantity,scrap_at_operation_flag)
VALUES(1,sysdate,8299,sysdate,
8299,wsm_lot_move_txn_interface_s.NEXTVAL,
333,107,wsm_lot_move_txn_interface_s.NEXTVAL,
1957088,'JOHNTEST006','N',
4,'EA',5,sysdate,110,--fm_operation_seq_num
'PACK',
74,'PACK',
1,
100,'OQC',
73,'OQC',
1,100,0,1);
|