Jenrry - 博客园

2018年11月26日

摘要： --close_batch --created by jenrry DECLARE x_message_count NUMBER; x_message_list VARCHAR2 (4000); x_return_status VARCHAR2 (2000); p_batch_header gme_batch_header%ROWTYPE; ... 阅读全文

posted @ 2018-11-26 16:37 Jenrry 阅读(377) 评论(0) 推荐(0)

Oracle EBS OPM convert dtl reservation

摘要： --convert_dtl_reservation --created by jenrry DECLARE l_reservation_rec mtl_reservations%ROWTYPE; l_qty_convert NUMBER; x_message_count NUMBER; x_message_list VARCHAR2... 阅读全文

posted @ 2018-11-26 16:36 Jenrry 阅读(333) 评论(0) 推荐(0)

Oracle EBS OPM update material txn

摘要： --update_material_txn --created by jenrry DECLARE p_mmti_rec mtl_transactions_interface%ROWTYPE; p_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl; x_return_status ... 阅读全文

posted @ 2018-11-26 16:35 Jenrry 阅读(522) 评论(0) 推荐(0)

Oracle EBS OPM complete step

摘要： --complete_step --created by jenrry DECLARE x_return_status VARCHAR2 (1); l_exception_material_tbl gme_common_pvt.exceptions_tab; l_batch_step_rec gme_batch_steps%R... 阅读全文

posted @ 2018-11-26 16:35 Jenrry 阅读(464) 评论(0) 推荐(0)

Oracle EBS OPM reshedule batch

摘要： --reschedule_batch --created by jenrry DECLARE x_message_count NUMBER; x_message_list VARCHAR2 (2000); x_return_status VARCHAR2 (2000); x_batch_header ... 阅读全文

posted @ 2018-11-26 16:34 Jenrry 阅读(304) 评论(0) 推荐(0)

Oracle EBS OPM complete batch

摘要： --complete_batch --created by jenrry SET serveroutput on DECLARE x_return_status VARCHAR2 (1); l_exception_material_tbl gme_common_pvt.exceptions_tab; l_batch_header_rec ... 阅读全文

posted @ 2018-11-26 16:34 Jenrry 阅读(420) 评论(0) 推荐(0)

Oracle EBS OPM 创建生产批

摘要： --创建生产批 --created by jenrry DECLARE x_message_count NUMBER; x_message_list VARCHAR2 (2000); x_return_status VARCHAR2 (1); p_batch_header gm... 阅读全文

posted @ 2018-11-26 16:33 Jenrry 阅读(714) 评论(0) 推荐(0)

Oracle EBS OPM release step

摘要： --release_step生产批 --created by jenrry SET serveroutput on DECLARE x_return_status VARCHAR2 (1); l_exception_material_tbl gme_common_pvt.exceptions_tab; l_batch_step_rec ... 阅读全文

posted @ 2018-11-26 16:33 Jenrry 阅读(299) 评论(0) 推荐(0)

Oracle EBS OPM 发放生产批

摘要： --发放生产批 --created by jenrry DECLARE x_return_status VARCHAR2 (1); l_exception_material_tbl gme_common_pvt.exceptions_tab; l_batch_header_rec gme_batch_header%ROWTYPE;... 阅读全文

posted @ 2018-11-26 16:32 Jenrry 阅读(256) 评论(0) 推荐(0)

Oracle EBS OPM 车间发料事务处理

摘要： --车间发料事物处理 --created by jenrry DECLARE l_iface_rec inv.mtl_transactions_interface%ROWTYPE; l_iface_lot_rec inv.mtl_transaction_lots_interface%ROWTYPE; l_cur_mfg_org_id NUMBER := 127; -... 阅读全文

posted @ 2018-11-26 16:31 Jenrry 阅读(726) 评论(0) 推荐(0)