eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.UMX_REG_SERVICES_VL

Object Details

Object Name:	UMX_REG_SERVICES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.UMX_REG_SERVICES_VL
Subobject Name:
Status:	VALID

View Type

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

VL view for registration processes

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id
REG_SERVICE_CODE	VARCHAR2	(30)	Yes	See documentation for UMX_REG_SERVICES
REG_SERVICE_TYPE	VARCHAR2	(30)	Yes	See documentation for UMX_REG_SERVICES
WF_NOTIFICATION_EVENT_GUID	RAW	(16)	Yes	See documentation for UMX_REG_SERVICES
WF_BUS_LOGIC_EVENT_GUID	RAW	(16)		See documentation for UMX_REG_SERVICES
EMAIL_VERIFICATION_FLAG	VARCHAR2	(1)	Yes	See documentation for UMX_REG_SERVICES
APPLICATION_ID	NUMBER	(15)	Yes	See documentation for UMX_REG_SERVICES
START_DATE	DATE		Yes	See documentation for UMX_REG_SERVICES
CREATED_BY	NUMBER	(15)	Yes	See documentation for UMX_REG_SERVICES
CREATION_DATE	DATE		Yes	See documentation for UMX_REG_SERVICES
LAST_UPDATED_BY	NUMBER	(15)	Yes	See documentation for UMX_REG_SERVICES
LAST_UPDATE_DATE	DATE		Yes	See documentation for UMX_REG_SERVICES
LAST_UPDATE_LOGIN	NUMBER	(15)		See documentation for UMX_REG_SERVICES
SECURITY_GROUP_ID	NUMBER	(15)		See documentation for UMX_REG_SERVICES
END_DATE	DATE			See documentation for UMX_REG_SERVICES
WF_ROLE_NAME	VARCHAR2	(320)		See documentation for UMX_REG_SERVICES
REG_FUNCTION_ID	NUMBER			See documentation for UMX_REG_SERVICES
AME_APPLICATION_ID	NUMBER	(15)		See documentation for UMX_REG_SERVICES
AME_TRANSACTION_TYPE_ID	VARCHAR2	(50)		See documentation for UMX_REG_SERVICES
DISPLAY_NAME	VARCHAR2	(1000)	Yes	See documentation for UMX_REG_SERVICES
DESCRIPTION	VARCHAR2	(2000)	Yes	See documentation for UMX_REG_SERVICES
USAGE	VARCHAR2	(2000)		See documentation for UMX_REG_SERVICES

Query Text

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


SELECT ROW_ID
,      REG_SERVICE_CODE
,      REG_SERVICE_TYPE
,      WF_NOTIFICATION_EVENT_GUID
,      WF_BUS_LOGIC_EVENT_GUID
,      EMAIL_VERIFICATION_FLAG
,      APPLICATION_ID
,      START_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      END_DATE
,      WF_ROLE_NAME
,      REG_FUNCTION_ID
,      AME_APPLICATION_ID
,      AME_TRANSACTION_TYPE_ID
,      DISPLAY_NAME
,      DESCRIPTION
,      USAGE
FROM APPS.UMX_REG_SERVICES_VL;

Dependencies

[top of page]

APPS.UMX_REG_SERVICES_VL references the following:

APPS: UMX_REG_SERVICES_B; UMX_REG_SERVICES_TL

APPS.UMX_REG_SERVICES_VL is referenced by following:

APPS: ARI_SELF_REGISTRATION_PKG - show dependent code; UMX_REGISTRATION_PVT - show dependent code