Thursday, October 14, 2010

Orders Management Lookups

Lookup Type
Where used
FLOW_STATUS
OE_ORDER_HEADERS_ALL.flow_status_code
LINE_FLOW_STATUS
OE_ORDER_LINES_ALL.flow_status_code
CANCEL_CODE
OE_ORDER_LINES_HISTORY.reason_code where HIST_TYPE_CODE = 'CANCELLATION'
RELEASE_REASON
Column RELEASE_REASON_CODE of table OE_HOLD_RELEASES refers to this OE lookup. This code is required by OE_HOLDS_PUB.RELEASE_HOLDS API and RELEASE_REASON_CODE field of OE_HOLDS_PVT.HOLD_RELEASE_REC_TYPE

No comments:

Post a Comment