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_VALIDITY_RULES

Object Details

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

Stores quantity and effective dates for variou uses and/or organizations (formerly effectivities).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMD_RECIPE_VALIDITY_RULES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RECIPE_VALIDITY_RULE_ID
GMD_RECIPE_VALIDITY_RULES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECIPE_ID ORGN_CODE
GMD_RECIPE_VALIDITY_RULES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_ID RECIPE_USE
GMD_RECIPE_VALIDITY_RULES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VALIDITY_RULE_STATUS
GMD_RECIPE_VALIDITY_RULES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	START_DATE END_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
RECIPE_VALIDITY_RULE_ID	NUMBER	(15)	Yes	Validity Rule ID - Primary Key, Unique Identifier for a Recipe Validity Rule
RECIPE_ID	NUMBER	(15)	Yes	Recipe ID - Primary Key, Unique Identifier for a Recipe
ORGN_CODE	VARCHAR2	(4)		The OPM Organization this Validity Rule is specific to. This can be left blank, in which case a Global Validity Rule is defined.
ITEM_ID	NUMBER	(15)		The Item ID (Product) that this Validity Rule is for.
RECIPE_USE	VARCHAR2	(30)	Yes	What this Validity Rule is to be used for. Production, Costing, Planning, MSDS, Technical. Formerly known as Formula Use on the Effectivity.
PREFERENCE	NUMBER	(15)	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.
START_DATE	DATE		Yes	The start date of the Validity Rule (cannot be used before this date).
END_DATE	DATE			The end date of the Validity Rule (cannot be used after this date). This field can be updated even if the Validity Rule is Frozen in order to prevent it from being used anymore.
MIN_QTY	NUMBER		Yes	The minimum qty for which this Validity Rule can be used, expressed in the UOM entered in the item_um column (derived from the Formula Material line).
MAX_QTY	NUMBER		Yes	The maximum qty for which this Validity Rule can be used, expressed in the UOM entered in the item_um column (derived from the Formula Material line).
STD_QTY	NUMBER		Yes	The Standard Batch size for this Validity Rule.
ITEM_UM	VARCHAR2	(4)		Unit of Measure for the Min and Max Quantity (derived from the Formula).
INV_MIN_QTY	NUMBER		Yes	The minimum qty for which this Validity Rule can be used, expressed in the primary UOM of an item.
INV_MAX_QTY	NUMBER		Yes	The maximum qty for which this Validity Rule can be used, expressed in the primary UOM of an item.
TEXT_CODE	NUMBER	(10)		The link to the Text associated to the Validity Rule. Recipe Text is stored in FM_TEXT_TBL_TL.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE21	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE22	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE23	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE24	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE25	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE26	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE27	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE28	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE29	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE30	VARCHAR2	(240)		Descriptive Flexfield segment
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
VALIDITY_RULE_STATUS	VARCHAR2	(30)	Yes	The Status of the Recipe Validity Rule. The combination of the Recipe and Validity Rule status will be used to determine what a Recipe can be used for. See the GMD_STATUS table for a list of possible Status's.
LAB_TYPE	VARCHAR2	(4)		The Laboratory associated with this Validity Rule (optional).
PLANNED_PROCESS_LOSS	NUMBER			This is the process loss for the validity rule based on the standard quantity
ORGANIZATION_ID	NUMBER	(15)		This is the inv organization id
INVENTORY_ITEM_ID	NUMBER	(15)		This is the inv item id
REVISION	VARCHAR2	(3)		This is the inv item revision
DETAIL_UOM	VARCHAR2	(3)		This is the inv item uom in 3 characters
FIXED_PROCESS_LOSS	NUMBER			Fixed Process Loss: Quantity define in this will be distributed across all material lines
FIXED_PROCESS_LOSS_UOM	VARCHAR2	(3)		Fixed Process Loss: UOM

Query Text

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


SELECT RECIPE_VALIDITY_RULE_ID
,      RECIPE_ID
,      ORGN_CODE
,      ITEM_ID
,      RECIPE_USE
,      PREFERENCE
,      START_DATE
,      END_DATE
,      MIN_QTY
,      MAX_QTY
,      STD_QTY
,      ITEM_UM
,      INV_MIN_QTY
,      INV_MAX_QTY
,      TEXT_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      VALIDITY_RULE_STATUS
,      LAB_TYPE
,      PLANNED_PROCESS_LOSS
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      DETAIL_UOM
,      FIXED_PROCESS_LOSS
,      FIXED_PROCESS_LOSS_UOM
FROM GMD.GMD_RECIPE_VALIDITY_RULES;

Dependencies

[top of page]

GMD.GMD_RECIPE_VALIDITY_RULES does not reference any database object

GMD.GMD_RECIPE_VALIDITY_RULES is referenced by following:

APPS: GMDRVTRG_UPDATE_WF; GMD_RECIPE_VALIDITY_RULES; GMD_RECIPE_VALIDITY_RULES_TG