ITPub博客

在po_headers_all 中closed_code 状态'closed','closed for invoice','closed for receiving' 的区别[@more@]在oracle中，PO的状态除了“Final Close”外，都是没有实际控制作用的当接收完成后，shipment状态就会自动变为“close for receiving”，当发票匹配完成后，状态就会自动变为“close for invoice”。这两个都完成后，shipment的状态变为“close”。当所有的shipment都close后，PO的状态为close。 CLOSE 的PO是可以重新打开的这些状态仅仅是一个标志，没有实际控制作用。例如，在不设定接收容限的情况下，即使是“close for recei

两种方法 :mtl_onhand_quantities_detailmtl_material_transactions我只要找到批号相关的库位即可.批次控制是在物料属性那里设置的。对一个物料要么启用批次要么不启用批次。不可能一部分用批次，一部分不用批次吧[@more@]-- on_hand SELECT loc.subinventory_code sub, loc.segment1 || '.' || loc.segment2 || '.' || loc.segment3 || '.' || loc.segment4 locator, q.lot_number--ÅúºÅ, q.* FROM mtl_onhand_quantities_detail q, mtl_system_items_b ms

最后一位数字为校验位[@more@]/* Formatted on 2007/05/28 17:01 (Formatter Plus v4.8.7) */declare v_char varchar2(13);v_result varchar2(10);begin v_char:='EC186409676CN';SELECT ( 11 - MOD (( 8 * TO_NUMBER (SUBSTR (v_char, 3, 1)) + 6 * TO_NUMBER (SUBSTR (v_char, 4, 1)) + 4 * TO_NUMBER (SUBSTR (v_char, 5, 1)) + 2 * TO_NUMBER (SUBSTR (v_char, 6, 1)) + 3 * TO_NUMBER (SUBSTR (v_char, 7, 1)) + 5 * TO_NUMBER (SUBS

1、采购的概念（三方面）(1)采购what，向who采购，采购的price，when采购，采购的quality (2)采购活动，寻找供应商、收料、进料品检、拒收与发料；供应商评估、采购运输管理、采购品质管理、采购合同管理、付款条件管理、采购零组件的规则制定(3)采购目标[@more@]2、采购的文件内容（五部分）请购：Purchase Requisition (一般请购)Internal Requisition (内部请购)RFQ询价：Bid RFQ Catalog RFQ Standard RFQ Quotation 报价：Bid Quotation Catalog Quotation Standard QuotationPurchase Order 采购：Standard Purchase Order (标准采购

1.批次属性设置(FORM)2.产生批次挑库请求(一个VIEW， 两个table ),过程见DEMO PICK RELEASE ,比较复杂的请求3.批次挑库处理FORM 4. 通过API 进行结果导入[@more@]不能正常跑的原因:产生了邮寄号码仓库组织不对pick api 里面： p_release_mode => 'CONCURRENT', 如果改成ONLINE， 也是被系统支持的，但是 ， 不能正常PICK 同时也不能 提交请求 如果选择 CONCURRENT 如果有多个RECORD会提交多个请求！！！

advance shipment billing notices Oracle iSupplier Portal enables suppliers to create both advance shipment notices and advance shipment billing notices that alert the buying company of upcoming shipments. Oracle iSupplier portal also allows the supplier to expedite receipts and payments for the buying company. Suppliers can create shipment notices online or use a spreadsheet to upload shipment notices.[@more@]REF: http://en.wikipedia.org/wiki/Advance_ship_notice http://space.itpub.net/7434747/vi

单证系统里发票和核销单的对应[@more@]那你建另外一个表就对应呀 create table test ( ac_id number, order_id number, cancel_id number) alter table test add constraint PK_test primary key (ac_id, order_id,cancel_id) table a key 发票号码　 table b key 发票号码 核销单号码 ********************** 那就分成三个:两个实体表 发票 核销 一个关系表 发票-核销 ******************* 发票表　建一个主键　发票号码　　　核销表二个主键　 发票号码和核销单号码　二者统过发票号码关联就可以 **************

ORACLE采购接收的三维匹配和四维匹配问题 二维，就是验证：PO与invoice的数量与价格三维是验证：po,receipt和invoice的数量与价格四维是验证：po,receipt,inspect和invoice的数量与价格[@more@]ORACLE采购接收的三维匹配和四维匹配问题 通常都使用三维匹配。在采购选项设置中，默认值匹配审批层，可以设置四维匹配，但决定订单行取几维，还要看物料属性设定：采购选项卡中，发票匹配接收选项为要求接收、要求检验选择是；接收选项卡中接收方式选择检验。如此，系统会有限按照物料属性来决定订单的匹配纬度。如果物料属性不设

还有一种简单简单的办法，就是把pr_line和pr_header表连在一起，用括号括起来，作为一个子查询，去和po_line_locations_all做外关联--以上是网友ideal 的提议.Ideal 说:你连接得不对。不知要连pr_line表，其他的地方也要加上外联结--他说的原因.我想也是这样,一定是哪里有外连接,而我并不清楚.所以还是采用他的建议；就是把pr_line和pr_header表连在一起，用括号括起来，作为一个子查询，去和po_line_locations_all做外关联关于外连接以前只是字面上的理解,现在遇到了,才知道数据库的基础知识重要.再次感慨一下.[@more@]以前一直想解决的就

OM 中通过发票找Order headers和lines 等相关信息[@more@]SELECT oh.order_number, ol.line_number, SUBSTR (ol.ordered_item, 1, 2), wnd.waybill, wnd.creation_date, hp.party_name, oh.transactional_curr_code, ol.ordered_quantity, ol.UNIT_SELLING_PRICE FROM oe_order_headers_all oh, oe_order_lines_all ol, wsh_new_deliveries wnd, --delivery wsh_delivery_details wdd, wsh_delivery_assignments wda, hz_parties hp

picked ->shipped 中间的ship confirm 如何通过API实现 研究过程[@more@]FORM :/* Formatted on 2007/05/11 18:21 (Formatter Plus v4.8.7) */PROCEDURE do_action_ship_confirm (p_input_state IN NUMBER)ISBEGIN-- Ship Confirm Rule Changes-- If ship confirm rule id is null,then find these values-- else use defaulted values-- IF g_dlvy_defaults.sc_rule_id IS NULL THEN-- END IF;-- In the code below all the Global values are being used,-- these should have been set correctly on the basis of SC rule(if not nu

Example 1:This procedure can be used as an example on how to ship confirm a deliveryconsisting of delivery details that have already been pick released and assignedto a delivery.Call WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes API to update thecorresponding delivery details to ship all quantities in the first deliverydetail; to back order all in the second; to stage all in the third deliverydetail.Call WSH_FREIGHT_COSTS_PUB.Create_Update_Freight_Costs API to create freightcosts for the d

app-sqlap-10655:you cannnot match to this document .[@more@]1.先查找该页面的视图:得PO_LINE_LOCATIONS_INQ_V 2.查找到视图的栏位是哪个table 得到: po_line_locations_all --pll DECODE (pll.match_option, 'P', 'PO', 'R', 'Receipt', 'PO'), 3.所以是那里为'P',值为PO 不能match. select poh.segment1 --20601404 from po_headers_all poh, po_lines_all pol, po_line_locations_all poll, rcv_shipment_lines rsl, rcv_shipment_headers rsh where poh.po_

坏账损失的确认:债务单位已经撤销破产资不抵债现金流量严重不足发生严重自然灾害导致停产短期内无法偿付3年以上的应收账款[@more@]不能全额计提坏账准备:当年发生的应收款项计划对应收款项进行从重组与关联方发生的应收款项已逾期,但无确凿证据表明不能收回直接转销法,不计提还账准备,当坏账发生时,作为损失计入当期损益,同时冲销应收账款DR 管理费用CR 应收账款收回:DR: 应收账款CR:管理费用DR:银行存款CR:应收账款备抵法,<企业会计制度>规定,设置还账准备科目,按期估计坏账损失,形成坏账准备,当某一应收款全部或部分被确认为坏账的