Oracle EBS http://space.itpub.net/11969955 Oracle EBS技术爱好者论坛：[ www.techwind.net ] Oracle EBS MSN 交流群 ：group199946@msnzone.cn 欢迎加入！ 朋友的原单外贸鞋店（做技术的，大多都厚道）： http://shoe1314.totaobao.com/ Copyright(C) Oracle EBS SupeSite/X-Space Tue, 07 Oct 2008 15:59:15 GMT 手电筒调用查询块 http://space.itpub.net/11969955/viewspace-364793 在要查询的块建立两个trigger:
PRE-QUERY:
    COPY(:BLOCK.ITEM, 'CMCC_FLEXFIELD_TEST.INVENTORY_ITEM_ID');
    APP_FIND.QUERY_RANGE(:BLOCK.ITEM,:BLOCK.ITEM,'CMCC_FLEXFIELD_TEST.INVENTORY_ITEM_ID');
  ...]]> blog OracleERPR12 Wed, 25 Jun 2008 11:37:14 GMT 弹性域的设计(flexfiled) http://space.itpub.net/11969955/viewspace-364791 1,

create table cmcc_flexfield_test
(
  HM_ID NUMBER,
  HM_STRUCTURE_ID NUMBER,
  username varchar2(30),
  INVENTORY_ITEM_ID              NUM...]]> blog OracleERPR12 Wed, 25 Jun 2008 11:29:16 GMT 供用户选择的Message http://space.itpub.net/11969955/viewspace-364788   
if (NOT FND_MESSAGE.WARN) then
  fnd_message.set_string('不提交'); --只有一个“确定”按钮
  fnd_message.show;
&nb...]]> blog OracleERPR12 Wed, 25 Jun 2008 11:25:34 GMT Oracle关于时间/日期的操作 http://space.itpub.net/11969955/viewspace-364785 1.日期时间间隔操作

当前时间减去7分钟的时间
select  sysdate,sysdate - interval '7' MINUTE  from dual
当前时间减去7小时的时间
select  sysdate - interval '7' hour  from dual
当前时间减去7天的时间
select  ...]]> blog OracleERPR12 Wed, 25 Jun 2008 11:21:42 GMT Row_number () over (partition by col1 order by col2)的用法 http://space.itpub.net/11969955/viewspace-364784 ROW_NUMBER() OVER (PARTITION BY COL1 ORDER BY COL2) --(其中，COL1，COL2可以为多列)
select xt.id,
       xt.item,
&...]]> blog OracleERPR12 Wed, 25 Jun 2008 11:03:41 GMT Start with connect by prior http://space.itpub.net/11969955/viewspace-364780 在SELECT命令中使用CONNECT BY 和蔼STAR...]]> blog OracleERPR12 Wed, 25 Jun 2008 10:56:55 GMT 行列转换 http://space.itpub.net/11969955/viewspace-364779

create table test(id varchar2(10),mc varchar2(50));

insert into test values('1','11111');
insert into test values('1','22222');
insert into test values('2','11111');
insert into te...]]> blog OracleERPR12 Wed, 25 Jun 2008 10:52:23 GMT 欢迎同行多交流 http://space.itpub.net/11969955/viewspace-53140 MSN:simon-hm@hotmail.com

留言请跟贴，谢谢！

Oracle EBS MSN 交流群 ：group199946@msnzone.cn 欢迎加入！


 

]]> blog OracleERPR12 Tue, 22 Apr 2008 10:39:00 GMT Account Inquiry (总账与子账的关联 - Cost Management - WIP) http://space.itpub.net/11969955/viewspace-234513 Select ac.je_source,
       ac.je_category,
       gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' ||
   &nbs...]]> blog OracleERPR12 Fri, 11 Apr 2008 17:44:29 GMT Account Inquiry (总账与子账的关联 - Cost Management - Receiving) http://space.itpub.net/11969955/viewspace-234512        pv.vendor_name,
       pv.segment1 Supplier_Num,
       pha.currency_code,
       ...]]> blog OracleERPR12 Fri, 11 Apr 2008 17:41:14 GMT Account Inquiry (总账与子账的关联 - Payables - Purchase Invoices) http://space.itpub.net/11969955/viewspace-234511        aila.line_number,
       aia.invoice_id,
       pha.segment1 PO_Number,
       pv.vendor_...]]> blog OracleERPR12 Fri, 11 Apr 2008 17:37:37 GMT Account Inquiry http://space.itpub.net/11969955/viewspace-227914 --Source:Cost Management,Category:Inventory
Select ac.je_source,
       ac.je_category,
       gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 || '.' ||
  &...]]> blog OracleERPR12 Thu, 03 Apr 2008 16:10:20 GMT 数组的用法（Record） http://space.itpub.net/11969955/viewspace-224970 好久没用了，突然用到，语法都忘了。

 

/*create table xxuts_record_test
(
 A number,
 b number
) 

select * from xxuts_record_test for update
*/

Declare

    &nbs...]]> blog OracleERPR12 Wed, 02 Apr 2008 16:21:24 GMT 在 oracle 10g 中訪問 SQL Server http://space.itpub.net/11969955/viewspace-219109 以前公司有Delphi + SQL Server的系统，后来新开发了一个系统9iAS + DB10G （有点类似于Oracle EBS），数据要用到SQL Server里的数据，然后我们在Oracle DB Server上配置了一下，可以直接从Oracle DB里访问SQL Server的表：

*********************************...]]> blog OracleERPR12 Fri, 28 Mar 2008 17:06:53 GMT 注册开发好的OAF页面到Application http://space.itpub.net/11969955/viewspace-219096 Deployment OAF Page To EBS:

详情看示例代码：

/*
OEXOEFRM
OE_OEXOEMOE.Key_Commit;
*/
Declare
l_header_rec Oe_Order_Pub.header_rec_type;
l_line_tbl Oe_Order_Pub.line_tbl_type;
l_line...]]> blog OracleERPR12 Fri, 15 Feb 2008 11:44:56 GMT OM interface开发的示例脚本 http://space.itpub.net/11969955/viewspace-53122

示例代码：

--Header

INSERT INTO oe_headers_iface_all
(order_category, operation_code,
order_source_id, orig_sys_document_ref,
order_type_id, created_by, creation_date,<...]]> blog OracleERPR12 Fri, 15 Feb 2008 11:44:39 GMT Inventory item interface的开发示例代码 http://space.itpub.net/11969955/viewspace-53123 INSERT into MTL_SYSTEM_ITEMS_INTERFACE
(SET_PROCESS_ID
,last_update_date
,last_updated_by
,last_update_login
,creation_date
,created_by
,organization_id
,organization_code
,seg...]]> blog OracleERPR12 Fri, 15 Feb 2008 11:44:20 GMT BOM的interface开发的示例代码 http://space.itpub.net/11969955/viewspace-53124

---- **** INSERT INTO BOM INTERFACE *****

insert into bom.bom_bill_of_mtls_interface
(last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
item_...]]> blog OracleERPR12 Fri, 15 Feb 2008 11:43:58 GMT PO模块，采购订单interface开发的示例代码 http://space.itpub.net/11969955/viewspace-53125 INSERT INTO po_headers_interface
(interface_header_id,
action,
batch_id,
po_header_id,
DOCUMENT_NUM,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
--LAST_UPD...]]> blog OracleERPR12 Fri, 15 Feb 2008 11:43:42 GMT PO模块PR的interface开发 http://space.itpub.net/11969955/viewspace-53126 INSERT INTO po_requisitions_interface_all
( transaction_id,
interface_source_code,
source_type_code,
requisition_type,
destination_type_code,
authorization_status,
batch_id,
prepa...]]> blog OracleERPR12 Fri, 15 Feb 2008 11:43:20 GMT WIP工单interface的开发示例代码 http://space.itpub.net/11969955/viewspace-53127

insert into wip_job_schedule_interface
(last_update_date,
last_updated_by,
last_updated_by_name,
creation_date,
created_by,
created_by_name,
last_update_login,
group_id,
s...]]> blog OracleERPR12 Fri, 15 Feb 2008 11:43:09 GMT Inventory 物料库存 mtl_transactions_interface 的开发示例代码 http://space.itpub.net/11969955/viewspace-53128 mtl_transactions_interface的开发:

比如杂收，杂发，物料库存数控制等。

注意item的属性控制。


INSERT INTO mtl_transactions_interface
(transaction_interface_id,
transaction_header_id,
source_code,
source_header_id,
s...]]> blog OracleERPR12 Fri, 15 Feb 2008 11:42:48 GMT Inventory onhand可用量查询API http://space.itpub.net/11969955/viewspace-53129 Inventory onhand可用量查询API

考虑预留


inv_quantity_tree_pub.query_quantities
(p_api_version_number => 1
, p_init_msg_lst => 'F'
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data...]]> blog OracleERPR12 Fri, 15 Feb 2008 11:42:18 GMT utl_smtp 发送邮件的实例 http://space.itpub.net/11969955/viewspace-53134

创建公用Package:

create or replace package xx_mail_api is

procedure sendmail(p_err_buf out varchar2
,p_ret_code out number
,p_sendor in varchar2
,p_recipients in varchar2
,p_subject in varchar2
,p_m...]]> blog OracleERPR12 Fri, 15 Feb 2008 11:41:57 GMT FND_PROGRAM API添加Concurrent到某一职责 http://space.itpub.net/11969955/viewspace-53135

BEGIN
IF NOT FND_PROGRAM.program_in_group(
program_short_name => 'XX_DETAIL_SALE_COST_PKG',<...]]> blog OracleERPR12 Fri, 15 Feb 2008 11:41:41 GMT