[Home] [Help] [Dependency Information]
Object Name: | CSD_RECALL_HEADERS_TL |
---|---|
Object Type: | TABLE |
Owner: | CSD |
FND Design Data: | CSD.CSD_RECALL_HEADERS_TL |
Subobject Name: | |
Status: | VALID |
Translatable table for the recall entity.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSD_RECALL_HEADERS_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RECALL_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECALL_ID | NUMBER | Yes | Recall Id | |
DESCRIPTION | VARCHAR2 | (4000) | Recall Description | |
DISCOVERY_METHOD | VARCHAR2 | (4000) | Discovery method | |
INCIDENTS_AND_ISSUES | VARCHAR2 | (4000) | Incidents and issues reported so far. | |
CONSEQUENCE | VARCHAR2 | (2000) | Consequence if not recalled | |
STRATEGY_DESCR | VARCHAR2 | (4000) | Recall Strategy | |
REMEDY_ACTIONS | VARCHAR2 | (4000) | Remedial actions | |
REG_AGENCY_COMMENTS | VARCHAR2 | (2000) | Comments for reg agency | |
RECALL_NAME | VARCHAR2 | (80) | Recall name | |
RECALL_REASON | VARCHAR2 | (2000) | Reason for the recall | |
RECALL_RISK | VARCHAR2 | (2000) | Risk if recall is not done | |
OBJECT_VERSION_NUMBER | NUMBER | Object version number | ||
CREATED_BY | NUMBER | WHO Column | ||
CREATION_DATE | DATE | WHO Column | ||
LAST_UPDATED_BY | NUMBER | WHO Column | ||
LAST_UPDATE_DATE | DATE | WHO Column | ||
LAST_UPDATE_LOGIN | NUMBER | WHO Column | ||
LANGUAGE | VARCHAR2 | (15) | Language | |
SOURCE_LANG | VARCHAR2 | (15) | Source language |
Cut, paste (and edit) the following text to query this object:
SELECT RECALL_ID
, DESCRIPTION
, DISCOVERY_METHOD
, INCIDENTS_AND_ISSUES
, CONSEQUENCE
, STRATEGY_DESCR
, REMEDY_ACTIONS
, REG_AGENCY_COMMENTS
, RECALL_NAME
, RECALL_REASON
, RECALL_RISK
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LANGUAGE
, SOURCE_LANG
FROM CSD.CSD_RECALL_HEADERS_TL;
CSD.CSD_RECALL_HEADERS_TL does not reference any database object
CSD.CSD_RECALL_HEADERS_TL is referenced by following:
|
|
|