[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
LM_SPRD_DTL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | LINE_ID |
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 |
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;
GMD.LM_SPRD_DTL does not reference any database object
GMD.LM_SPRD_DTL is referenced by following:
|
|
|