add

About Me

My photo
Oracle Apps - Techno Functional consultant

Wednesday, November 23

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

No comments: