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

TABLE: GMD.GMD_CHANGE_DISPOSITION

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


Change Disposition form history table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMD_CHANGE_DISPOSITION_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHANGE_DISP_ID
Columns
Name Datatype Length Mandatory Comments
CHANGE_DISP_ID NUMBER

Unique key
ORGANIZATION_ID NUMBER

Sample Organization
SAMPLE_ID NUMBER

Sample
SAMPLING_EVENT_ID NUMBER

Sampling Event
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
DISPOSITION_FROM VARCHAR2 (3)
Disposition before the change
DISPOSITION_TO VARCHAR2 (3)
Disposition after the change
PARENT_LOT_NUMBER VARCHAR2 (80)
Parent Lot
LOT_NUMBER VARCHAR2 (80)
Lot
LOT_STATUS_ID NUMBER

Lot status after the change
GRADE_CODE VARCHAR2 (150)
Grade after the change
REASON_ID NUMBER

Change reason
HOLD_DATE DATE

Hold Date
Query Text

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


SELECT CHANGE_DISP_ID
,      ORGANIZATION_ID
,      SAMPLE_ID
,      SAMPLING_EVENT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DISPOSITION_FROM
,      DISPOSITION_TO
,      PARENT_LOT_NUMBER
,      LOT_NUMBER
,      LOT_STATUS_ID
,      GRADE_CODE
,      REASON_ID
,      HOLD_DATE
FROM GMD.GMD_CHANGE_DISPOSITION;

Dependencies

[top of page]

GMD.GMD_CHANGE_DISPOSITION does not reference any database object

GMD.GMD_CHANGE_DISPOSITION is referenced by following:

SchemaGMD
ViewGMD_CHANGE_DISPOSITION#