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_GENERATION

Object Details

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

Recipe Generation for automatic creation

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Primary Key: GMD_RECIPE_GENERATION_PK

RECIPE_GENERATION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMD_RECIPE_GENERATION_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	RECIPE_GENERATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RECIPE_GENERATION_ID	NUMBER	(15)	Yes	Primary Key
RECIPE_USE_PROD	NUMBER	(5)	Yes	A Production validity rule will be created
RECIPE_USE_PLAN	NUMBER	(5)	Yes	A Planning validity rule will be created
RECIPE_USE_COST	NUMBER	(5)	Yes	A Costing validity rule will be created
RECIPE_USE_REG	NUMBER	(5)	Yes	A Regulatory validity rule will be created
RECIPE_USE_TECH	NUMBER	(5)	Yes	A Technical validity rule will be created
CREATION_TYPE	NUMBER	(5)		How it will be created
ORGN_CODE	VARCHAR2	(4)		Organization code
START_DATE	DATE			Start date of validity rule
START_DATE_TYPE	NUMBER	(5)	Yes	Indicator of the start date
END_DATE	DATE			End date of validity rule
END_DATE_TYPE	NUMBER	(5)	Yes	Indicator of the end date
NUM_OF_DAYS	NUMBER	(5)		Number of days
COST_CALENDAR	VARCHAR2	(4)		Used in cost validity rules
MANAGING_VALIDITY_RULES	NUMBER	(5)	Yes	Managing duplicates
RECIPE_NAMING_CONVENTION	NUMBER	(5)	Yes	Whether using product or formula name
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
ORGANIZATION_ID	NUMBER			Organization ID column is used to identify the organization

Query Text

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


SELECT RECIPE_GENERATION_ID
,      RECIPE_USE_PROD
,      RECIPE_USE_PLAN
,      RECIPE_USE_COST
,      RECIPE_USE_REG
,      RECIPE_USE_TECH
,      CREATION_TYPE
,      ORGN_CODE
,      START_DATE
,      START_DATE_TYPE
,      END_DATE
,      END_DATE_TYPE
,      NUM_OF_DAYS
,      COST_CALENDAR
,      MANAGING_VALIDITY_RULES
,      RECIPE_NAMING_CONVENTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
FROM GMD.GMD_RECIPE_GENERATION;

Dependencies

[top of page]

GMD.GMD_RECIPE_GENERATION does not reference any database object

GMD.GMD_RECIPE_GENERATION is referenced by following:

GMD: GMD_RECIPE_GENERATION#