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_DTL

Object Details

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

Table to store Lab Spreadsheet detail information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
LM_SPRD_DTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_ID	NUMBER	(10)	Yes	Surrogate id used to access line items on the spreadsheet
LAB_TYPE	VARCHAR2	(4)		Lab Type for which this spreadsheet was created
SPRD_ID	NUMBER	(10)	Yes	Surrogate id for the spreadsheet
LINE_TYPE	NUMBER	(5)	Yes	1=product; -1=ingredient; 2=byprod.
LINE_NO	NUMBER	(5)	Yes	List order on screen within a line_type.
ITEM_ID	NUMBER	(10)		Surrogate key used to reference ic_item_mst for item in the Bill of Materials
QTY	NUMBER		Yes	Line quantity on spreadsheet
ITEM_UM	VARCHAR2	(4)		Unit of measure in which the quantity was expressed
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
TPFORMULA_ID	NUMBER	(10)		Surrogate id to access lm_form_mst for the formula used for the tech parameter values
FORMULALINE_ID	NUMBER	(10)		Surrogate id used to access lm_form_dtl for the formulaline used for the tech parameters
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
ORGN_CODE	VARCHAR2	(4)		Organization Code
ROLLUP_IND	NUMBER	(5)		The rollup indicator for using the technical values
MATERIAL_DETAIL_ID	NUMBER	(10)		The batch line id for the saved line
LOT_ID	NUMBER	(10)		The lot surrogate, if the saved line is a lot record
QC_GRADE	VARCHAR2	(4)		The quality grade of the lot
TRANS_ID	NUMBER	(10)		The transaction id for allocations saved from batch
SECONDARY_QTY	NUMBER			The secondary qty for the line
SECONDARY_UM	VARCHAR2	(4)		The secondary um for the line
WHSE_CODE	VARCHAR2	(4)		The warehouse for the line allocation
LOCATION	VARCHAR2	(2000)		The location for the line allocation
BUFFER_IND	NUMBER	(5)		Buffer Indicator is used in save simulator
PLANT_CODE	VARCHAR2	(4)		Plant code field
ORGANIZATION_ID	NUMBER			This is the column to identify the lab organization
INVENTORY_ITEM_ID	NUMBER	(15)		This is the column to identify the item number
REVISION	VARCHAR2	(3)		This is the column to identify the item revision
SECONDARY_UOM	VARCHAR2	(3)		This is the column to identify the item secondary uom
DETAIL_UOM	VARCHAR2	(3)		This is the column to identify the material detail uom
GRADE_CODE	VARCHAR2	(150)		This is the column to identify the grade of the material
SUBINVENTORY_CODE	VARCHAR2	(10)		This is the column to identify the subinventory where the material
LOT_NUMBER	VARCHAR2	(80)		This is the column to identify the LOT where materil is taken
EXPIRATION_DATE	DATE			This is the column to identify the lost expiration date
MOVE_ORDER_LINE_ID	NUMBER	(15)		This is the column to identify the move order
PLANT_ORGANIZATION_ID	NUMBER	(15)		This is the column to identify if the item is revision controlled
REVISION_QTY_CONTROL_CODE	NUMBER	(15)		This is the column to identify if the item is revision controlled.
RESERVATION_ID	NUMBER	(15)		This is the column to identify if the material is reserved.
TRANSACTION_ID	NUMBER	(15)		This is the column to identify if the material is transacted
LOCATOR_ID	NUMBER	(15)		This is the column to identify if the material's location

Query Text

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


SELECT LINE_ID
,      LAB_TYPE
,      SPRD_ID
,      LINE_TYPE
,      LINE_NO
,      ITEM_ID
,      QTY
,      ITEM_UM
,      TEXT_CODE
,      TPFORMULA_ID
,      FORMULALINE_ID
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      ORGN_CODE
,      ROLLUP_IND
,      MATERIAL_DETAIL_ID
,      LOT_ID
,      QC_GRADE
,      TRANS_ID
,      SECONDARY_QTY
,      SECONDARY_UM
,      WHSE_CODE
,      LOCATION
,      BUFFER_IND
,      PLANT_CODE
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      SECONDARY_UOM
,      DETAIL_UOM
,      GRADE_CODE
,      SUBINVENTORY_CODE
,      LOT_NUMBER
,      EXPIRATION_DATE
,      MOVE_ORDER_LINE_ID
,      PLANT_ORGANIZATION_ID
,      REVISION_QTY_CONTROL_CODE
,      RESERVATION_ID
,      TRANSACTION_ID
,      LOCATOR_ID
FROM GMD.LM_SPRD_DTL;

Dependencies

[top of page]

GMD.LM_SPRD_DTL does not reference any database object

GMD.LM_SPRD_DTL is referenced by following:

APPS: LM_SPRD_DTL