[Home] [Help] [Dependency Information]
Object Name: | OKC_QA_ERRORS_T |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_QA_ERRORS_T |
Subobject Name: | |
Status: | VALID |
Temporary table to store quality assurance check errors and warnings
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_QA_ERRORS_T_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SEQUENCE_ID |
OKC_QA_ERRORS_T_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
DOCUMENT_TYPE
DOCUMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOCUMENT_TYPE | VARCHAR2 | (30) | ||
DOCUMENT_ID | NUMBER | |||
SEQUENCE_ID | NUMBER | Yes | ||
ERROR_RECORD_TYPE | VARCHAR2 | (30) | Yes | |
TITLE | VARCHAR2 | (240) | ||
ARTICLE_ID | NUMBER | |||
DELIVERABLE_ID | NUMBER | |||
SECTION_NAME | VARCHAR2 | (240) | ||
ERROR_SEVERITY | VARCHAR2 | (1) | Yes | |
QA_CODE | VARCHAR2 | (30) | ||
MESSAGE_NAME | VARCHAR2 | (30) | ||
PROBLEM_SHORT_DESC | VARCHAR2 | (2000) | ||
PROBLEM_DETAILS | VARCHAR2 | (2000) | ||
PROBLEM_DETAILS_SHORT | VARCHAR2 | (2000) | ||
SUGGESTION | VARCHAR2 | (2000) | ||
CREATION_DATE | DATE | Yes | ||
REFERENCE_COLUMN1 | VARCHAR2 | (2000) | ||
REFERENCE_COLUMN2 | VARCHAR2 | (2000) | ||
REFERENCE_COLUMN3 | VARCHAR2 | (2000) | ||
REFERENCE_COLUMN4 | VARCHAR2 | (2000) | ||
REFERENCE_COLUMN5 | VARCHAR2 | (2000) | ||
ERROR_RECORD_TYPE_NAME | VARCHAR2 | (2000) | ||
ERROR_SEVERITY_NAME | VARCHAR2 | (2000) | ||
RULE_ID | NUMBER | Contract Expert Rule Id |
Cut, paste (and edit) the following text to query this object:
SELECT DOCUMENT_TYPE
, DOCUMENT_ID
, SEQUENCE_ID
, ERROR_RECORD_TYPE
, TITLE
, ARTICLE_ID
, DELIVERABLE_ID
, SECTION_NAME
, ERROR_SEVERITY
, QA_CODE
, MESSAGE_NAME
, PROBLEM_SHORT_DESC
, PROBLEM_DETAILS
, PROBLEM_DETAILS_SHORT
, SUGGESTION
, CREATION_DATE
, REFERENCE_COLUMN1
, REFERENCE_COLUMN2
, REFERENCE_COLUMN3
, REFERENCE_COLUMN4
, REFERENCE_COLUMN5
, ERROR_RECORD_TYPE_NAME
, ERROR_SEVERITY_NAME
, RULE_ID
FROM OKC.OKC_QA_ERRORS_T;
OKC.OKC_QA_ERRORS_T does not reference any database object
OKC.OKC_QA_ERRORS_T is referenced by following:
|
|
|