[Home] [Help] [Dependency Information]
Object Name: | OKC_QA_LIST_PROCESSES |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_QA_LIST_PROCESSES |
Subobject Name: | |
Status: | VALID |
The usage of a PROCESS DEF in a particular QA CHECK LIST.
Also defined are the severity of the check (failure or warning), the order in which it is to be run, and whether the check is active or not.
In order to be eligible to be used in this manner, the OKC_PROCESS_DEF must have the USAGE set to 'QA'.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_QA_LIST_PROCESSES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
QCL_ID
PDF_ID RUN_SEQUENCE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PDF_ID | NUMBER | Yes | Foreign key to OKC_PROCESS_DEFS_B. | |
QCL_ID | NUMBER | Yes | ID of QA check list associated with this QA process. | |
SEVERITY | VARCHAR2 | (3) | Yes | QA Severity. |
ACTIVE_YN | VARCHAR2 | (3) | Yes | Indicates if the QA process is in use.. |
RUN_SEQUENCE | NUMBER | (4) | Yes | Run sequence number. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column. | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
ACCESS_LEVEL | VARCHAR2 | (3) | Indicates the protection level of the record |
Cut, paste (and edit) the following text to query this object:
SELECT PDF_ID
, QCL_ID
, SEVERITY
, ACTIVE_YN
, RUN_SEQUENCE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, ACCESS_LEVEL
FROM OKC.OKC_QA_LIST_PROCESSES;
OKC.OKC_QA_LIST_PROCESSES does not reference any database object
OKC.OKC_QA_LIST_PROCESSES is referenced by following:
|
|
|