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]

VIEW: APPS.GME_BATCH_STEP_ITEMS_V1

Object Details

Object Name:	GME_BATCH_STEP_ITEMS_V1
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GME.GME_BATCH_STEP_ITEMS_V1
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

View of Item / Step association with material definition

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BATCHSTEP_ID	NUMBER	(15)	Yes	Unique identifier for a batch step. FK to the GME_BATCH_STEPS table.
MATERIAL_DETAIL_ID	NUMBER	(10)	Yes	Unique identifier for a batch or FPO line.
BATCH_ID	NUMBER	(10)	Yes	Batch Identifier FK to the GME_BATCH_HEADER table.
FORMULALINE_ID	NUMBER	(10)		FK to the formula line on which the batch line was based, if any.
LINE_NO	NUMBER	(5)	Yes	Sequential line number for each line type in a batch or FPO.
ITEM_ID	NUMBER	(10)		FK to the item that is a product, ingredient, or byproduct.
LINE_TYPE	NUMBER	(5)	Yes	-1 = Ingredient 1 = Product; The product on Line 1 is the primary product. 2 = Byproduct
PLAN_QTY	NUMBER		Yes	The quantity that this line was planned to produce or consume, in the batch UOM (item_um column).
ITEM_UM	VARCHAR2	(4)		UOM in which planned and actual qty is entered on the batch.
ITEM_UM2	VARCHAR2	(4)		Secondary UOM of item.
ACTUAL_QTY	NUMBER		Yes	Sum (trans_qty) of completed transactions for line, in the batch UOM.
RELEASE_TYPE	NUMBER	(5)	Yes	Release (Consumption for ingredients and yield for product) type. Profile option determines the default value, the profile defaults to Automatic. 0 = Automatic release (completion aka certification) 1 = Manual release (completion aka certification) 2 = Incremental release 3 = Automatic by Step
SCRAP_FACTOR	NUMBER		Yes	Scrap factor decimal used to a trans_qty that allows for scrap.
SCALE_TYPE	NUMBER	(5)	Yes	0 = Non-scalable 1 = Scalable. 2 = Scale by increment
PHANTOM_TYPE	NUMBER	(5)	Yes	Phantom indicator. 0 = not a phantom, 1 = automatic phantom replacement, 2 = manual phantom.
COST_ALLOC	NUMBER			For products, fraction of cost allocated to this product.
ALLOC_IND	NUMBER	(5)		Allocation indicator. 0 = Not fully allocated, 1 = Fully allocated.
COST	NUMBER			Not currently used.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
PHANTOM_ID	NUMBER	(10)		For phantoms. FK of the phantom batch which produces the ingredient.
ROUNDING_DIRECTION	NUMBER	(5)		Whether to round up to round down to the nearest SCALE_MULTIPLE 0 = UP 1 = DOWN 2 = EITHER
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute category
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
SCALE_ROUNDING_VARIANCE	NUMBER			Percentage + / - of the variance of scaled quantity allowed when scaling; default is zero.
SCALE_MULTIPLE	NUMBER			The multiples of the batch uom ( scale_uom ) for scaling.
CONTRIBUTE_YIELD_IND	VARCHAR2	(1)		Indicator to specify if the item ( product or ingredient ) contributes to yield. If item is defined as a packaging item, then the item cannot contribute to yield, therefore, the value is N, for No. Y = The item contributes to yield, Default. N = No, the item does not contributes to yield.
CONTRIBUTE_STEP_QTY_IND	VARCHAR2	(1)		Indicator to specify if the item contributes to step quantity. If item is defined as a packaging item, then the item cannot contribute to the step quantity, therefore, the value is N, for No. Y = The item contributes to step quantity, Default value. N = No, the item does not contributes to step quantity.
WIP_PLAN_QTY	NUMBER			This quantity is used in place of PLAN_QTY, if the batch status is WIP or above.
ORIGINAL_QTY	NUMBER			The recipe quantity scaled for the batch. Planned quantity prior to any changes, value cannot be updated.

Query Text

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


SELECT BATCHSTEP_ID
,      MATERIAL_DETAIL_ID
,      BATCH_ID
,      FORMULALINE_ID
,      LINE_NO
,      ITEM_ID
,      LINE_TYPE
,      PLAN_QTY
,      ITEM_UM
,      ITEM_UM2
,      ACTUAL_QTY
,      RELEASE_TYPE
,      SCRAP_FACTOR
,      SCALE_TYPE
,      PHANTOM_TYPE
,      COST_ALLOC
,      ALLOC_IND
,      COST
,      TEXT_CODE
,      PHANTOM_ID
,      ROUNDING_DIRECTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      LAST_UPDATE_LOGIN
,      SCALE_ROUNDING_VARIANCE
,      SCALE_MULTIPLE
,      CONTRIBUTE_YIELD_IND
,      CONTRIBUTE_STEP_QTY_IND
,      WIP_PLAN_QTY
,      ORIGINAL_QTY
FROM APPS.GME_BATCH_STEP_ITEMS_V1;

Dependencies

[top of page]

APPS.GME_BATCH_STEP_ITEMS_V1 references the following:

APPS: GME_BATCH_STEP_ITEMS; GME_MATERIAL_DETAILS

APPS.GME_BATCH_STEP_ITEMS_V1 is not referenced by any database object