02 2012 档案
摘要：select per.party_id,per.person_id sales_resp_id,per.last_name sales_resp_name,per.full_name,fu.user_id from (--查询有效的用户 select per.party_id, per.person_id,per.last_name,per.full_name from PER_ALL_PEOPLE_F per where sysdate between per.effective_start_date and per.effective_end_date ) per, (--取有效的登...
阅读全文
posted @ 2012-02-29 13:23
摘要：Oracle sales tableselect * from AS_PERIOD_RATES where to_char(conversion_date,'yyyy')=2016select * from AS_PERIOD_DAYS where to_char(period_day,'yyyy')=2016当修改了总帐下的会计日历和汇率，需要运行以下三个请求，上边两张表才会产生数据.select * from GL_PERIODS_Vselect * from GL_DAILY_RATES_V请求刷新 AS_PERIOD_DAYS 表刷新多币种折换率 (AS
阅读全文
posted @ 2012-02-28 17:46
摘要：--加字段限定和不加字段限定结果不一样select *from oe_order_lines_ALL ol, oe_order_headers_ALL oh , hz_cust_accounts ca where ol.header_id=oh.header_id(+) and oh.sold_to_org_id = ca.cust_account_id(+) and ca.account_number =2925
阅读全文
posted @ 2012-02-24 13:19
摘要：select lp.*from( SELECT l.attribute1 project,l.attribute2 ptype ,litem.item , PARTY.PARTY_NAME customerName, L.TOTAL_AMOUNT totalAmount, L.WIN_PROBABILITY winProb , L.STATUS status, L.LEAD_ID leadID, L.SALES_METHODOLOGY_ID methodologyCode , 'DUMMY' updateableFlag, L.DECISION_DATE decisionDat
阅读全文
posted @ 2012-02-14 09:36
摘要：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
摘要：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
摘要：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
摘要：软件工程师考题姓名：日期：分数：一、 判断题（每题2分，共24分）在订单管理器里能进行订单的复制。( )订单行在“等待发运”状态下还可以删除。( )在订单管理器里不能查发到是否开系统发票。( )处理物料搬运单不可以按订单号查询。( )处理物料搬运单行分配时，可以选择不同批次的物料挑库。( )运行“库房事务处理”=》“杂项事务处理”时提示“APP-INV-05447：未找到输入日期的开放期”，可以通过打开采购会计期解决该问题。( )不同库存组织下的库存会计期是不需要分别更打开。( )一张收款单号可以核销多个客户的系统发票。( )在供应商维护模块，可以通过设置有效与否复选框来失效供应商。( )在定
阅读全文
posted @ 2012-02-08 15:46
摘要：select * from Secom_Hold_Order_V hold,OE_ORDER_LINES_ALL ool ,OE_ORDER_HEADERS_ALL oh where hold.LINE_ID=ool.line_id(+)and ool.header_id=oh.header_id(+)and oh.order_number in (1072565)
阅读全文
posted @ 2012-02-02 13:49
|
||
浙公网安备 33010602011771号