Thursday, April 10, 2008

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
SALES_CHANNEL Column SALES_CHANNEL_CODE of table HZ_CUST_ACCOUNTS

No comments:

Post a Comment