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.GR_INV_RECIPE_V1

Object Details

Object Name:	GR_INV_RECIPE_V1
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GR.GR_INV_RECIPE_V1
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

View for Getting a distinct Recipe No

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RECIPE_NO	VARCHAR2	(32)	Yes	Surrogate id uniquely identifying a Recipe Number.
FORMULA_NO	VARCHAR2	(32)	Yes	Formula Number
FORMULA_VERS	NUMBER		Yes	Formula Version

Query Text

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


SELECT RECIPE_NO
,      FORMULA_NO
,      FORMULA_VERS
FROM APPS.GR_INV_RECIPE_V1;

Dependencies

[top of page]

APPS.GR_INV_RECIPE_V1 references the following:

APPS: FM_FORM_MST; GMD_RECIPES; GMD_STATUS

APPS.GR_INV_RECIPE_V1 is not referenced by any database object