销售订单头表的订单编号生产规则

销售订单头表是 ont.oe_order_headers_all .
order number 是系統設定產生的流水號碼，設定 order mangager respobibility---》setup--> document-->define
Header_id 是用序列 OE_ORDER_HEADERS_S產生的，
Line_id 是用序列  OE_ORDER_LINES_S產生的，
Order_Number使用的序列你可以用下面的SQL 得到


SELECT FDS.DB_SEQUENCE_NAME,OTTT.NAME FROM 
FND_DOC_SEQUENCE_ASSIGNMENTS FDSA,
FND_DOCUMENT_SEQUENCES       FDS,
OE_TRANSACTION_TYPES_ALL     OTTA,
OE_TRANSACTION_TYPES_TL      OTTT
WHERE 1=1
AND   FDSA.DOC_SEQUENCE_ID=FDS.DOC_SEQUENCE_ID
AND   OTTA.TRANSACTION_TYPE_ID=OTTT.TRANSACTION_TYPE_ID
AND   OTTT.Language=USERENV('LANG')
AND   FDSA.CATEGORY_CODE=TO_CHAR(OTTA.TRANSACTION_TYPE_ID)
AND   OTTT.NAME='你定義得訂單類型'


具体系统中查询如下：
SELECT FDS.DB_SEQUENCE_NAME,OTTT.NAME FROM 
FND_DOC_SEQUENCE_ASSIGNMENTS FDSA,
FND_DOCUMENT_SEQUENCES       FDS,
OE_TRANSACTION_TYPES_ALL     OTTA,
OE_TRANSACTION_TYPES_TL      OTTT
WHERE 1=1
AND   FDSA.DOC_SEQUENCE_ID=FDS.DOC_SEQUENCE_ID
AND   OTTA.TRANSACTION_TYPE_ID=OTTT.TRANSACTION_TYPE_ID
AND   OTTT.Language=USERENV('LANG')
AND   FDSA.CATEGORY_CODE=TO_CHAR(OTTA.TRANSACTION_TYPE_ID)
AND   OTTT.NAME='24站超市销售订单'

结果：

1 FND_DOC_SEQ_429_S 24站超市销售订单

销售订单的序号是EBS后台生产的SEQUENCE

select FND_DOC_SEQ_429_S.NEXTVAL from dual;