[Home] [Help] [Dependency Information]
Object Name: | QA_SKIPLOT_ASSOCIATION |
---|---|
Object Type: | TABLE |
Owner: | QA |
FND Design Data: | QA.QA_SKIPLOT_ASSOCIATION |
Subobject Name: | |
Status: | VALID |
Skip Lot Criteria-Process Association
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QA_SKIPLOT_ASSOCIATION_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CRITERIA_ID |
QA_SKIPLOT_ASSOCIATION_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PROCESS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CRITERIA_ID | NUMBER | Yes | Criteria ID | |
PROCESS_ID | NUMBER | Yes | Process ID | |
EFFECTIVE_FROM | DATE | Effective From Date | ||
EFFECTIVE_TO | DATE | Effective To Date | ||
LOTSIZE_FROM | NUMBER | Lot Size Range | ||
LOTSIZE_TO | NUMBER | Lot Size Range | ||
WF_ROLE_NAME | VARCHAR2 | (100) | Workflow Notification Role Name | |
INSP_STAGE | VARCHAR2 | (30) | Yes | Current Inspection Stage |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT CRITERIA_ID
, PROCESS_ID
, EFFECTIVE_FROM
, EFFECTIVE_TO
, LOTSIZE_FROM
, LOTSIZE_TO
, WF_ROLE_NAME
, INSP_STAGE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM QA.QA_SKIPLOT_ASSOCIATION;
QA.QA_SKIPLOT_ASSOCIATION does not reference any database object
QA.QA_SKIPLOT_ASSOCIATION is referenced by following:
|
|
|