[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PMIFV_BATCH_MATERIAL_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PMI.PMIFV_BATCH_MATERIAL_V
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Information on a batch and the ingredients, products, and byproducts of that batch.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_ID | NUMBER | (10) | Yes | Surrogate key to FPO or batch. |
| PLANT_CODE | VARCHAR2 | (4) | Production organization in which the batch or FPO is/was/will be run. | |
| BATCH_NUMBER | VARCHAR2 | (32) | Yes | Batch or FPO number. |
| BATCH_TYPE | NUMBER | (5) | Yes | Differentiates between Firm Planned Order(10) and batches (0). |
| PRODUCTION_ID | NUMBER | (10) | Reserved for future use. Used for tying multiple batches to a campaign/prod ord. When used, validate against PM_PROD_MST. | |
| PRODUCTION_SEQUENCE | NUMBER | (5) | Yes | Reserved for future use. Batch sequence in campaign/prod order. |
| FORMULA_ID | NUMBER | (10) | Surrogate key to formula on which batch or FPO is based. | |
| ROUTING_ID | NUMBER | (10) | Surrogate key to routing used. | |
| PLAN_START_DATE | DATE | Yes | Planned release date/time for batch. | |
| ACTUAL_START_DATE | DATE | Actual start date/time for batch. | ||
| DUE_DATE | DATE | Yes | Required batch completion date/time, notational. | |
| EXPECT_COMPLETION_DATE | DATE | Yes | Planned batch completion date/time. | |
| ACTUAL_COMPLETION_DATE | DATE | Actual completion date. | ||
| BATCH_STATUS | NUMBER | (5) | Yes | Batch or FPO status. -3=Converted FPO, -1=Cancelled,1=Pending; 2=WIP; 3=Certified; 4=Closed. |
| BATCH_STATUS_MEANING | VARCHAR2 | (80) | Batch or FPO status. -3=Converted FPO, -1=Cancelled,1=Pending; 2=WIP; 3=Certified; 4=Closed. | |
| PRIORITY_VALUE | NUMBER | Yes | Not currently used. | |
| PRIORITY_CODE | VARCHAR2 | (4) | Yes | Not currently used. |
| PRINT_COUNT | NUMBER | (5) | Yes | Number of times batch ticket was printed. |
| FORMULA_EFFECTIVITY_ID | NUMBER | (10) | Surrogate key to the formula effectivity the batch or FPO was based on. | |
| FMCONTROL_CLASS | VARCHAR2 | (8) | Not currently used. | |
| WIP_WAREHOUSEE_CODE | VARCHAR2 | (4) | Warehouse used to cost production activity. | |
| BATCH_CLOSE_DATE | DATE | Date/time the batch was closed. | ||
| PARENTLINE_ID | NUMBER | (10) | For phantom batches. Surrogate key to the batch ingredient line for which this phantom batch produces product. | |
| LINE_ID | NUMBER | (10) | Yes | Key that uniquely identifies a batch or FPO line. |
| FORMULALINE_ID | NUMBER | (10) | Surrogate key 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) | Surrogate key to the item that is a product, ingredient, or byproduct. | |
| LINE_TYPE | NUMBER | (5) | Yes | -1=Ingredient; 1=Product; 2=Byproduct. |
| LINE_TYPE_MEANING | VARCHAR2 | (80) | -1=Ingredient; 1=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). | |
| PLAN_QTY2 | VARCHAR2 | (0) | The quantity that this line was planned to produce or consume, in the secondary UOM of an item(for dual UOM items). | |
| ITEM_UOM | VARCHAR2 | (4) | UOM in which planned and actual qty is entered on the batch. | |
| ITEM_UOM2 | VARCHAR2 | (0) | Secondary UOM of item. | |
| ITEM_NUMBER | VARCHAR2 | (32) | Yes | Name of the item. |
| ITEM_DESCRIPTION | VARCHAR2 | (70) | Yes | Short description of the item that is displayed during the item look up. |
| ACTUAL_QTY | NUMBER | Yes | Sum (trans_qty) of completed transactions for line, in the batch UOM. | |
| ACTUAL_QTY2 | VARCHAR2 | (0) | Sum (trans_qty) of completed transactions for line, in the secondary UOM of an item(for dual UOM items). | |
| RELEASE_TYPE | NUMBER | (5) | Yes | Release (or certification) type. 0=Automatic release (certification), 1=Manual release (certification). |
| SCRAP_FACTOR | NUMBER | Yes | Scrap factor decimal used to a trans_qty that allows for scrap. | |
| SCALE_TYPE | NUMBER | (5) | Yes | 0=Fixed qty (non-scalable), 1=Linear scaling. |
| 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. | ||
| PHANTOM_ID | NUMBER | (10) | For phantoms. Surrogate key of the phantom batch which produces the ingredient. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, PLANT_CODE
, BATCH_NUMBER
, BATCH_TYPE
, PRODUCTION_ID
, PRODUCTION_SEQUENCE
, FORMULA_ID
, ROUTING_ID
, PLAN_START_DATE
, ACTUAL_START_DATE
, DUE_DATE
, EXPECT_COMPLETION_DATE
, ACTUAL_COMPLETION_DATE
, BATCH_STATUS
, BATCH_STATUS_MEANING
, PRIORITY_VALUE
, PRIORITY_CODE
, PRINT_COUNT
, FORMULA_EFFECTIVITY_ID
, FMCONTROL_CLASS
, WIP_WAREHOUSEE_CODE
, BATCH_CLOSE_DATE
, PARENTLINE_ID
, LINE_ID
, FORMULALINE_ID
, LINE_NO
, ITEM_ID
, LINE_TYPE
, LINE_TYPE_MEANING
, PLAN_QTY
, PLAN_QTY2
, ITEM_UOM
, ITEM_UOM2
, ITEM_NUMBER
, ITEM_DESCRIPTION
, ACTUAL_QTY
, ACTUAL_QTY2
, RELEASE_TYPE
, SCRAP_FACTOR
, SCALE_TYPE
, PHANTOM_TYPE
, COST_ALLOC
, ALLOC_IND
, COST
, PHANTOM_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPS.PMIFV_BATCH_MATERIAL_V;
APPS
FM_FORM_MST_B
GME_BATCH_HEADER
GME_MATERIAL_DETAILS
IC_ITEM_MST
PMI_COST_ANALZ_PACK
- show dependent code
PMI_SECURITY_PKG
- show dependent code
APPS.PMIFV_BATCH_MATERIAL_V is not referenced by any database object
|
|
|
|