[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GMD_MATERIAL_EFFECTIVITIES_VW |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  GMD.GMD_MATERIAL_EFFECTIVITIES_VW
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FORMULALINE_ID | NUMBER | (10) | Surrogate key for the formula line. | |
| FORMULA_ID | NUMBER | (10) | Surrogate key for the formula/version. | |
| LINE_TYPE | NUMBER | (5) | 1=product; -1=ingredient; 2=byprod. | |
| LINE_NO | NUMBER | (5) | List order on screen within a line_type. | |
| ITEM_ID | NUMBER | (15) | Inventory item id | |
| QTY | NUMBER | Item qty produced or consumed. | ||
| ITEM_UM | VARCHAR2 | (3) | Inventory item uom | |
| RELEASE_TYPE | NUMBER | (5) | 0=automatic release; 1=partial release | |
| SCRAP_FACTOR | NUMBER | Scrap factor decimal used to calculate required qty. | ||
| SCALE_TYPE | NUMBER | (5) | 0=fixed, no scaling; 1=proportional scaling. | |
| COST_ALLOC | NUMBER | If product, fractional cost absorption. | ||
| PHANTOM_TYPE | NUMBER | (5) | Phantom indicator. 0=not a phantom, 1=automatic phantom replacement, 2=manual phantom. | |
| REWORK_TYPE | NUMBER | (5) | Not currently used. | |
| TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
| 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.) | |
| 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.) | |
| SCALE_MULTIPLE | NUMBER | The multiples of the batch uom used for scaling in multiples. ( 0 = Scaling does not scale by multiples, > 0 = Scale by multiples, value must be a whole number, < 0 = Invalid value) | ||
| SCALE_ROUNDING_VARIANCE | NUMBER | Percentage + / - of the variance of scale multiple allowed when scaling; default is zero. | ||
| ROUNDING_DIRECTION | NUMBER | (5) | Applied to ingredients for either rounding up or down the scaled quantity value | |
| BY_PRODUCT_TYPE | VARCHAR2 | (1) | The type of byproduct being yielded | |
| BUFFER_IND | NUMBER | (5) | Buffer indicator | |
| START_DATE | DATE | Effective start date | ||
| END_DATE | DATE | Effective end date | ||
| ORIGINAL_ITEM_FLAG | NUMBER | Orginal item | ||
| PREFERENCE | NUMBER | Preference | ||
| SUB_ORIGINAL_QTY | NUMBER | Substitute original qty | ||
| SUB_REPLACE_QTY | NUMBER | Substitute replace qty | ||
| REPLACEMENT_UOM | VARCHAR2 | (3) | Replacement UOM | |
| LINE_ITEM_ID | NUMBER | Line Item ID | ||
| LINE_ITEM_UOM | VARCHAR2 | (3) | Line Item UOM | |
| LINE_ITEM_PRIMARY_UOM | VARCHAR2 | (3) | Line Primary UOM | |
| LINE_ITEM_QTY | NUMBER | Detail line item Qty | ||
| SUBSTITUTION_ITEM_UOM | VARCHAR2 | (3) | Substitute Item UOM | |
| ORGANIZATION_ID | NUMBER | (15) | Organization id |
Cut, paste (and edit) the following text to query this object:
SELECT FORMULALINE_ID
, FORMULA_ID
, LINE_TYPE
, LINE_NO
, ITEM_ID
, QTY
, ITEM_UM
, RELEASE_TYPE
, SCRAP_FACTOR
, SCALE_TYPE
, COST_ALLOC
, PHANTOM_TYPE
, REWORK_TYPE
, TEXT_CODE
, CONTRIBUTE_STEP_QTY_IND
, CONTRIBUTE_YIELD_IND
, SCALE_MULTIPLE
, SCALE_ROUNDING_VARIANCE
, ROUNDING_DIRECTION
, BY_PRODUCT_TYPE
, BUFFER_IND
, START_DATE
, END_DATE
, ORIGINAL_ITEM_FLAG
, PREFERENCE
, SUB_ORIGINAL_QTY
, SUB_REPLACE_QTY
, REPLACEMENT_UOM
, LINE_ITEM_ID
, LINE_ITEM_UOM
, LINE_ITEM_PRIMARY_UOM
, LINE_ITEM_QTY
, SUBSTITUTION_ITEM_UOM
, ORGANIZATION_ID
FROM APPS.GMD_MATERIAL_EFFECTIVITIES_VW;
APPS
FM_MATL_DTL
GMD_FORMULA_SUBSTITUTION
GMD_ITEM_SUBSTITUTION_DTL
GMD_ITEM_SUBSTITUTION_HDR_B
APPS
GMDFMVAL_PUB
- show dependent code
GMD_MBR_MATERIAL_V1
GMD_MBR_STEP_MATERIAL_V1
GMF_MATERIAL_EFFECTIVITIES_VW1
|
|
|
|