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

VIEW: APPS.AMW_PROCESS_BASICINFO_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view returns basic information about Process


[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (30) Yes Process Name
DISPLAY_NAME VARCHAR2 (80) Yes Process Display Name
PROCESS_CATEGORY VARCHAR2 (30)
Process Category
ITEM_TYPE VARCHAR2 (8) Yes Item Type
VERSION NUMBER
Yes Version
SIGNIFICANT_PROCESS_FLAG VARCHAR2 (1)
Significant Process Flag
STANDARD_PROCESS_FLAG VARCHAR2 (1)
Standard Process Flag
APPROVAL_STATUS VARCHAR2 (30)
Approval Status
CERTIFICATION_STATUS VARCHAR2 (30)
Certification Status
PROCESS_OWNER_ID NUMBER

Process Owner Identifier
PROCESS_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
CREATED_FROM VARCHAR2 (30)
Not Used
REQUEST_ID NUMBER

Java Concurrent Program that does the process upload 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
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexifield
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexifield
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexifield
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexifield
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexifield
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexifield
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexifield
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexifield
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexifield
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexifield
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexifield
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexifield
SECURITY_GROUP_ID NUMBER

Used for hosted environments
OBJECT_VERSION_NUMBER NUMBER

This column is used for optimistic locking
CONTROL_COUNT NUMBER

Count of the Controls associated with this process
RISK_COUNT NUMBER

Count of the Risks associated with this process
FINANCE_OWNER_ID NUMBER

Finance Owner Identifier
APPLICATION_OWNER_ID NUMBER

Application Owner Identifier
Query Text

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


SELECT NAME
,      DISPLAY_NAME
,      PROCESS_CATEGORY
,      ITEM_TYPE
,      VERSION
,      SIGNIFICANT_PROCESS_FLAG
,      STANDARD_PROCESS_FLAG
,      APPROVAL_STATUS
,      CERTIFICATION_STATUS
,      PROCESS_OWNER_ID
,      PROCESS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      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
,      CONTROL_COUNT
,      RISK_COUNT
,      FINANCE_OWNER_ID
,      APPLICATION_OWNER_ID
FROM APPS.AMW_PROCESS_BASICINFO_V;

Dependencies

[top of page]

APPS.AMW_PROCESS_BASICINFO_V references the following:

SchemaAPPS
SynonymAMW_PROCESS
SynonymWF_ACTIVITIES
SynonymWF_ACTIVITIES_TL

APPS.AMW_PROCESS_BASICINFO_V is not referenced by any database object