[Home] [Help] [Dependency Information]
Object Name: | OE_PROCESSING_MSGS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ONT.OE_PROCESSING_MSGS_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
This view is a view built on oe_processing_msgs and oe_processing_msgs_tl for de-normalization to resolve multilingual issue and names for certain ids.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Yes | System Generated Id | |
REQUEST_ID | NUMBER | Concurrent request that last changed row | ||
MESSAGE_TEXT | VARCHAR2 | (2000) | This column holds the message | |
ENTITY_CODE | VARCHAR2 | (30) | Name of the Entity | |
ENTITY_ID | NUMBER | Entity Id | ||
HEADER_ID | NUMBER | This holds the header id against which the message is logged | ||
LINE_ID | NUMBER | This holds the Line id against which the message is logged | ||
ORDER_SOURCE_ID | NUMBER | This holds the order source. Will be used for Order Import | ||
ORIGINAL_SYS_DOCUMENT_REF | VARCHAR2 | (50) | This holds the order header source. Will be used for Order Import | |
ORIGINAL_SYS_DOCUMENT_LINE_REF | VARCHAR2 | (50) | This holds the order Line source. Will be used for Order Import | |
SOURCE_DOCUMENT_TYPE_ID | NUMBER | This holds the Type of the source like COPY ORDER | ||
SOURCE_DOCUMENT_ID | NUMBER | This holds the source header id. | ||
SOURCE_DOCUMENT_LINE_ID | NUMBER | This holds the source Line id | ||
ATTRIBUTE_CODE | VARCHAR2 | (30) | This will store Attribute name/code against which the message is generated. | |
PROGRAM_UPDATE_DATE | DATE | Last date changed by concurrent program | ||
PROGRAM_APPLICATION_ID | NUMBER | This will store concurrent program Application id against which the message is generated | ||
PROGRAM_ID | NUMBER | This will store concurrent program id against which the message is generated. | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CONSTRAINT_ID | NUMBER | This will store workflow constraint id against which the message is generated. | ||
PROCESS_ACTIVITY | NUMBER | This will store workflow process information against which the message is generated. | ||
NOTIFICATION_FLAG | VARCHAR2 | (1) | This flag indicates whether the notification has been sent or not. | |
ENTITY_REF | VARCHAR2 | (50) | Entity Reference | |
CHANGE_SEQUENCE | VARCHAR2 | (50) | Change sequence | |
ORIG_SYS_SHIPMENT_REF | VARCHAR2 | (50) | Source shipment number | |
TYPE | VARCHAR2 | (30) | This will store the severity of the message. | |
MESSAGE_SOURCE_CODE | VARCHAR2 | (30) | This indicates the source of the message(UI/ Con current / Workflow). | |
ORDER_NUMBER | NUMBER | |||
ORDER_TYPE_ID | NUMBER | |||
ORDER_TYPE | VARCHAR2 | (30) | ||
LINE_NUMBER | NUMBER | |||
SHIPMENT_NUMBER | NUMBER | |||
OPTION_NUMBER | NUMBER | |||
ITEM | VARCHAR2 | (2000) | ||
PROGRAM_NAME | VARCHAR2 | (240) | ||
CONCURRENT_PROGRAM_ID | NUMBER | |||
USER_NAME | VARCHAR2 | (100) | Application username (what a user types in at the Oracle Applications sign-on screen) | |
PROCESS_ACTIVITY_NAME | VARCHAR2 | (80) | ||
CUSTOMER_NAME | VARCHAR2 | (360) | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | |||
MESSAGE_STATUS_CODE | VARCHAR2 | (30) | This column holds the status value of the the message. | |
ORDER_CREATION_DATE | DATE | This holds Order Header Creation Date |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, REQUEST_ID
, MESSAGE_TEXT
, ENTITY_CODE
, ENTITY_ID
, 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
, ATTRIBUTE_CODE
, PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, CONSTRAINT_ID
, PROCESS_ACTIVITY
, NOTIFICATION_FLAG
, ENTITY_REF
, CHANGE_SEQUENCE
, ORIG_SYS_SHIPMENT_REF
, TYPE
, MESSAGE_SOURCE_CODE
, ORDER_NUMBER
, ORDER_TYPE_ID
, ORDER_TYPE
, LINE_NUMBER
, SHIPMENT_NUMBER
, OPTION_NUMBER
, ITEM
, PROGRAM_NAME
, CONCURRENT_PROGRAM_ID
, USER_NAME
, PROCESS_ACTIVITY_NAME
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, ORGANIZATION_ID
, ORG_ID
, MESSAGE_STATUS_CODE
, ORDER_CREATION_DATE
FROM APPS.OE_PROCESSING_MSGS_VL;
APPS.OE_PROCESSING_MSGS_VL is not referenced by any database object
|
|
|