eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GMD.LM_SPRD_FLS

Object Details

Object Name:	LM_SPRD_FLS
Object Type:	TABLE
Owner:	GMD
FND Design Data:	GMD.LM_SPRD_FLS
Subobject Name:
Status:	VALID

This table records the files in which a user has saved Laboratory
Spreadsheets.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
LM_SPRD_FLS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SPRD_ID
LM_SPRD_FLS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SPRD_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
SPRD_ID	NUMBER	(10)	Yes	Surrogate key for the operator code/spreadsheet.
SPRD_NAME	VARCHAR2	(80)	Yes	Name which the spreadsheet was saved.
ACTIVE_IND	NUMBER	(5)	Yes	Not currently used.
FORMULA_ID	NUMBER	(10)		The foreign key to Lab form master
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
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
LAB_TYPE	VARCHAR2	(4)		The Lab Type from Lab type master
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
IN_USE	NUMBER	(5)		Not currently used
ORGN_CODE	VARCHAR2	(4)		Organization Code
BATCH_ID	NUMBER	(10)		The batch for which the spreadsheet is saved
MAINTAIN_TYPE	NUMBER	(5)		Maintain type is used in save simulator
MOVE_ORDER_HEADER_ID	NUMBER	(15)		This is the column to identify the batch move order header
LAB_ORGANIZATION_ID	NUMBER	(15)		This is the column to identify the lab organization

Query Text

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


SELECT SPRD_ID
,      SPRD_NAME
,      ACTIVE_IND
,      FORMULA_ID
,      DELETE_MARK
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAB_TYPE
,      TEXT_CODE
,      IN_USE
,      ORGN_CODE
,      BATCH_ID
,      MAINTAIN_TYPE
,      MOVE_ORDER_HEADER_ID
,      LAB_ORGANIZATION_ID
FROM GMD.LM_SPRD_FLS;

Dependencies

[top of page]

GMD.LM_SPRD_FLS does not reference any database object

GMD.LM_SPRD_FLS is referenced by following:

APPS: LM_SPRD_FLS