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

TABLE: AMW.AMW_PROCESS_ORGANIZATION

Object Details
Object Name: AMW_PROCESS_ORGANIZATION
Object Type: TABLE
Owner: AMW
FND Design Data: TableAMW.AMW_PROCESS_ORGANIZATION
Subobject Name:
Status: VALID


This table stores information about association between processes and oraganizations


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMW_PROCESS_ORGANIZATION_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_ORG_REV_ID
AMW_PROCESS_ORGANIZATION_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_ID
ColumnORGANIZATION_ID
ColumnREVISION_NUMBER
AMW_PROCESS_ORGANIZATION_U4 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_ORGANIZATION_ID
ColumnREVISION_NUMBER
AMW_PROCESS_ORGANIZATION_U5 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnPROCESS_ID
ColumnEND_DATE
ColumnDELETION_DATE
ColumnAPPROVAL_DATE
ColumnAPPROVAL_END_DATE
AMW_PROCESS_ORGANIZATION_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESS_ID
ColumnEND_DATE
ColumnDELETION_DATE
ColumnAPPROVAL_DATE
AMW_PROCESS_ORGANIZATION_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnPROCESS_ID
ColumnSTANDARD_PROCESS_FLAG
ColumnEND_DATE
AMW_PROCESS_ORGANIZATION_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTANDARD_VARIATION
ColumnSTANDARD_PROCESS_FLAG
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
CONTROL_COUNT NUMBER

Count of the Controls associated to the organization
RISK_COUNT NUMBER

Count of the Risks associated to the organization
TOP_PROCESS_ID NUMBER

Top Process Identifier
PROCESS_ORGANIZATION_ID NUMBER
Yes Unique Identifier
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
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
APPLICATION_OWNER_ID NUMBER

Application Owner Identifier
PROCESS_OWNER_ID NUMBER

Process Owner Identifier
PROCESS_CATEGORY_CODE VARCHAR2 (30)
Process Category Code
SIGNIFICANT_PROCESS_FLAG VARCHAR2 (1)
Significant Process Flag
CREATED_FROM VARCHAR2 (30)
Not Used
REQUEST_ID NUMBER

Java Concurrent Program that uploads processes populates this column
PROGRAM_APPLICATION_ID NUMBER

Program Application Identifier
PROGRAM_ID NUMBER

Program Identifier
PROGRAM_UPDATE_DATE DATE

Program Update Date
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexifield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexifield Segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexifield Segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexifield Segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexifield Segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexifield Segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexifield Segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexifield Segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexifield Segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexifield Segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexifield Segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexifield Segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexifield Segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexifield Segment
SECURITY_GROUP_ID NUMBER

Used for hosted environments
OBJECT_VERSION_NUMBER NUMBER

This column is used for optimistic locking
END_DATE DATE

End Date
FINANCE_OWNER_ID NUMBER

Finance Owner Identifier
PROCESS_CODE VARCHAR2 (30)
Stores the Process code
REVISION_NUMBER NUMBER

Stores the process revision number
PROCESS_ORG_REV_ID NUMBER

Stores the process revision id specific to an organization
START_DATE DATE

Stores the start date
APPROVAL_DATE DATE

Stores the process approval date
APPROVAL_END_DATE DATE

Stores the process approval end date
DELETION_DATE DATE

Stores the deletion date
PROCESS_TYPE VARCHAR2 (10)
Stores the process type
CONTROL_ACTIVITY_TYPE VARCHAR2 (30)
Store the control activity type
RL_PROCESS_REV_ID NUMBER

Stores the risk library process rev id
STANDARD_VARIATION NUMBER

Stores the standard process id
PROCESS_CATEGORY VARCHAR2 (30)
Stores the process category
RISK_COUNT_LATEST NUMBER

Stores the latest risk count
CONTROL_COUNT_LATEST NUMBER

Stores the Latest control count
CLASSIFICATION NUMBER

Stores the process classification
Query Text

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


SELECT CONTROL_COUNT
,      RISK_COUNT
,      TOP_PROCESS_ID
,      PROCESS_ORGANIZATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      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
,      APPLICATION_OWNER_ID
,      PROCESS_OWNER_ID
,      PROCESS_CATEGORY_CODE
,      SIGNIFICANT_PROCESS_FLAG
,      CREATED_FROM
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      END_DATE
,      FINANCE_OWNER_ID
,      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
,      RISK_COUNT_LATEST
,      CONTROL_COUNT_LATEST
,      CLASSIFICATION
FROM AMW.AMW_PROCESS_ORGANIZATION;

Dependencies

[top of page]

AMW.AMW_PROCESS_ORGANIZATION does not reference any database object

AMW.AMW_PROCESS_ORGANIZATION is referenced by following:

SchemaAPPS
SynonymAMW_PROCESS_ORGANIZATION