[Home] [Help] [Dependency Information]
Object Name: | GMF_BATCH_REQUIREMENTS |
---|---|
Object Type: | TABLE |
Owner: | GMF |
FND Design Data: | GMF.GMF_BATCH_REQUIREMENTS |
Subobject Name: | |
Status: | VALID |
Batch requirement details
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMF_BATCH_REQUIREMENTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BATCH_ID
ING_MATERIAL_DETAIL_ID |
GMF_BATCH_REQUIREMENTS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BATCH_ID
PROD_MATERIAL_DETAIL_ID ING_MATERIAL_DETAIL_ID |
GMF_BATCH_REQUIREMENTS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
BATCH_ID
BATCHSTEP_RESOURCE_ID |
GMF_BATCH_REQUIREMENTS_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REQUIREMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VIB_ID | NUMBER | Obsolete. Replaced with Requirement_id. | ||
BATCH_ID | NUMBER | Yes | Batch id for which the requirement are created. | |
PRODUCT_ITEM_ID | NUMBER | Yes | Item_id of the product in the batch. | |
PROD_MATERIAL_DETAIL_ID | NUMBER | Yes | Line_id identifying the product line in the gme_material_details table. | |
BATCHSTEP_ID | NUMBER | Batchstep_id identifying the batch step. | ||
INGREDIENT_ITEM_ID | NUMBER | Item_id of the ingredient or by-product in the batch. | ||
ING_MATERIAL_DETAIL_ID | NUMBER | Line_id identifying the ingredient or by-product line in the gme_material_details table. | ||
RESOURCES | VARCHAR2 | (32) | Resource use in the batch. | |
BATCHSTEP_RESOURCE_ID | NUMBER | Id identifying the batch step resource. | ||
DERIVED_COST_ALLOC | NUMBER | Yes | Dervied Cost allocation indicated how much of the ingredient, by-product or resource should be allocated to the product for generating VIB details and hence the cost calculations. | |
REQUIRED_DOC_QTY | NUMBER | Yes | The quantity of the ingredient, by-product or resource needed to produce 1 unit of the product. All quantities involved in this calculations are in the document UOM | |
DELETE_MARK | NUMBER | (5) | Yes | Indicates if the requirement has been marked for deletion. |
CREATED_BY | NUMBER | Yes | Standard who column | |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
REQUIREMENT_ID | NUMBER | The surrogate uniquely identifying the requirement row. | ||
ORGANIZATION_ID | NUMBER | Organization (Plant/Lab) in which batch is created. | ||
VIB_PROFILE_VALUE | VARCHAR2 | (1) | Value of profile 'GMF: Batch Actual Cost Calculation Basis' at the time of batch release |
Cut, paste (and edit) the following text to query this object:
SELECT VIB_ID
, BATCH_ID
, PRODUCT_ITEM_ID
, PROD_MATERIAL_DETAIL_ID
, BATCHSTEP_ID
, INGREDIENT_ITEM_ID
, ING_MATERIAL_DETAIL_ID
, RESOURCES
, BATCHSTEP_RESOURCE_ID
, DERIVED_COST_ALLOC
, REQUIRED_DOC_QTY
, DELETE_MARK
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUIREMENT_ID
, ORGANIZATION_ID
, VIB_PROFILE_VALUE
FROM GMF.GMF_BATCH_REQUIREMENTS;
GMF.GMF_BATCH_REQUIREMENTS does not reference any database object
GMF.GMF_BATCH_REQUIREMENTS is referenced by following:
|
|
|