Oracle EBS OM 预留和挑选
如何使表MTL_RESERVATIONS和表oe_order_lines_all之间的联接关系?
DEMAND_SOURCE_LINE_ID NUMBER Line ID for demand source.
For Sales Order: OE_ORDER_LINES.LINE_ID
MTL_TRX_SOURCE_TYPES.Transaction_Source_type_id=MTL_REVERSATIONS.Demand_Source_type_id, OE_order_lines_all.Line_id=MTL_REVERSATIONS.Demand_Source_Line_id,)然后MTL_TRX_SOURCE_TYPES.Transaction_Source_type_Name='Sales Order'
---------------------------------------------------
WSH_DELIVERY_DETAILS.RELEASED_STATUS的意義
B Backordered Line failed to be allocated in Inventory
C Shipped Line has been shipped
D Cancelled Line is Cancelled
I Interfaced Line has been shipped and interfaced to Order Management and Inventory
N Not Ready to Release Line is not ready to be released
R Ready to Release Line is ready to be released
S Released to Warehouse Line has been released to Inventory for processing
X Not Applicable Line is not applicable for Pick Release
Y Staged/Pick Confirmed Line has been picked and staged by Inventory
相关文档:
本系列文章导航
[Oracle]高效的PL/SQL程序设计(一)--伪列ROWNUM使用技巧
[Oracle]高效的PL/SQL程序设计(二)--标量子查询
[Oracle]高效的PL/SQL程序设计(三)--Package的优点
[Oracle]高效的PL/SQL程序设计(四)--批量处理
[Oracle]高效的PL/SQL程序设计(五)--调用存储过程返回结果集
[Oracle]高效的PL/SQL程序设计(六)- ......
update :单表的更新不用说了,两者一样,主要说说多表的更新
Oracle> Oracle的多表更新要求比较严格,所以有的时候不是很好写,我们可以试试Oracle的游标
&n ......
MySQL Data Type
Oracle Data Type
BIGINT
NUMBER(19, 0)
BIT
RAW
BLOB
BLOB, RAW
CHAR
CHAR
DATE
DATE
DATETIME
DATE
DECIMAL
FLOAT (24)
DOUBLE
FLOAT (24)
DOUBLE PRECISION
FLOAT (24)
ENUM
VARCHAR2
FLOAT
FLOAT
INT
NUMBER(10, 0)
INTEGER
NUMBER(10, 0)
LONGBLOB
BLOB, RAW
LONGTEX ......
oracle表空间操作详解
1
2
3作者: 来源: 更新日期:2006-01-04
5
6
7建立表空间
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......