[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OPI_DBI_OPM_SCALED_MTL |
|---|---|
| Object Type: | TABLE |
| Owner: | OPI |
| Subobject Name: | |
| Status: | VALID |
OPI Table used to hold scaled batches during DBI Jobs Master load request.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | Organization ID | ||
| JOB_TYPE | NUMBER | Job Type. 4 = OPM Job (Batch), which is all that applies for this table | ||
| BATCH_ID | NUMBER | Batch Identifier FK to the GME_BATCH_HEADER table | ||
| COPRODUCT_ID | NUMBER | FK to the item that is a product or coproduct. | ||
| MATERIAL_DETAIL_ID | NUMBER | Unique identifier for a batch or FPO line. | ||
| COPRODUCT_PLAN_QTY | NUMBER | The quantity of coproduct that this line was planned to produce. | ||
| COPRODUCT_ACTUAL_QTY | NUMBER | The quantity of coproduct that this line actually produced. | ||
| SCALED_PLAN_QTY | NUMBER | The quantity that this line was planned to consume, in the batch UOM (item_um column), scaled up to the amount needed to produce the actual product qty. | ||
| ACTUAL_QTY | NUMBER | Sum (trans_qty) of completed transactions for line, in the batch UOM. | ||
| ITEM_UM | VARCHAR2 | (25) | UOM in which planned and actual qty is entered on the batch. | |
| SCALE_TYPE | NUMBER | 0 = Non-scalable 1 = Scalable.2 = Scale by increment | ||
| CONTRIBUTE_YIELD_IND | VARCHAR2 | (1) | Indicator to specify if the item ( product or ingredient ) contributes to yield. | |
| SCALE_MULTIPLE | NUMBER | The multiples of the batch uom ( scale_uom ) for scaling. | ||
| SCALE_ROUNDING_VARIANCE | NUMBER | Percentage + / - of the variance of scaled quantity allowed when scaling; default is zero. | ||
| ROUNDING_DIRECTION | NUMBER | Whether to round up to round down to the nearest SCALE_MULTIPLE0 = UP 1 = DOWN 3 = EITHER | ||
| LINE_NO | NUMBER | Sequential line number for each line type in a batch or FPO | ||
| LINE_TYPE | NUMBER | -1 = Ingredient1 = Product; The product on Line 1 is the primary product.2 = Byproduct | ||
| ITEM_ID | NUMBER | FK to the item that is a ingredient or byproduct. | ||
| PLAN_QTY | NUMBER | The quantity that this line was planned to produce or consume, in the batch UOM (item_um column). | ||
| COMPLETION_DATE | DATE | Completion Date |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, JOB_TYPE
, BATCH_ID
, COPRODUCT_ID
, MATERIAL_DETAIL_ID
, COPRODUCT_PLAN_QTY
, COPRODUCT_ACTUAL_QTY
, SCALED_PLAN_QTY
, ACTUAL_QTY
, ITEM_UM
, SCALE_TYPE
, CONTRIBUTE_YIELD_IND
, SCALE_MULTIPLE
, SCALE_ROUNDING_VARIANCE
, ROUNDING_DIRECTION
, LINE_NO
, LINE_TYPE
, ITEM_ID
, PLAN_QTY
, COMPLETION_DATE
FROM OPI.OPI_DBI_OPM_SCALED_MTL;
OPI.OPI_DBI_OPM_SCALED_MTL does not reference any database object
OPI.OPI_DBI_OPM_SCALED_MTL is referenced by following:
APPS
OPI_DBI_OPM_SCALED_MTL
|
|
|
|