[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GME_MATERIAL_DETAILS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  GME.GME_MATERIAL_DETAILS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
A supplementary view based on table gme_material_details.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | To identify the organization (Plant or Lab) | ||
| 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. | |
| INVENTORY_ITEM_ID | NUMBER | Identified to Item | ||
| LINE_NO | NUMBER | (5) | Yes | Sequential line number for each line type in a batch or FPO |
| LINE_TYPE | NUMBER | (5) | Yes | -1 = Ingredient1 = Product; The product on Line 1 is the primary product.2 = Byproduct |
| LINE_TYPE_MEANING | VARCHAR2 | (80) | Yes | meaning resolved using lookup table for line_type |
| PLAN_QTY | NUMBER | Yes | The quantity that this line was planned to produce or consume, in the batch UOM (item_um column). | |
| WIP_PLAN_QTY | NUMBER | This quantity is used in place of PLAN_QTY, if the batch status is WIP or above. | ||
| ACTUAL_QTY | NUMBER | Yes | Sum (trans_qty) of completed transactions for line, in the batch UOM. | |
| SUBINVENTORY | VARCHAR2 | (10) | Yield/Supply Subinventory | |
| LOCATOR_ID | NUMBER | Identifier to Yield,/Supply locator | ||
| REVISION | VARCHAR2 | (3) | Item Revision | |
| BACKORDERED_QTY | NUMBER | Qty used by view/api for cross docking | ||
| MATERIAL_REQUIREMENT_DATE | DATE | Requirement/Yield Date of the material | ||
| MATERIAL_REQUIREMENT_DATE_DT | VARCHAR2 | (4000) | Requirement/Yield Date of the material in user display format | |
| DTL_UM | VARCHAR2 | (3) | Detail UOM for the quantities | |
| ITEM_NO | VARCHAR2 | (40) | Item Number | |
| ITEM_DESC | VARCHAR2 | (240) | Item Description | |
| PHANTOM_ID | NUMBER | (10) | For phantoms. FK of the phantom batch which produces the ingredient | |
| 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 |
| ROUNDING_DIRECTION | NUMBER | (5) | Whether to round up to round down to the nearest SCALE_MULTIPLE0 = UP 1 = DOWN 3 = EITHER | |
| 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. | ||
| PHANTOM_LINE_ID | NUMBER | Identifier to the Phantom Ingredient Line/Phantom Product Line | ||
| LOCATOR | CHAR | (1) | Locator resolved using Locator ID | |
| PHANTOM_BATCH_NO | VARCHAR2 | (32) | Phantom Batch Number | |
| TEXT_CODE | NUMBER | (10) | Text Code | |
| RELEASE_TYPE | NUMBER | (5) | Yes | Consumption (or yeild) type. Profile option determines the default value, the profile defaults to Automatic.0 = Automatic (completion)1 = Manual (completion)2 = Incremental 3 = Automatic by Step |
| RELEASE_TYPE_MEANING | VARCHAR2 | (80) | Yes | Release Type resolved using lookup type |
| 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. | ||
| 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_YIELD_IND_MEANING | VARCHAR2 | (80) | resolved to its meanin using lookup | |
| CONTRIBUTE_STEP_QTY_MEANING | VARCHAR2 | (80) | resolved to its meanin using lookup | |
| 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 | |
| ORIGINAL_QTY | NUMBER | The recipe quantity scaled for the batch. Planned quantity prior to any changes, value cannot be updated | ||
| BY_PRODUCT_TYPE | VARCHAR2 | (1) | This column is used to show whether the by-product is a sample type or other types | |
| BY_PRODUCT_TYPE_MEANING | VARCHAR2 | (80) | resolved to its meanin using lookup | |
| DISPENSE_IND_MEANING | VARCHAR2 | (80) | resolved to its meanin using lookup | |
| DISPENSE_IND | VARCHAR2 | (1) | If material has to be dispensed |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, MATERIAL_DETAIL_ID
, BATCH_ID
, FORMULALINE_ID
, INVENTORY_ITEM_ID
, LINE_NO
, LINE_TYPE
, LINE_TYPE_MEANING
, PLAN_QTY
, WIP_PLAN_QTY
, ACTUAL_QTY
, SUBINVENTORY
, LOCATOR_ID
, REVISION
, BACKORDERED_QTY
, MATERIAL_REQUIREMENT_DATE
, MATERIAL_REQUIREMENT_DATE_DT
, DTL_UM
, ITEM_NO
, ITEM_DESC
, PHANTOM_ID
, SCRAP_FACTOR
, SCALE_TYPE
, ROUNDING_DIRECTION
, SCALE_ROUNDING_VARIANCE
, SCALE_MULTIPLE
, PHANTOM_LINE_ID
, LOCATOR
, PHANTOM_BATCH_NO
, TEXT_CODE
, RELEASE_TYPE
, RELEASE_TYPE_MEANING
, PHANTOM_TYPE
, COST_ALLOC
, CONTRIBUTE_YIELD_IND
, CONTRIBUTE_YIELD_IND_MEANING
, CONTRIBUTE_STEP_QTY_MEANING
, CONTRIBUTE_STEP_QTY_IND
, ORIGINAL_QTY
, BY_PRODUCT_TYPE
, BY_PRODUCT_TYPE_MEANING
, DISPENSE_IND_MEANING
, DISPENSE_IND
FROM APPS.GME_MATERIAL_DETAILS_V;
APPS
FND_DATE
- show dependent code
FND_TIMEZONES
- show dependent code
GEM_LOOKUPS
GME_BATCH_HEADER
GME_MATERIAL_DETAILS
MTL_ITEM_LOCATIONS_KFV
MTL_SYSTEM_ITEMS_VL
APPS.GME_MATERIAL_DETAILS_V is not referenced by any database object
|
|
|
|