[Home] [Help] [Dependency Information]
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 |
A public view which may be useful for custom reporting or other data
requirements.
View of Item / Step association with material definition
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. |
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;
APPS.GME_BATCH_STEP_ITEMS_V1 is not referenced by any database object
|
|
|