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

Object Details

Object Name:	AMW_HIERARCHY_ENTITIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMW.AMW_HIERARCHY_ENTITIES_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
PROCESS_REV_ID	NUMBER		Yes	Process Revision Identifier
PROCESS_DISPLAY_NAME	VARCHAR2	(80)	Yes	Process Display Name
PROCESS_ID	NUMBER		Yes	Process Identifier
NAME	VARCHAR2	(30)	Yes	Process Name
ITEM_TYPE	VARCHAR2	(8)	Yes	Process Item Type
SIGNIFICANT_PROCESS_FLAG	VARCHAR2	(1)		Indicates whether this is a significant process or not
STANDARD_PROCESS_FLAG	VARCHAR2	(1)		Indicates whether this is a standard process or not
APPROVAL_STATUS	VARCHAR2	(30)		Approval Status
RISK_COUNT	NUMBER			Number of risks attached to this process and its sub-processes
CONTROL_COUNT	NUMBER			Number of controls attached to this process and its sub-processes
ORG_COUNT	NUMBER			Number of organizations this process has been associated to
PROCESS_OWNER_ID	NUMBER			Process Owner Identification
PROCESS_OWNER_NAME	VARCHAR2	(360)		Process Owner Name
CERTIFICATION_STATUS_CODE	VARCHAR2	(30)		Process certification status lookup code
CERTIFICATION_STATUS	VARCHAR2	(4000)		Process certification status meaning
APPROVAL_STATUS_MEANING	VARCHAR2	(4000)		Process approval status lookup meaning
APPLICATION_OWNER_ID	NUMBER			Application owner identification
APPLICATION_OWNER_NAME	VARCHAR2	(360)		Application owner name
PROCESS_CATEGORY	VARCHAR2	(30)		Process Category lookup code
PROCESS_CATEGORY_MEANING	VARCHAR2	(4000)		Process Category lookup meaning
URLSTRING	VARCHAR2	(188)		Used to construct url for process name in UI
FINANCE_OWNER_ID	NUMBER			Process finance owner identifier
FINANCE_OWNER_NAME	VARCHAR2	(360)		Process finance owner name
RISKCNTURL	VARCHAR2	(191)		Used to construct url for risk count in UI
CTRLCNTURL	VARCHAR2	(191)		Used to construct url for control count in UI
ORGCNTURL	VARCHAR2	(191)		Used to construct url for organization count in UI
STANDARD_VARIATION	NUMBER			Identifier of the standard process that is listed as a variation for the non-standard current process

Query Text

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


SELECT PROCESS_REV_ID
,      PROCESS_DISPLAY_NAME
,      PROCESS_ID
,      NAME
,      ITEM_TYPE
,      SIGNIFICANT_PROCESS_FLAG
,      STANDARD_PROCESS_FLAG
,      APPROVAL_STATUS
,      RISK_COUNT
,      CONTROL_COUNT
,      ORG_COUNT
,      PROCESS_OWNER_ID
,      PROCESS_OWNER_NAME
,      CERTIFICATION_STATUS_CODE
,      CERTIFICATION_STATUS
,      APPROVAL_STATUS_MEANING
,      APPLICATION_OWNER_ID
,      APPLICATION_OWNER_NAME
,      PROCESS_CATEGORY
,      PROCESS_CATEGORY_MEANING
,      URLSTRING
,      FINANCE_OWNER_ID
,      FINANCE_OWNER_NAME
,      RISKCNTURL
,      CTRLCNTURL
,      ORGCNTURL
,      STANDARD_VARIATION
FROM APPS.AMW_HIERARCHY_ENTITIES_V;

Dependencies

[top of page]

APPS.AMW_HIERARCHY_ENTITIES_V references the following:

APPS: AMW_PROCESS; AMW_UTILITY_PVT - show dependent code; HZ_PARTIES; WF_ACTIVITIES; WF_ACTIVITIES_TL

APPS.AMW_HIERARCHY_ENTITIES_V is not referenced by any database object