2011年11月_QQ51567242

转载在Procedure中提交请求及请求等待

V_LAYOUT := FND_REQUEST.ADD_LAYOUT('MEW' ,'MEWSHIPNBS' ,NULL ,NULL

2011-11-22 15:56:07 445

转载 INV模块常用SQL

--用户物料类型SELECT * FROM FND_COMMON_LOOKUPS FCL WHERE FCL.LOOKUP_TYPE = 'ITEM_TYPE' AND FCL.ENABLED_FLAG = 'Y'1. --物料类别集SELECT * FROM MTL_CATEGORY_SETS MCS WHERE MCS.CATEGORY_SET

2011-11-22 14:31:22 2526

转载应收发票相关脚本

--应收发票主表SELECT * FROM RA_CUSTOMER_TRX_ALL A WHERE A.TRX_NUMBER = '156640' AND A.ORG_ID = 236;--应收发票行表SELECT B.EXTENDED_AMOUNT --不含税原币金额 ,B.EXTENDED_ACCTD_AMOUNT --不含税本币金额

2011-11-18 17:09:14 2055

转载客户信息获取

--1 HZ_CUST_ACCOUNTS(Cust_account_id & account_number & orig_system_reference) 客户编号SELECT * FROM HZ_CUST_ACCOUNTS HCA WHERE HCA.ACCOUNT_NUMBER = 'B80022701';--2 HZ_PARTIES(PARTY_ID & PARTY_NUMBER)

2011-11-16 15:25:01 1181

转载日期格式转换

--1. SQL> SELECT TO_CHAR(TRUNC(SYSDATE) + 0.99999 2 ,'yyyymmdd hh24:mi:ss') 3 FROM DUAL 4 / TO_CHAR(TRUNC(SYSDATE)+0.99999------------------------------20111115

2011-11-15 11:16:32 444

转载 ORACLE EBS AP发票到付款的数据流

--1.发票创建时生成数据如下表--发票主表SELECT * FROM AP_INVOICES_ALL A WHERE A.INVOICE_NUM = '20111213001';--发票分配表SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL B WHERE B.INVOICE_ID = 697444;--发票付款计划表SELECT *

2011-11-10 13:58:35 2799

转载如何查找ORACLE EBS锁

SELECT A.OBJECT_ID ,A.OBJECT_NAME ,A.OBJECT_TYPE ,B.LOCKED_MODE ,B.PROCESS ,B.SESSION_ID SID ,S.SERIAL# ,'alter system kill session ''' || B.SESSION_ID

2011-11-08 15:17:32 837

转载字符串中单引号的应用

SELECT '''' || REPLACE('293,228,255,983,228' ,',' ,''',''') || '''' FROM DUAL

2011-11-08 15:17:14 606

储藏室