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]

VIEW: APPS.PMITS_RECIPE_VALIDITY_RULE_V

Object Details

Object Name:	PMITS_RECIPE_VALIDITY_RULE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMITS_RECIPE_VALIDITY_RULE_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RECIPE_VALIDITY_RULE_ID	NUMBER	(15)	Yes	Recipe Validity Rule ID
RECIPE_ID	NUMBER	(15)	Yes	Recipe ID
ORGN_CODE	VARCHAR2	(4)		Organization Code
ITEM_ID	NUMBER	(15)		Item ID
RECIPE_USE	VARCHAR2	(80)	Yes	Recipe Use
PREFERENCE	NUMBER	(15)	Yes	Preference
START_DATE	DATE		Yes	Start Date
END_DATE	DATE			End Date
MIN_QTY	NUMBER		Yes	Min Qty
MAX_QTY	NUMBER		Yes	Max Qty
STD_QTY	NUMBER		Yes	Standard Qty
ITEM_UM	VARCHAR2	(4)		Item UOM
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)		Text Code
DELETE_MARK	NUMBER	(5)	Yes	Delete Mark
VALIDITY_RULE_STATUS	VARCHAR2	(30)	Yes	Validity Rule Status
LAB_TYPE	VARCHAR2	(4)		Lab Type
RECIPE_NO	VARCHAR2	(32)	Yes	Recipe Number
RECIPE_VERSION	NUMBER	(5)	Yes	Recipe Version
ITEM_NO	VARCHAR2	(32)	Yes	Item Number
ITEM_DESC1	VARCHAR2	(70)	Yes	Item Description
FORMULA_NO	VARCHAR2	(32)	Yes	Formula Number
FORMULA_VERS	NUMBER		Yes	Formula Version
ROUTING_NO	VARCHAR2	(32)		Routing Number
ROUTING_VERS	NUMBER	(5)		Routing Version
STATUS	VARCHAR2	(80)	Yes

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
,      DELETE_MARK
,      VALIDITY_RULE_STATUS
,      LAB_TYPE
,      RECIPE_NO
,      RECIPE_VERSION
,      ITEM_NO
,      ITEM_DESC1
,      FORMULA_NO
,      FORMULA_VERS
,      ROUTING_NO
,      ROUTING_VERS
,      STATUS
FROM APPS.PMITS_RECIPE_VALIDITY_RULE_V;

Dependencies

[top of page]

APPS.PMITS_RECIPE_VALIDITY_RULE_V references the following:

APPS: FM_FORM_MST; FM_ROUT_HDR; GEM_LOOKUPS; GMD_RECIPES_VL; GMD_RECIPE_VALIDITY_RULES; GMD_STATUS; IC_ITEM_MST; PMI_SECURITY_PKG - show dependent code

APPS.PMITS_RECIPE_VALIDITY_RULE_V is not referenced by any database object