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

VIEW: GMD.GMD_RECIPE_EFF_ASSOC#

Object Details
Object Name: GMD_RECIPE_EFF_ASSOC#
Object Type: VIEW
Owner: GMD
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FMEFF_ID NUMBER (10) Yes
RECIPE_ID NUMBER (15)
ORGN_CODE VARCHAR2 (4)
ITEM_ID NUMBER (10) Yes
FORMULA_USE NUMBER (5) Yes
END_DATE DATE
Yes
START_DATE DATE
Yes
INV_MIN_QTY NUMBER
Yes
INV_MAX_QTY NUMBER
Yes
MIN_QTY NUMBER
Yes
MAX_QTY NUMBER
Yes
STD_QTY NUMBER
Yes
ITEM_UM VARCHAR2 (4) Yes
PREFERENCE NUMBER (5) Yes
ROUTING_ID NUMBER (10)
FORMULA_ID NUMBER (10) Yes
CUST_ID NUMBER (15)
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
DELETE_MARK NUMBER (5) Yes
TEXT_CODE NUMBER (10)
TRANS_CNT NUMBER (10)
LAST_UPDATE_LOGIN NUMBER (15)
RECIPE_VALIDITY_RULE_ID NUMBER (15)
OPM_CUST_ID NUMBER (10)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FMEFF_ID
,      RECIPE_ID
,      ORGN_CODE
,      ITEM_ID
,      FORMULA_USE
,      END_DATE
,      START_DATE
,      INV_MIN_QTY
,      INV_MAX_QTY
,      MIN_QTY
,      MAX_QTY
,      STD_QTY
,      ITEM_UM
,      PREFERENCE
,      ROUTING_ID
,      FORMULA_ID
,      CUST_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      DELETE_MARK
,      TEXT_CODE
,      TRANS_CNT
,      LAST_UPDATE_LOGIN
,      RECIPE_VALIDITY_RULE_ID
,      OPM_CUST_ID
FROM GMD.GMD_RECIPE_EFF_ASSOC#;

Dependencies

[top of page]

GMD.GMD_RECIPE_EFF_ASSOC# references the following:

SchemaGMD
TableGMD_RECIPE_EFF_ASSOC
GMD.GMD_RECIPE_EFF_ASSOC# is referenced by following:

SchemaAPPS
SynonymGMD_RECIPE_EFF_ASSOC