eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GMD.GMD_RECIPE_EFF_ASSOC

Object Details

Object Name:	GMD_RECIPE_EFF_ASSOC
Object Type:	TABLE
Owner:	GMD
FND Design Data:	GMD.GMD_RECIPE_EFF_ASSOC
Subobject Name:
Status:	VALID

Recipe-Effectivity Association Table

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMD_RECIPE_EFF_ASSOC_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	FMEFF_ID
GMD_RECIPE_EFF_ASSOC_I1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	FORMULA_ID ORGN_CODE FORMULA_USE END_DATE DELETE_MARK
GMD_RECIPE_EFF_ASSOC_I2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ORGN_CODE ITEM_ID FORMULA_USE END_DATE FMEFF_ID
GMD_RECIPE_EFF_ASSOC_I4	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	ROUTING_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FMEFF_ID	NUMBER	(10)	Yes	Surrogate key for this effectivity row.
RECIPE_ID	NUMBER	(15)		Recipe ID
ORGN_CODE	VARCHAR2	(4)		The organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.
ITEM_ID	NUMBER	(10)	Yes	Surrogate key for the item which is produced by the formula.
FORMULA_USE	NUMBER	(5)	Yes	The purpose for which the formula/routing can be used. 0=Prod, 1=MRP, 2=Costing, 3=MSDS.
END_DATE	DATE		Yes	The end date of the effectivity.
START_DATE	DATE		Yes	The start date of the effectivity.
INV_MIN_QTY	NUMBER		Yes	The minimum qty for which this effectivity can be used, expressed in the primary UOM of an item.
INV_MAX_QTY	NUMBER		Yes	The maximum qty for which this effectivity can be used, expressed in the primary UOM of an item.
MIN_QTY	NUMBER		Yes	The minimum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column.
MAX_QTY	NUMBER		Yes	The maximum qty for which this effectivity can be used, expressed in the UOM entered in the item_um column.
STD_QTY	NUMBER		Yes	Standard batch size for this rec.
ITEM_UM	VARCHAR2	(4)	Yes	UOM for min_qty and max_qty.
PREFERENCE	NUMBER	(5)	Yes	Preference indicator used by MRP to select which effectiviity to use if more than one meets the requirements. MRP will select the effectivity with the lowest number in this column.
ROUTING_ID	NUMBER	(10)		Surrogate key for the routing/routing version to be used, if any.
FORMULA_ID	NUMBER	(10)	Yes	Surrogate key for the formula /formula version to be used.
CUST_ID	NUMBER	(15)		Surrogate key for the customer for which this effectivity is used, if any.
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
TRANS_CNT	NUMBER	(10)		Not currently used
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
RECIPE_VALIDITY_RULE_ID	NUMBER	(15)		Recipe Validity rule ID
OPM_CUST_ID	NUMBER	(10)		Used by OM users only. Stores customer id to op_cust_mst (OPM customer table) for historical purposes.

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 does not reference any database object

GMD.GMD_RECIPE_EFF_ASSOC is referenced by following:

GMD: GMD_RECIPE_EFF_ASSOC#