Order Management
Table Or View: Table
Important columns:
TRANSACTION_ID
MESSAGE_TEXT
HEADER_ID
LINE_ID
ORDER_SOURCE_ID
ORIGINAL_SYS_DOCUMENT_REF
ORIGINAL_SYS_DOCUMENT_LINE_REF
SOURCE_DOCUMENT_TYPE_ID
SOURCE_DOCUMENT_ID
SOURCE_DOCUMENT_LINE_ID
ORDER_NUMBER
ORDER_TYPE_ID
ORDER_TYPE
LINE_NUMBER
SHIPMENT_NUMBER
OPTION_NUMBER
ITEM
ORGANIZATION_ID
ORG_ID
MESSAGE_STATUS_CODE
MESSAGE_TEXT
HEADER_ID
LINE_ID
ORDER_SOURCE_ID
ORIGINAL_SYS_DOCUMENT_REF
ORIGINAL_SYS_DOCUMENT_LINE_REF
SOURCE_DOCUMENT_TYPE_ID
SOURCE_DOCUMENT_ID
SOURCE_DOCUMENT_LINE_ID
ORDER_NUMBER
ORDER_TYPE_ID
ORDER_TYPE
LINE_NUMBER
SHIPMENT_NUMBER
OPTION_NUMBER
ITEM
ORGANIZATION_ID
ORG_ID
MESSAGE_STATUS_CODE
Description:
This view is a view built on oe_processing_msgs and oe_processing_msgs_tlfor de-normalization to resolve multilingual issue and names for certain ids.
The view contains columns from below tables
The view contains columns from below tables
- OE_PROCESSING_MSGS
- OE_ORDER_HEADERS
- OE_ORDER_LINES
- OE_TRANSACTION_TYPES_TL
- FND_CONCURRENT_PROGRAMS_TL
- FND_CONCURRENT_REQUESTS
- FND_USER U
- WF_PROCESS_ACTIVITIES WPA
- WF_ACTIVITIES_TL WA
- OE_SOLD_TO_ORGS_V SO
- OE_PROCESSING_MSGS_TL MT
No comments:
Post a Comment