2013年3月7日
oracle ebs Customer Info
摘要： --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) ... 阅读全文
posted @ 2013-03-07 15:19 全威儒 阅读(3142) 评论(0) 推荐(0)
Oracle Customer Contacts Info
摘要： ---create custom objectCREATE OR REPLACE TYPE KOL_UNIT_TYPE AS OBJECT( ADDRESS_ID NUMBER (10), CUSTOMER_ID NUMBER (10), CONTACT1_FIRSTNAME VARCHAR2 (40), CONTACT1_LASTNAME VARCHAR2 (... 阅读全文
posted @ 2013-03-07 14:48 全威儒 阅读(1317) 评论(0) 推荐(0)
oracle 动态列
摘要： ---create custom object CREATE or replace TYPE unit_type AS OBJECT ( unit1 VARCHAR2(50) ,unit2 VARCHAR2(50) ,unit3 VARCHAR2(50) ,unit4 VARCHAR2(... 阅读全文
posted @ 2013-03-07 14:26 全威儒 阅读(5113) 评论(0) 推荐(0)