OE_PROCESSING_MSGS _VL

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

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

• 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