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

VIEW: APPS.GMD_ERES_MATERIALS_VW

Object Details
Object Name: GMD_ERES_MATERIALS_VW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMD.GMD_ERES_MATERIALS_VW
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.GMD_ERES_MATERIALS_VW references the following:

SchemaAPPS
SynonymFM_MATL_DTL
SynonymFM_ROUT_DTL
SynonymGMD_RECIPE_STEP_MATERIALS
ViewMTL_SYSTEM_ITEMS_VL

APPS.GMD_ERES_MATERIALS_VW is not referenced by any database object