[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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. |
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;
GMD.GMD_FORMULATION_SPECS does not reference any database object
GMD.GMD_FORMULATION_SPECS is referenced by following:
|
|
|