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

TABLE: GME.GME_SCALE_DETAIL

Object Details
Object Name: GME_SCALE_DETAIL
Object Type: TABLE
Owner: GME
FND Design Data: TableGME.GME_SCALE_DETAIL
Subobject Name:
Status: VALID


Table used by the Batch Yield Variance and Batch Usage and Substitution Variance reports to hold scaled batch data.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
FORMULALINE_ID NUMBER (10)
Surrogate key identifying a formula line.
LINE_TYPE NUMBER (5)
Line Type. -1 = Ingredient 1 = Product 2 = Byproduct.
ITEM_ID NUMBER (10)
Surrogate key identifying the item on the formula line.
QTY NUMBER

The formula quantity of the item.
ITEM_UM VARCHAR2 (4)
The unit of measure in which the quantity is expressed in the formula.
SCALE_TYPE NUMBER (5)
Scale type of the formula line. 0=Fixed (non-scaleable); 1=Linear scaling.
CONV_QTY NUMBER

The scaled quantity.
Query Text

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


SELECT FORMULALINE_ID
,      LINE_TYPE
,      ITEM_ID
,      QTY
,      ITEM_UM
,      SCALE_TYPE
,      CONV_QTY
FROM GME.GME_SCALE_DETAIL;

Dependencies

[top of page]

GME.GME_SCALE_DETAIL does not reference any database object

GME.GME_SCALE_DETAIL is referenced by following:

SchemaAPPS
SynonymGME_SCALE_DETAIL