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.HXC_APPROVAL_STYLES_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUSINESS_GROUP_ID	NUMBER	(15)		Business Group Id
LEGISLATION_CODE	VARCHAR2	(30)		Legislation Code
APPROVAL_STYLE_ID	NUMBER	(15)	Yes	Approval Style Id
NAME	VARCHAR2	(80)	Yes	Approval Style Name
DESCRIPTION	VARCHAR2	(2000)		Description of Approval Style
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number of Approval Style
RUN_RECIPIENT_EXTENSIONS	VARCHAR2	(1)		Run Recipient Extensions
ADMIN_ROLE	VARCHAR2	(320)		Admin Role
ERROR_ADMIN_ROLE	VARCHAR2	(320)		Error Admin Role
TIMEOUTS_ENABLED	VARCHAR2	(4000)		Timeout Enabled Flag
NUMBER_RETRIES	NUMBER			Number of retries if any.
APPROVER_TIMEOUT	NUMBER			Approver Timeout Value
PREPARER_TIMEOUT	NUMBER			Preparer Timeout Value
ADMIN_TIMEOUT	NUMBER			Admin Timeout Value
NOTIFY_SUPERVISOR	VARCHAR2	(4000)		Notify Supervisor Flag
NOTIFY_WORKER_ON_SUBMIT	VARCHAR2	(4000)		Notify Worker On Submit Flag
NOTIFY_WORKER_ON_AA	VARCHAR2	(4000)		Notify Worker On AA Flag
NOTIFY_PREPARER_APPROVED	VARCHAR2	(4000)		Notify Preparer Approved Flag
NOTIFY_PREPARER_REJECTED	VARCHAR2	(4000)		Notify Prepare on Rejected Flag
NOTIFY_PREPARER_TRANSFER	VARCHAR2	(4000)		Notify Preparer on Transfer Flag
CREATED_BY	NUMBER	(15)		Created By
CREATION_DATE	DATE			Creation Date
LAST_UPDATED_BY	NUMBER	(15)		Last Updated By
LAST_UPDATE_DATE	DATE			Last Updated Date
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Updated Login

Query Text

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


SELECT BUSINESS_GROUP_ID
,      LEGISLATION_CODE
,      APPROVAL_STYLE_ID
,      NAME
,      DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      RUN_RECIPIENT_EXTENSIONS
,      ADMIN_ROLE
,      ERROR_ADMIN_ROLE
,      TIMEOUTS_ENABLED
,      NUMBER_RETRIES
,      APPROVER_TIMEOUT
,      PREPARER_TIMEOUT
,      ADMIN_TIMEOUT
,      NOTIFY_SUPERVISOR
,      NOTIFY_WORKER_ON_SUBMIT
,      NOTIFY_WORKER_ON_AA
,      NOTIFY_PREPARER_APPROVED
,      NOTIFY_PREPARER_REJECTED
,      NOTIFY_PREPARER_TRANSFER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.HXC_APPROVAL_STYLES_V;

Dependencies

[top of page]

APPS.HXC_APPROVAL_STYLES_V references the following:

APPS: HXC_APPROVAL_STYLES; HXC_NOTIFICATION_HELPER - show dependent code

APPS.HXC_APPROVAL_STYLES_V is referenced by following:

APPS: HXC_NOTIFICATION_HELPER - show dependent code