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_INACTIVE_REV_ORG_V

Object Details

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

View Type

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

View for end dated organization process revisions

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DISPLAY_NAME	VARCHAR2	(80)		Display Name
DESCRIPTION	VARCHAR2	(240)		Description
CONTROL_COUNT	NUMBER			Count of the Controls associated to the organization
RISK_COUNT	NUMBER			Count of the Risks associated to the organization
PROCESS_ORGANIZATION_ID	NUMBER		Yes	Unique Identifier
PROCESS_ID	NUMBER			Process Identifier
STANDARD_PROCESS_FLAG	VARCHAR2	(1)		Standard Process Flag
RISK_CATEGORY	VARCHAR2	(30)		Risk Category
APPROVAL_STATUS	VARCHAR2	(30)		Approval Status
CERTIFICATION_STATUS	VARCHAR2	(30)		Certification Status
LAST_AUDIT_STATUS	VARCHAR2	(30)		Last Audit Status
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
LAST_CERTIFICATION_DATE	DATE			Last Certification Date
LAST_AUDIT_DATE	DATE			Last Audit Date
NEXT_AUDIT_DATE	DATE			Next Audit Date
PROCESS_CATEGORY_CODE	VARCHAR2	(30)		Process Category Code
SIGNIFICANT_PROCESS_FLAG	VARCHAR2	(1)		Significant Process Flag
END_DATE	DATE			End Date
PROCESS_CODE	VARCHAR2	(30)		Process Code
REVISION_NUMBER	NUMBER			Revision Number
PROCESS_ORG_REV_ID	NUMBER			Organization process revision number
START_DATE	DATE			Start date
APPROVAL_DATE	DATE			Approval Date
APPROVAL_END_DATE	DATE			Approval End Date
DELETION_DATE	DATE			Deletion Date
PROCESS_TYPE	VARCHAR2	(10)		Process Type
CONTROL_ACTIVITY_TYPE	VARCHAR2	(30)		Control activity type
RL_PROCESS_REV_ID	NUMBER			Risk library process revision id
STANDARD_VARIATION	NUMBER			The standard process id
PROCESS_CATEGORY	VARCHAR2	(30)		Process Category

Query Text

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


SELECT DISPLAY_NAME
,      DESCRIPTION
,      CONTROL_COUNT
,      RISK_COUNT
,      PROCESS_ORGANIZATION_ID
,      PROCESS_ID
,      STANDARD_PROCESS_FLAG
,      RISK_CATEGORY
,      APPROVAL_STATUS
,      CERTIFICATION_STATUS
,      LAST_AUDIT_STATUS
,      ORGANIZATION_ID
,      LAST_CERTIFICATION_DATE
,      LAST_AUDIT_DATE
,      NEXT_AUDIT_DATE
,      PROCESS_CATEGORY_CODE
,      SIGNIFICANT_PROCESS_FLAG
,      END_DATE
,      PROCESS_CODE
,      REVISION_NUMBER
,      PROCESS_ORG_REV_ID
,      START_DATE
,      APPROVAL_DATE
,      APPROVAL_END_DATE
,      DELETION_DATE
,      PROCESS_TYPE
,      CONTROL_ACTIVITY_TYPE
,      RL_PROCESS_REV_ID
,      STANDARD_VARIATION
,      PROCESS_CATEGORY
FROM APPS.AMW_INACTIVE_REV_ORG_V;

Dependencies

[top of page]

APPS.AMW_INACTIVE_REV_ORG_V references the following:

APPS: AMW_PROCESS_NAMES_TL; AMW_PROCESS_ORGANIZATION

APPS.AMW_INACTIVE_REV_ORG_V is not referenced by any database object