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

TABLE: GMD.LM_FORM_DAT

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


Lab formula item tech data. Formula-specific item technical parameter
data.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LAB_TYPE VARCHAR2 (4)
Laboratory type.
FORMULALINE_ID NUMBER (10) Yes Surrogate to lab formula detail line.
TECH_PARM_NAME VARCHAR2 (8) Yes Technical parameter name.
SORT_SEQ NUMBER (5) Yes Sorting sequence.
TEXT_DATA VARCHAR2 (80)
Technical data for character technical parameters.
NUM_DATA NUMBER

Technical data for numeric technical parameters.
BOOLEAN_DATA NUMBER (5)
Technical data for boolean technical parameters.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
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 Standard: 0=Active record (default); 1=Marked for (logical) deletion.
IN_USE NUMBER (10)
Not currently used
ORGN_CODE VARCHAR2 (4) Yes Organization Code
Query Text

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


SELECT LAB_TYPE
,      FORMULALINE_ID
,      TECH_PARM_NAME
,      SORT_SEQ
,      TEXT_DATA
,      NUM_DATA
,      BOOLEAN_DATA
,      TEXT_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      IN_USE
,      ORGN_CODE
FROM GMD.LM_FORM_DAT;

Dependencies

[top of page]

GMD.LM_FORM_DAT does not reference any database object

GMD.LM_FORM_DAT is referenced by following:

SchemaGMD
ViewLM_FORM_DAT#