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_FORMULATION_SPECS

Object Details

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

LCF - Formulation Specification table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
FORMULATION_SPEC_ID	NUMBER	(15)	Yes	Primary Key, Unique Identifier for a Formulation Specification
SPEC_NAME	VARCHAR2	(80)	Yes	Formulation Specification Name
SPEC_VERS	NUMBER	(5)	Yes	Formulation Specification Version
PRODUCT_ID	NUMBER	(15)	Yes	Inventory Item ID of the product
OWNER_ORGANIZATION_ID	NUMBER	(15)	Yes	Owner Organization id of the Formulation Specification
SPEC_STATUS	VARCHAR2	(30)	Yes	The Status of the Formulation Specification. See the GMD_STATUS table for a list of possible Status
STD_QTY	NUMBER		Yes	Standard Qty column
STD_UOM	VARCHAR2	(3)	Yes	Standard UOM column
PROCESS_LOSS	NUMBER			Process Loss column
START_DATE	DATE		Yes	Active Start date for the Formulation Specification
END_DATE	DATE			Active End date for the Formulation Specification
MIN_INGREDS	NUMBER	(5)		Minimum no. of Ingredients column
MAX_INGREDS	NUMBER	(5)		Maximum no. of Ingredients column
INGRED_PICK_BASE_IND	VARCHAR2	(4)	Yes	Ingredient Pick Base indicator. MAT - Material requirement, CMP - Compositional requirement
PICK_LOT_STRATEGY	VARCHAR2	(80)		Pick Lot Startegy Column
TECH_PARM_ID	NUMBER	(15)	Yes	Technical Parameter ID Column
OBJECTIVE_IND	NUMBER	(5)	Yes	Objective Indicator. 0 - Minimize, 1 - Maximize
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	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
TEXT_CODE	NUMBER	(15)		The link to the Text associated to the Formulation Specification
ROUTING_ID	NUMBER	(15)		The Routing ID associated with this specification. It is optional to associate a Routing with a Formulation Specification.
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0 = Active record (default); 1 = Marked for (logical) deletion.

Query Text

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


SELECT FORMULATION_SPEC_ID
,      SPEC_NAME
,      SPEC_VERS
,      PRODUCT_ID
,      OWNER_ORGANIZATION_ID
,      SPEC_STATUS
,      STD_QTY
,      STD_UOM
,      PROCESS_LOSS
,      START_DATE
,      END_DATE
,      MIN_INGREDS
,      MAX_INGREDS
,      INGRED_PICK_BASE_IND
,      PICK_LOT_STRATEGY
,      TECH_PARM_ID
,      OBJECTIVE_IND
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TEXT_CODE
,      ROUTING_ID
,      DELETE_MARK
FROM GMD.GMD_FORMULATION_SPECS;

Dependencies

[top of page]

GMD.GMD_FORMULATION_SPECS does not reference any database object

GMD.GMD_FORMULATION_SPECS is referenced by following:

APPS: GMD_FORMULATION_SPECS