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

TABLE: CSD.CSD_RECALL_METRICS

Object Details
Object Name: CSD_RECALL_METRICS
Object Type: TABLE
Owner: CSD
FND Design Data: TableCSD.CSD_RECALL_METRICS
Subobject Name:
Status: VALID


Holds the rolled up metrics for a particular recall.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
METRIC_ID NUMBER
Yes Internal PK Column
RECALL_NUMBER VARCHAR2 (30) Yes Identifies the recall for which the metrics are calculated
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
RECALLED_UNITS NUMBER

Number of recalled instances.
REMEDIATED_UNITS NUMBER

Number of recall units remediated (associated SR is closed).
UN_REMEDIATED_UNITS NUMBER

Recall instances awaiting action.
ACCUMULATED_COSTS NUMBER

Cost accumulated till now (WIP costs only).
REMAINING_COST NUMBER

Estimated remaining cost
CUSTOMERS_IMPACTED NUMBER

Number of customers impacted by this recall
CUSTOMERS_REMEDIATED NUMBER

Number of customers for whom the recall activity is completed.
CUSTOMERS_UN_REMEDIATED NUMBER

Number of customers whose recall items needs to be worked upon.
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
Query Text

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


SELECT METRIC_ID
,      RECALL_NUMBER
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RECALLED_UNITS
,      REMEDIATED_UNITS
,      UN_REMEDIATED_UNITS
,      ACCUMULATED_COSTS
,      REMAINING_COST
,      CUSTOMERS_IMPACTED
,      CUSTOMERS_REMEDIATED
,      CUSTOMERS_UN_REMEDIATED
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM CSD.CSD_RECALL_METRICS;

Dependencies

[top of page]

CSD.CSD_RECALL_METRICS does not reference any database object

CSD.CSD_RECALL_METRICS is referenced by following:

SchemaCSD
ViewCSD_RECALL_METRICS#