[Home] [Help] [Dependency Information]
Object Name: | GMD_FORMULA_ANALYSIS_DTL# |
---|---|
Object Type: | VIEW |
Owner: | GMD |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORMULA_ID | NUMBER | Yes | ||
ORGN_CODE | VARCHAR2 | (4) | ||
ITEM_ID | NUMBER | |||
TECHNICAL_CLASS | VARCHAR2 | (240) | Yes | |
TECHNICAL_SUB_CLASS | VARCHAR2 | (240) | Yes | |
DIRECT_WEIGHT | NUMBER | Yes | ||
DIRECT_WEIGHT_PERCENT | NUMBER | Yes | ||
INDIRECT_WEIGHT | NUMBER | Yes | ||
INDIRECT_WEIGHT_PERCENT | NUMBER | Yes | ||
DIRECT_VOLUME | NUMBER | Yes | ||
DIRECT_VOLUME_PERCENT | NUMBER | Yes | ||
INDIRECT_VOLUME | NUMBER | Yes | ||
INDIRECT_VOLUME_PERCENT | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | (15) | Yes | |
LABORATORY_ID | NUMBER | (15) | ||
INVENTORY_ITEM_ID | NUMBER | (15) | Yes | |
LINE_NO | NUMBER | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT FORMULA_ID
, ORGN_CODE
, ITEM_ID
, TECHNICAL_CLASS
, TECHNICAL_SUB_CLASS
, DIRECT_WEIGHT
, DIRECT_WEIGHT_PERCENT
, INDIRECT_WEIGHT
, INDIRECT_WEIGHT_PERCENT
, DIRECT_VOLUME
, DIRECT_VOLUME_PERCENT
, INDIRECT_VOLUME
, INDIRECT_VOLUME_PERCENT
, ORGANIZATION_ID
, LABORATORY_ID
, INVENTORY_ITEM_ID
, LINE_NO
FROM GMD.GMD_FORMULA_ANALYSIS_DTL#;
|
|
|