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]

VIEW: APPS.CSD_RECALL_HEADERS_VL

Object Details

Object Name:	CSD_RECALL_HEADERS_VL
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

Translatable view representing the recall.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROW ID
RECALL_ID	NUMBER		Yes	Recall Id
RECALL_NUMBER	VARCHAR2	(30)		Recall Number
REPORTED_DATE	DATE			Date reported
INIT_DATE	DATE			initiation date
COMP_DATE	DATE			Completion date
MANDAT_COMP_DATE	DATE			Mandated completion date
ACT_COMP_DATE	DATE			actual completion date
SERVICE_CODES	VARCHAR2	(30)		service codes
REG_AGENCY_ID	VARCHAR2	(30)		Regulatory agency
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)		DFF Segment
ATTRIBUTE14	VARCHAR2	(150)		DFF Segment
ATTRIBUTE15	VARCHAR2	(150)		DFF Segment
SEVERITY_ID	NUMBER			Recall severity
STATUS_ID	NUMBER			Recall flow state
RECALL_FLOW_STATUS_ID	NUMBER			Flow status id
WIP_ACCOUNTING_CLASS	VARCHAR2	(30)		wip accounting class
HOTLINE_NUMBER	VARCHAR2	(30)		Hotline number
RECALL_WEBSITE	VARCHAR2	(256)		Recall website
RECALL_REVISION	NUMBER			Recall revision
DISCOVERY_DATE	DATE			Discovery date
ESTIMATED_NO_OF_UNITS	NUMBER			Estimated number of units
CONSUMER_CONTACT	VARCHAR2	(80)		Consumer contact
DESCRIPTION	VARCHAR2	(4000)		Description
DISCOVERY_METHOD	VARCHAR2	(4000)		Discovery method
INCIDENTS_AND_ISSUES	VARCHAR2	(4000)		ANy reported issues
CONSEQUENCE	VARCHAR2	(2000)		Consequence of recall
STRATEGY_DESCR	VARCHAR2	(4000)		Recall strategy
REMEDY_ACTIONS	VARCHAR2	(4000)		remedy
REG_AGENCY_COMMENTS	VARCHAR2	(2000)		Comments by regulatory agency
LANGUAGE	VARCHAR2	(15)		Language
RECALL_NAME	VARCHAR2	(80)		Recall Name
SOURCE_LANG	VARCHAR2	(15)		Source lang
RECALL_REASON	VARCHAR2	(2000)		Recall reason
RECALL_RISK	VARCHAR2	(2000)		risk if recall is not done
CLASSIFICATION_CODE	VARCHAR2	(30)		Recall classification

Query Text

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


SELECT ROW_ID
,      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
,      DISCOVERY_DATE
,      ESTIMATED_NO_OF_UNITS
,      CONSUMER_CONTACT
,      DESCRIPTION
,      DISCOVERY_METHOD
,      INCIDENTS_AND_ISSUES
,      CONSEQUENCE
,      STRATEGY_DESCR
,      REMEDY_ACTIONS
,      REG_AGENCY_COMMENTS
,      LANGUAGE
,      RECALL_NAME
,      SOURCE_LANG
,      RECALL_REASON
,      RECALL_RISK
,      CLASSIFICATION_CODE
FROM APPS.CSD_RECALL_HEADERS_VL;

Dependencies

[top of page]

APPS.CSD_RECALL_HEADERS_VL references the following:

APPS: CSD_RECALL_HEADERS_B; CSD_RECALL_HEADERS_TL

APPS.CSD_RECALL_HEADERS_VL is not referenced by any database object