-
编辑 删除
删除数组元素
-- Created on 2013-9-16 by ADMINISTRATOR declare -- Local variables here i integer; TYPE tbl_test IS TABLE OF NUMBER INDEX BY PLS_INTEGER; v_tbl_test tbl_test;begin -- T...
-
编辑 删除
价目表中选不到已经分配组织的物料的原因
要设置配置文件 : QP:项目验证组织=>对应相应的职责
-
编辑 删除
R12 获取采购行税
SELECT qrslt.trx_id po_header_id ,qrslt.line_trx_user_key1 po_line_num &nbs...
-
编辑 删除
开发中碰到的11i与R12的一些区别 (转)
开发中碰到的11i与R12的一些区别 分类： Oracle 2011-08-05 09:17 515人阅读 评论(0) 收藏 举报 calendarreportnulloracle报表引擎简单的说1、架构变了，原来的SOB现在叫Ledger2、客户、供应商、税提升...
-
编辑 删除
AR收款相关汇总金额
ARP_PROCESS_RCTS.post_query_logic-- Created on 2013-8-2 by ADMINISTRATOR declare -- Local variables here i integer; v_cash_receipt_id number := 110152; x_std_reversal_possibl...
-
编辑 删除
AR：撤消收款核销记帐
-- Created on 2013-8-2 by ADMINISTRATOR declare -- Local variables here i integer; x_return_status varchar2(1); x_msg_count number; x_msg_data varchar2(2000); v_ca...
-
编辑 删除
AR收款核销记帐on_account
-- Created on 2013-8-2 by ADMINISTRATOR declare -- Local variables here i integer; x_return_status varchar2(1); x_msg_count number; x_msg_data varchar2(2000); v_ca...
-
编辑 删除
PO审请单用AME进行审批报APP-PO-14142 WF_Error-000: ORA-0000 normal EBS12.1.1
If AME is intentionally used, this is fixed by file version POXAPAPC.pld 120.18.12010000.3 or higher:1. Download and review the readme and pre-requisites for Patch 8352586:R12.PO.B 2. Ensu...
-
编辑 删除
订单相关金额API
declare x_subtotal number; x_discount number; x_charges number; x_tax number;beginoe_oe_totals_summary.ORDER_TOTALS(p_header_id => 190978 &nb...
-
编辑 删除
更新客户头
-- Created on 2013-7-8 by ADMINISTRATOR declare -- Local variables here i integer; g_module varchar2(30) := 'TCA_V2_API'; lrec_org hz_party_v2pub.organization_rec_...
-
编辑 删除
更新客户地址
-- Created on 2013-7-8 by ADMINISTRATOR declare -- Local variables here i integer; g_module varchar2(30) := 'TCA_V2_API'; l_loc_rec hz_loca...
-
编辑 删除
把OAF个性化显示出来
中文: PROFIEL 设置 =>个性化自助定义,设为是 FND：已启用“个性化区域”链接英文: Personalize Self-Service Defn ...
-
编辑 删除
创建AR收款
-- Created on 2013-7-17 by ADMINISTRATOR declare -- Local variables here i integer; v_attribute_rec Ar_receipt_api_pub.attribute_rec_type; v_receipt_num varchar2(30) := '2013...
-
编辑 删除
更新保留
-- Created on 2013-7-8 by ADMINISTRATOR declare -- Local variables here l_old_rsv_rec inv_reservation_global.mtl_reservation_rec_type; l_new_rsv_rec inv_reservation_global.mtl_reser...
-
编辑 删除
SO保留PO
-- Created on 2013-7-8 by ADMINISTRATOR declare -- Local variables here l_rsv_rec inv_reservation_global.mtl_reservation_rec_type; l_dummy_sn inv_reservation_global.serial_number_tb...
-
编辑 删除
SO保留库存
-- Created on 2013-7-8 by ADMINISTRATOR declare -- Local variables here l_rsv_rec inv_reservation_global.mtl_reservation_rec_type; l_dummy_sn inv_reservation_global.serial_number_tb...
-
编辑 删除
创建SO
-- Created on 2013-5-13 by ADMINISTRATOR declare -- Local variables here i integer; l_header_rec oe_order_pub.header_rec_...
-
编辑 删除
PO接收入库
-- Created on 2013-5-8 by ADMINISTRATOR declare -- Local variables here i integer; l_iface_rcv_header_rec rcv_headers_interface%rowtype; l_iface_rcv_transaction_rec rcv_transa...
-
编辑 删除
更新PO
-- Created on 2013-5-7 by ADMINISTRATOR declare -- Local variables here i integer; l_result number; x_api_errors po_api_errors_rec_type; l_error_message varchar2(31767);...
-
编辑 删除
创建PO
-- Created on 2013-5-7 by ADMINISTRATOR declare -- Local variables here i integer; l_header_rec&nb...
