[Home] [Help] [Dependency Information]
Object Name: | GMD_ERES_MATERIALS_VW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMD.GMD_ERES_MATERIALS_VW |
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 |
---|---|---|---|---|
RECIPE_ID | NUMBER | (15) | Yes | Recipe surrogate key. |
ROUTINGSTEP_ID | NUMBER | (10) | Yes | Routing step surrogate key. |
FORMULALINE_ID | NUMBER | (10) | Yes | Formula Line surrogate key. |
ROUTINGSTEP_NO | NUMBER | (5) | Yes | Step to which the material is associated. |
ITEM_NO | VARCHAR2 | (40) | Item associated with the step. | |
DESCRIPTION | VARCHAR2 | (240) | Item Description. | |
QTY | NUMBER | Yes | Quantity of the material associated with the step. | |
DETAIL_UOM | VARCHAR2 | (3) | Yes | UOM of the line associated with the step. |
LINE_TYPE | NUMBER | (5) | Yes | Line type -1 Ingredient, 1 Product, 2 Byproduct. |
LINE_NO | NUMBER | (5) | Yes | Line number for the line associated with the step. |
Cut, paste (and edit) the following text to query this object:
SELECT RECIPE_ID
, ROUTINGSTEP_ID
, FORMULALINE_ID
, ROUTINGSTEP_NO
, ITEM_NO
, DESCRIPTION
, QTY
, DETAIL_UOM
, LINE_TYPE
, LINE_NO
FROM APPS.GMD_ERES_MATERIALS_VW;
APPS.GMD_ERES_MATERIALS_VW is not referenced by any database object
|
|
|