DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.XNP_MSG_TYPES_VL

Object Details
Object Name: XNP_MSG_TYPES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXNP.XNP_MSG_TYPES_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


XNP_MSG_TYPES_VL is a multilingual view to table XNP_MSG_TYPES_B.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
MSG_CODE VARCHAR2 (20) Yes
MSG_TYPE VARCHAR2 (10) Yes
STATUS VARCHAR2 (10) Yes
PRIORITY NUMBER
Yes
QUEUE_NAME VARCHAR2 (40) Yes
PROTECTED_FLAG VARCHAR2 (1) Yes
ROLE_NAME VARCHAR2 (100)
LAST_COMPILED_DATE DATE

VALIDATE_LOGIC VARCHAR2 (4000)
IN_PROCESS_LOGIC VARCHAR2 (4000)
OUT_PROCESS_LOGIC VARCHAR2 (4000)
DEFAULT_PROCESS_LOGIC VARCHAR2 (4000)
DTD_URL VARCHAR2 (1996)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
DISPLAY_NAME VARCHAR2 (60) Yes
DESCRIPTION VARCHAR2 (1996)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      MSG_CODE
,      MSG_TYPE
,      STATUS
,      PRIORITY
,      QUEUE_NAME
,      PROTECTED_FLAG
,      ROLE_NAME
,      LAST_COMPILED_DATE
,      VALIDATE_LOGIC
,      IN_PROCESS_LOGIC
,      OUT_PROCESS_LOGIC
,      DEFAULT_PROCESS_LOGIC
,      DTD_URL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DISPLAY_NAME
,      DESCRIPTION
FROM APPS.XNP_MSG_TYPES_VL;

Dependencies

[top of page]

APPS.XNP_MSG_TYPES_VL references the following:

SchemaAPPS
SynonymXNP_MSG_TYPES_B
SynonymXNP_MSG_TYPES_TL
APPS.XNP_MSG_TYPES_VL is referenced by following:

SchemaAPPS
Package BodyXNP_CVU_PKG - show dependent code
Package BodyXNP_MSG_BUILDER - show dependent code