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_LATEST_REV_ORG_V

Object Details

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

View Type

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

View for all the latest revisions of organization processes.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DISPLAY_NAME	VARCHAR2	(80)
DESCRIPTION	VARCHAR2	(240)
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)
REVISION_NUMBER	NUMBER
PROCESS_ORG_REV_ID	NUMBER
START_DATE	DATE
APPROVAL_DATE	DATE
APPROVAL_END_DATE	DATE
DELETION_DATE	DATE
PROCESS_TYPE	VARCHAR2	(10)
CONTROL_ACTIVITY_TYPE	VARCHAR2	(30)
RL_PROCESS_REV_ID	NUMBER
STANDARD_VARIATION	NUMBER
PROCESS_CATEGORY	VARCHAR2	(30)

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_LATEST_REV_ORG_V;

Dependencies

[top of page]

APPS.AMW_LATEST_REV_ORG_V references the following:

APPS: AMW_PROCESS_NAMES_TL; AMW_PROCESS_ORGANIZATION

APPS.AMW_LATEST_REV_ORG_V is referenced by following:

APPS: AMW_CREATE_LINES_PKG - show dependent code; AMW_LOAD_RCM_ORG_DATA - show dependent code