[Home] [Help] [Dependency Information]
Object Name: | GMD_TECHNICAL_DATA_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMD.GMD_TECHNICAL_DATA_VL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LM_ITEM_DAT_ID | NUMBER | (15) | Yes | Surrogate Key |
LAB_TYPE | VARCHAR2 | (4) | Organization for which the data is being defined | |
ITEM_ID | NUMBER | (10) | Item for which the data is defined | |
LOT_ID | NUMBER | (10) | Lot ID | |
FORMULA_ID | NUMBER | (10) | Formula for which the data is defined | |
BATCH_ID | NUMBER | (10) | Batch for which the data is defined | |
TECH_PARM_ID | NUMBER | (15) | Yes | Surrogate key |
TECH_PARM_NAME | VARCHAR2 | (8) | Yes | Name of the technical parameter. |
SORT_SEQ | NUMBER | (5) | Yes | sort sequence |
TEXT_DATA | VARCHAR2 | (80) | Text data for the parameter | |
NUM_DATA | NUMBER | Numeric data for the parameter | ||
BOOLEAN_DATA | NUMBER | (5) | Boolean data value for the parameter | |
TEXT_CODE | NUMBER | (10) | Edit Text code | |
LOT_NUMBER | VARCHAR2 | (80) | This is Lot NumberColumn. | |
INVENTORY_ITEM_ID | NUMBER | This is Inventory Item ID Column. | ||
ORGANIZATION_ID | NUMBER | This is Organization IDColumn. | ||
LOT_ORGANIZATION_ID | NUMBER | This is Lot Organization IDColumn. | ||
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ORGN_CODE | VARCHAR2 | (4) | Organization for which the data is being defined | |
DELETE_MARK | NUMBER | (10) | Yes | Indicator for marked for purge record |
TRANS_CNT | VARCHAR2 | (0) |
Cut, paste (and edit) the following text to query this object:
SELECT LM_ITEM_DAT_ID
, LAB_TYPE
, ITEM_ID
, LOT_ID
, FORMULA_ID
, BATCH_ID
, TECH_PARM_ID
, TECH_PARM_NAME
, SORT_SEQ
, TEXT_DATA
, NUM_DATA
, BOOLEAN_DATA
, TEXT_CODE
, LOT_NUMBER
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, LOT_ORGANIZATION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORGN_CODE
, DELETE_MARK
, TRANS_CNT
FROM APPS.GMD_TECHNICAL_DATA_VL;
|
|
|