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

VIEW: APPS.AMW_CURR_APPROVED_REV_ORG_V

Object Details
Object Name: AMW_CURR_APPROVED_REV_ORG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMW.AMW_CURR_APPROVED_REV_ORG_V
Subobject Name:
Status: VALID

View Type

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


View for current approved organization process revisions


[View Source]

Columns
Name Datatype Length Mandatory Comments
DISPLAY_NAME VARCHAR2 (80)
Process Display Name
DESCRIPTION VARCHAR2 (240)
Process 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

Process Revision Number
PROCESS_ORG_REV_ID NUMBER

Organization Process Revision Id
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

Standard Variation
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_CURR_APPROVED_REV_ORG_V;

Dependencies

[top of page]

APPS.AMW_CURR_APPROVED_REV_ORG_V references the following:

SchemaAPPS
SynonymAMW_PROCESS_NAMES_TL
SynonymAMW_PROCESS_ORGANIZATION
APPS.AMW_CURR_APPROVED_REV_ORG_V is referenced by following:

SchemaAPPS
Package BodyAMW_ORG_HIERARCHY_PKG - show dependent code