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: GMD.GMD_SS_VARIANTS

Object Details

Object Name:	GMD_SS_VARIANTS
Object Type:	TABLE
Owner:	GMD
FND Design Data:	GMD.GMD_SS_VARIANTS
Subobject Name:
Status:	VALID

Stability Study Variants

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMD_SS_VARIANTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	VARIANT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
VARIANT_ID	NUMBER		Yes	Primary key generated from sequence
VARIANT_NO	NUMBER		Yes	Variant name
SS_ID	NUMBER		Yes	Stability study for variant
MATERIAL_SOURCE_ID	NUMBER		Yes	Source of material for variant
STORAGE_PLAN_DETAIL_ID	NUMBER		Yes	Storage plan for variant
DEFAULT_SPEC_ID	NUMBER		Yes	Default spec for variant
SCHEDULED_START_DATE	DATE			Scheduled start date
SAMPLES_PER_TIME_POINT	NUMBER	(5)		Samples per time points
RETAINED_SAMPLES	NUMBER	(5)		Retained samples
STORAGE_SPEC_ID	NUMBER		Yes	Specification of storage in which sample will be kept
RESOURCES	VARCHAR2	(30)		Resources
RESOURCE_INSTANCE_ID	NUMBER			Resource instance
STORAGE_WHSE_CODE	VARCHAR2	(4)		Storage warehouse code
STORAGE_LOCATION	VARCHAR2	(16)		Storage location
PACKAGE_ID	NUMBER			Package ID
TEXT_CODE	NUMBER	(10)		Text code
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield category
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield segment
DELETE_MARK	NUMBER	(5)	Yes	Logical delete mark
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard who column
SAMPLE_QTY	NUMBER			Sample Quantity for variant
SAMPLE_QTY_UOM	VARCHAR2	(4)		Sample Quantity UOM for variant
ACTUAL_END_DATE	DATE			End date of the variant
SAMPLING_EVENT_ID	NUMBER			Sampling event id for the variant
STORAGE_DATE	DATE			Storage date of time point samples
SAMPLE_QUANTITY_UOM	VARCHAR2	(3)		Sample Quantity UOM
STORAGE_LOCATOR_ID	NUMBER			Surrogate for Storage locator
STORAGE_ORGANIZATION_ID	NUMBER			Surrogate for Storage organization
STORAGE_SUBINVENTORY	VARCHAR2	(10)		Storage Subinventory
MIGRATED_IND	NUMBER	(1)		Indicates Status of the Migration of this table

Query Text

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


SELECT VARIANT_ID
,      VARIANT_NO
,      SS_ID
,      MATERIAL_SOURCE_ID
,      STORAGE_PLAN_DETAIL_ID
,      DEFAULT_SPEC_ID
,      SCHEDULED_START_DATE
,      SAMPLES_PER_TIME_POINT
,      RETAINED_SAMPLES
,      STORAGE_SPEC_ID
,      RESOURCES
,      RESOURCE_INSTANCE_ID
,      STORAGE_WHSE_CODE
,      STORAGE_LOCATION
,      PACKAGE_ID
,      TEXT_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      DELETE_MARK
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SAMPLE_QTY
,      SAMPLE_QTY_UOM
,      ACTUAL_END_DATE
,      SAMPLING_EVENT_ID
,      STORAGE_DATE
,      SAMPLE_QUANTITY_UOM
,      STORAGE_LOCATOR_ID
,      STORAGE_ORGANIZATION_ID
,      STORAGE_SUBINVENTORY
,      MIGRATED_IND
FROM GMD.GMD_SS_VARIANTS;

Dependencies

[top of page]

GMD.GMD_SS_VARIANTS does not reference any database object

GMD.GMD_SS_VARIANTS is referenced by following:

GMD: GMD_SS_VARIANTS#