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: GMF.GMF_BATCH_REQUIREMENTS

Object Details

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

Batch requirement details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

Name	Datatype	Length	Mandatory	Comments
VIB_ID	NUMBER			Obsolete. Replaced with Requirement_id. deprecated
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:

GMF: GMF_BATCH_REQUIREMENTS#