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

VIEW: APPS.GMD_QM_E_TIMEPOINTS_V

Object Details
Object Name: GMD_QM_E_TIMEPOINTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMD.GMD_QM_E_TIMEPOINTS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


OPM Quality Timepoint ERES View


[View Source]

Columns
Name Datatype Length Mandatory Comments
VARIANT_ID NUMBER
Yes variant id
TIME_POINT_ID NUMBER
Yes time point id
SPEC_NAME VARCHAR2 (80) Yes spec name
SPEC_VERS NUMBER (10) Yes spec version
PERIOD_ID NUMBER

period
NAME VARCHAR2 (80) Yes Time point Name
WF_SENT VARCHAR2 (2)
Workflow Sent
SAMPLES_PER_TIME_POINT NUMBER

samples per timepoint
SCHEDULED_DATE DATE

scheduled Date
ACTUAL_DATE DATE

actual date
SAMPLING_EVENT_ID NUMBER

sampling event id
TIMEPOINT_DISPOSITION NUMBER (5) Yes Timepoint Disposition
Query Text

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


SELECT VARIANT_ID
,      TIME_POINT_ID
,      SPEC_NAME
,      SPEC_VERS
,      PERIOD_ID
,      NAME
,      WF_SENT
,      SAMPLES_PER_TIME_POINT
,      SCHEDULED_DATE
,      ACTUAL_DATE
,      SAMPLING_EVENT_ID
,      TIMEPOINT_DISPOSITION
FROM APPS.GMD_QM_E_TIMEPOINTS_V;

Dependencies

[top of page]

APPS.GMD_QM_E_TIMEPOINTS_V references the following:

SchemaAPPS
SynonymGMD_SPECIFICATIONS
SynonymGMD_SS_TIME_POINTS

APPS.GMD_QM_E_TIMEPOINTS_V is not referenced by any database object