|
摘要：
select * from(select crs.ACTUAL_START_DATE,crs.ACTUAL_COMPLETION_DATE, floor(to_number(crs.ACTUAL_COMPLETION_DATE- crs.ACTUAL_START_DATE )*24*60) as spanMinutes ,crs.PROGRAM from FND_CONC_REQ_SUMMARY_V crs where to_char( crs.ACTUAL_COMPLETION_DATE,'yyyy-mm-dd')='2012-02-10') a where 阅读全文
posted @ 2012-02-10 17:14 奥客 阅读(233) 评论(0) 推荐(0) 编辑
摘要：
select hp.status, hp.party_id, hca.cust_account_id, hp.PARTY_NUMBER CRM_CUST_NUMBER, hca.ACCOUNT_NUMBER ERP_CUST_NUMBER ,hp.PARTY_NAME ORGNAME ,hp.CATEGORY_CODE ,cust_class.sc_sort ,cust_class.sc_industry ,cust_address.PROVINCE ,hp.curr_fy_potential_revenue annual_rec --年收入 ,hp.employees_total --员工. 阅读全文
posted @ 2012-02-10 13:46 奥客 阅读(246) 评论(0) 推荐(0) 编辑
摘要：
SELECT ala.LEAD_ID, ala.DESCRIPTION,ala.CUSTOMER_ID,ala.ADDRESS_ID,ala.ATTRIBUTE1,ala.ATTRIBUTE10,ala.ATTRIBUTE4,ala.STATUS,ala.CHANNEL_CODE,ala.ATTRIBUTE5,ala.CLOSE_REASON,ala.ATTRIBUTE6,to_char(ala.DECISION_DATE, 'yyyy-mm-dd hh24:mi:ss') DECISION_DATE,ala.WIN_PROBABILITY,ala.ATTRIBUTE8,ala 阅读全文
posted @ 2012-02-10 13:41 奥客 阅读(273) 评论(0) 推荐(0) 编辑 |
||
