随笔分类 -  PO

采购模组
供应商 银行 SQL （转自ITPUB）
摘要：在此记录一下自己学习过程。新手，请多多指教，谢谢。 最近客户有需求，找出供应商对应的银行信息，查看了下网上帖子，发现都是从供应商及供应商地点层发起，去查找对应的银行信息，但是，供应商维护银行界面共有四个层级，依次为：供应商，地址，地址-业务实体，地点 四个层级分别可以关联银行账户... 阅读全文
posted @ 2014-07-28 15:04 我不卖豆腐 阅读(2751) 评论(1) 推荐(0)
po line received is canceled(恢复PO被取消的余量)
摘要：1張PO已部分收貨,後來由于某種原因,將部分收貨的PO明行取消,現在要對已收料的這一部分進行退貨處理,要怎麼做才好呢?[@more@]DATA COLLECTED===============COLLABORATION----------------Checked the following details over the OWC:- User created a PO for 5 lines- Received the lines 1,2,3,4 fully (line 5 is not received)- Cancelled lines 2,4 and 5- Now user want 阅读全文
posted @ 2013-12-17 16:30 我不卖豆腐 阅读(935) 评论(0) 推荐(0)
重新打开finally close的采购订单
该文被密码保护。
posted @ 2013-12-17 16:17 我不卖豆腐 阅读(2) 评论(0) 推荐(0)
Script to set the Purchase Order Status to ‘OPEN’(将采购订单重新打开)
摘要：Business Requirement: The finance user requests the IT team to change the PO status to OPEN as they are unable to match the incoming vendor invoices. The PO status is set to closed because of the previous legible transactions or some data corruption issues.Purpose: Set the Purchase Order Status to O 阅读全文
posted @ 2013-12-17 16:12 我不卖豆腐 阅读(919) 评论(0) 推荐(0)
oracle ebs 采购订单关闭之PL/SQL实现方法
摘要：应客户需求，需要写个脚本，批量关闭Bonus Item类型的采购订单，在metalink上搜索到一些方法，但是都测试不通。原来需要将代码生成一个并发程序。下面是测试成功的代码。1.首先创建一个存储过程，然后在存储过程中调用PO_ACTIONS.CLOSE_PO2.注册一个存储过程类型的并发程序3.在application中测试结果。CREATE OR REPLACE PROCEDURE xx_po_close ( err_buff OUT VARCHAR2, retcode OUT NUMBER, p_reason_desc VARCHAR2, p_po_from VARCHAR2, p_po 阅读全文
posted @ 2013-12-17 14:44 我不卖豆腐 阅读(1828) 评论(0) 推荐(0)
How To Join XLA_AE_HEADERS and RCV_TRANSACTIONS(子分类账到事务处理追溯)
摘要：Applies to: Oracle Inventory Management - Version: 12.0.6 and later [Release: 12 and later ] Information in this document applies to any platform. ***Checked for relevance on 7-Sep-2011*** Goal In Release 12, Subledger Accounting has been introduced for Procurement. As a part of Subledger Account... 阅读全文
posted @ 2013-09-30 10:23 我不卖豆腐 阅读(1138) 评论(0) 推荐(0)
查找事物处理来源
摘要：CREATE OR REPLACE FUNCTION cux_trans_source(p_trans_id NUMBER) RETURN VARCHAR2 IS ln_type_id NUMBER; ln_source_line_id NUMBER; ln_trx_source_line_id NUMBER; ln_source_type_id NUMBER; ln_transaction_source_id NUMBER; ls_type_name VARCHAR2(80); ... 阅读全文
posted @ 2012-05-29 18:08 我不卖豆腐 阅读(456) 评论(0) 推荐(0)
【轉】采购标准流程及底层分析
摘要：1、创建一采购订单创建一采购订单行系统默认设置发运行及分配行可以追加发运行及分配行如：创建一采购订单，编码为：5011050组织（PSH）物品BCD-16OS-DSELECT*FROMpo_headers_all phWHEREph.segment1 ='5011050'PO_HEADER_IDAGENT_ID14553201SELECT*FROMpo_lines_all plWHEREpl.po_header_id =14553;PO_LINE_ID16679SELECT*FROMpo_line_locations_all pllWHEREpll.po_header_id = 阅读全文
posted @ 2012-01-10 08:31 我不卖豆腐 阅读(653) 评论(0) 推荐(0)
Oracle EBS:PO 常用的查询及Tips
摘要：1.列出没有销售订单的内部采购订单---used to list all Internal Requisitions that do not have anassociated Internal Sales orderSelect RQH.SEGMENT1 REQ_NUM,RQL.LINE_NUM,RQL.REQUISITION_HEADER_ID ,RQL.REQUISITION_LINE_ID,RQL.ITEM_ID ,RQL.UNIT_MEAS_LOOKUP_CODE ,RQL.UNIT_PRICE ,RQL.QUANTITY ,RQL.QUANTITY_CANCELLED,RQL.QU 阅读全文
posted @ 2012-01-09 11:49 我不卖豆腐 阅读(3923) 评论(2) 推荐(0)
Oracle EBS:SQL 失效一揽子PO协议
摘要：1.查询一揽子PO：这里要注意的是：不同的付款条件,币种，税率，都会可能产生一张新的一揽子PO协议select pla.PO_LINE_ID, pla.PO_HEADER_ID, pla.ITEM_ID, msib.SEGMENT1 ITEM_CODE,pla.UNIT_PRICE, pla.ITEM_DESCRIPTION, pla.START_DATE, pla.EXPIRATION_DATE, pla.CANCEL_FLAG, pla.CLOSED_CODE, pha.PO_HEADER_ID, pha.VENDOR_ID, pha.VENDOR_SITE_ID, pha.TERMS_I 阅读全文
posted @ 2012-01-09 11:46 我不卖豆腐 阅读(687) 评论(0) 推荐(0)
Oracle EBS:追踪PO全过程
摘要：1.创建POPO_HEADERS_ALLselect po_header_id from po_headers_all where segment1 =;select * from po_headers_all where po_header_id =;po_lines_allselect * from po_lines_all where po_header_id =;po_line_locations_allselect * from po_line_locations_all where po_header_id =;po_distributions_allselect * from p 阅读全文
posted @ 2012-01-09 10:54 我不卖豆腐 阅读(4779) 评论(0) 推荐(0)