DBA Data[Home] [Help] [Dependency Information]


TABLE: GMF.GMF_BATCH_REQUIREMENTS

Object Details
Object Name: GMF_BATCH_REQUIREMENTS
Object Type: TABLE
Owner: GMF
FND Design Data: TableGMF.GMF_BATCH_REQUIREMENTS
Subobject Name:
Status: VALID


Batch requirement details


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMF_BATCH_REQUIREMENTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
ColumnING_MATERIAL_DETAIL_ID
GMF_BATCH_REQUIREMENTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
ColumnPROD_MATERIAL_DETAIL_ID
ColumnING_MATERIAL_DETAIL_ID
GMF_BATCH_REQUIREMENTS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
ColumnBATCHSTEP_RESOURCE_ID
GMF_BATCH_REQUIREMENTS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUIREMENT_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

GMF.GMF_BATCH_REQUIREMENTS does not reference any database object

GMF.GMF_BATCH_REQUIREMENTS is referenced by following:

SchemaGMF
ViewGMF_BATCH_REQUIREMENTS#