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

TABLE: GMD.GMD_COMPOSITE_SPEC_DISP

Object Details
Object Name: GMD_COMPOSITE_SPEC_DISP
Object Type: TABLE
Owner: GMD
FND Design Data: TableGMD.GMD_COMPOSITE_SPEC_DISP
Subobject Name:
Status: VALID


OPM Quality Composite Specification Display


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMD_COMPOSITE_SPEC_DISP_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_SPEC_DISP_ID
ColumnCOMPOSITE_SPEC_DISP_ID
Columns
Name Datatype Length Mandatory Comments
EVENT_SPEC_DISP_ID NUMBER
Yes Event specification disposition ID
COMPOSITE_SPEC_DISP_ID NUMBER
Yes Composite Specification Display Identifier
DISPOSITION VARCHAR2 (3) Yes Disposition
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
DELETE_MARK NUMBER (5) Yes Delete Mark
LATEST_IND VARCHAR2 (1)
Composite specification Identification
LOT_STATUS VARCHAR2 (240)
Current lot_status at time of sample disposition
UPDATE_ALL_LOCATIONS_IND VARCHAR2 (240)
Update lot_status of all locations matching lot_status of location specified in sample
Query Text

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


SELECT EVENT_SPEC_DISP_ID
,      COMPOSITE_SPEC_DISP_ID
,      DISPOSITION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      LATEST_IND
,      LOT_STATUS
,      UPDATE_ALL_LOCATIONS_IND
FROM GMD.GMD_COMPOSITE_SPEC_DISP;

Dependencies

[top of page]

GMD.GMD_COMPOSITE_SPEC_DISP does not reference any database object

GMD.GMD_COMPOSITE_SPEC_DISP is referenced by following:

SchemaGMD
ViewGMD_COMPOSITE_SPEC_DISP#