[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:
|
|
|