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

TABLE: GMD.LM_TECH_DTL

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


This table contains the valid values for technical parameters with a
data type of 2 (Validation List).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LAB_TYPE VARCHAR2 (4)
Laboratory type.
TECH_PARM_NAME VARCHAR2 (8) Yes Name of the technical parameter.
VALID_ANS VARCHAR2 (80) Yes Valid value for the technical parameter.
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
TRANS_CNT NUMBER (10)
Not currently used
ORGN_CODE VARCHAR2 (4)
Organization Code
TECH_PARM_ID NUMBER (15) Yes Foreign key from header
ORGANIZATION_ID NUMBER (15)
This is the Organization ID Column
Query Text

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


SELECT LAB_TYPE
,      TECH_PARM_NAME
,      VALID_ANS
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETE_MARK
,      TEXT_CODE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      ORGN_CODE
,      TECH_PARM_ID
,      ORGANIZATION_ID
FROM GMD.LM_TECH_DTL;

Dependencies

[top of page]

GMD.LM_TECH_DTL does not reference any database object

GMD.LM_TECH_DTL is referenced by following:

SchemaGMD
ViewLM_TECH_DTL#