eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CSD.CSD_RECALL_HEADERS_B

Object Details

Object Name:	CSD_RECALL_HEADERS_B
Object Type:	TABLE
Owner:	CSD
FND Design Data:	CSD.CSD_RECALL_HEADERS_B
Subobject Name:
Status:	VALID

The table stores all the recall header records

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSD_RECALL_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RECALL_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
RECALL_ID	NUMBER		Yes	Internal primary key column
RECALL_NUMBER	VARCHAR2	(30)		User displayable number
REPORTED_DATE	DATE			Date when recall is reported
INIT_DATE	DATE			Recall initiation date
COMP_DATE	DATE			estimated completion date
MANDAT_COMP_DATE	DATE			Mandated completion date
ACT_COMP_DATE	DATE			Actual completion date of the recall.
SERVICE_CODES	VARCHAR2	(30)		Service Code -- Currently not used
REG_AGENCY_ID	VARCHAR2	(30)		Regulatory agency identifier
REG_AGENCY_REF_NO	VARCHAR2	(30)		Regulatory agency reference
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
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		DFF Context
ATTRIBUTE1	VARCHAR2	(150)		DFF Segment
ATTRIBUTE2	VARCHAR2	(150)		DFF Segment
ATTRIBUTE3	VARCHAR2	(150)		DFF Segment
ATTRIBUTE4	VARCHAR2	(150)		DFF Segment
ATTRIBUTE5	VARCHAR2	(150)		DFF Segment
ATTRIBUTE6	VARCHAR2	(150)		DFF Segment
ATTRIBUTE7	VARCHAR2	(150)		DFF Segment
ATTRIBUTE8	VARCHAR2	(150)		DFF Segment
ATTRIBUTE9	VARCHAR2	(150)		DFF Segment
ATTRIBUTE10	VARCHAR2	(150)		DFF Segment
ATTRIBUTE11	VARCHAR2	(150)		DFF Segment
ATTRIBUTE12	VARCHAR2	(150)		DFF Segment
ATTRIBUTE13	VARCHAR2	(150)		DF Segment
ATTRIBUTE14	VARCHAR2	(150)		DFF Segment
ATTRIBUTE15	VARCHAR2	(150)		DFF Segment
SEVERITY_ID	NUMBER			Recall Severity
STATUS_ID	NUMBER			Recall status.
RECALL_FLOW_STATUS_ID	NUMBER			Flow status
WIP_ACCOUNTING_CLASS	VARCHAR2	(30)		WIP Accounting class for the jobs created for recall - Not used currently
HOTLINE_NUMBER	VARCHAR2	(30)		Recall hotline number
RECALL_WEBSITE	VARCHAR2	(256)		Recall Website
RECALL_REVISION	NUMBER			Recall Revision
ESTIMATED_NO_OF_UNITS	NUMBER			Estimated no of units
CONSUMER_CONTACT	VARCHAR2	(80)		Consumer Contact
DISCOVERY_DATE	DATE			Date when problem was discovered
CLASSIFICATION_CODE	VARCHAR2	(30)		Recall Classification code.

Query Text

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


SELECT RECALL_ID
,      RECALL_NUMBER
,      REPORTED_DATE
,      INIT_DATE
,      COMP_DATE
,      MANDAT_COMP_DATE
,      ACT_COMP_DATE
,      SERVICE_CODES
,      REG_AGENCY_ID
,      REG_AGENCY_REF_NO
,      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
,      SEVERITY_ID
,      STATUS_ID
,      RECALL_FLOW_STATUS_ID
,      WIP_ACCOUNTING_CLASS
,      HOTLINE_NUMBER
,      RECALL_WEBSITE
,      RECALL_REVISION
,      ESTIMATED_NO_OF_UNITS
,      CONSUMER_CONTACT
,      DISCOVERY_DATE
,      CLASSIFICATION_CODE
FROM CSD.CSD_RECALL_HEADERS_B;

Dependencies

[top of page]

CSD.CSD_RECALL_HEADERS_B does not reference any database object

CSD.CSD_RECALL_HEADERS_B is referenced by following:

CSD: CSD_RECALL_HEADERS_B#