在Oracle库存模块中进行帐龄分析

不经意间发现还有这样一个功能点：（Enable profile INV:FIFO For Receipt Date）一但这个Profile开启，系统的现有量表中就会记录最早入库的时间。如果一个Item两次入库到同一个货位，则表中的记录就会有两行。虽然在界面中只会看到一条记录。如果这个Profile关闭，系统中的最早入库时间就是最后一次事务处理时间。如果一个Item两次入库，表中只有一行汇总记录。
下面是简单的测试记录。
====================================Defined a new item TEST001FIFO.PROJETStep1: PO# 10188 purchased 100 Unit---------------Step2: 2009-8-26 8:55:59 Receive-Deliver 87 Unit to locator APSA.A.0001.99080050.1Step3: Transfer 13 Unit form APSA.A.0001.99080050.1 to locator APSA.B.0001.99080050.1Step4: 2009-8-26 9:20:51 Receive-87-Deliver-50 Unit to locator APSA.B.0001.99080050.1On-hand ResultQUANTITY LOCATOR_ID Locator orig_date_received
13 266 locator APSA.B.0001.99080050.1 2009-8-26 8:55:59
50 266 locator APSA.B.0001.99080050.1 2009-8-26 9:20:51
74 264 APSA.A.0001.99080050.1 2009-8-26 8:55:59 We can see the original received date, but we cannot trace back to a certain PO#.---------------Step5: Transfer 3 Unit form locator APSA.B.0001.99080050.1 to APSA.A.0001.99080050.1Step6: Issue 7 Unit from APSA.A.0001.99080050.1Step7: Issue 8 Unit from locator APSA.B.0001.99080050.1On-hand ResultQUANTITY LOCATOR_ID Locator orig_date_received
2 266 locator APSA.B.0001.99080050.1 2009-8-26 8:55:59
50 266 locator APSA.B.0001.99080050.1 2009-8-26 9:20:51
70 264 APSA.A.0001.99080050.1 2009-8-26 8:55:59 Oracle asm 添加磁盘组Oracle11生成AWR报告相关资讯 oracle

[INS-32052] Oracle基目录和Oracle （07/22/2014 07:41:41）
Oracle 4个大对象（lobs）数据类型（02/03/2013 12:33:05）
Oracle按时间段分组统计（07/26/2012 10:36:48）

[Oracle] dbms_metadata.get_ddl的（07/12/2013 07:37:30）
Liferay Portal 配置使用Oracle和（07/31/2012 20:07:18）
Concurrent Request:Inactive （07/20/2012 07:44:05）

本文评论查看全部评论（0）