[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PMIFV_PRODUCTFORMULA_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PMI.PMIFV_PRODUCTFORMULA_V
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
The product and ingredient info for a formula. This does not contain info on effectivity,routing or coproducts.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FORMULA_NO | VARCHAR2 | (32) | Yes | Alphanumeric formula name or number. |
| FORMULA_VERSION | NUMBER | Yes | Formula version. | |
| FORMULA_TYPE | NUMBER | (5) | Yes | 0=std formula; 1=packaged item formula (these are not currently used). |
| FORMULA_TYPE_MEANING | VARCHAR2 | (80) | 0=std formula; 1=packaged item formula (these are not currently used). | |
| SCALE_TYPE | NUMBER | (5) | Yes | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. |
| FORMULA_DESC1 | VARCHAR2 | (240) | Yes | Formula description. |
| FORMULA_DESC2 | VARCHAR2 | (240) | Formula comment. | |
| FORMULA_CLASS | VARCHAR2 | (8) | Formula class. No programatic support (fm_form_cls). | |
| FORMULA_CONTROL_CLASS | VARCHAR2 | (8) | Not currently used. (fn_fmct_cls). | |
| FORMULA_ID | NUMBER | (10) | Yes | Surrogate for formula_no + formula_vers. |
| PRODUCT_ITEM_ID | NUMBER | (10) | Surrogate key for the item on the formula line. | |
| INGREDIENT_ITEM_ID | NUMBER | (10) | Surrogate key for the item on the formula line. | |
| INGREDIENT_FORMULALINE_ID | NUMBER | (10) | Yes | Surrogate key for the formula line. |
| INGREDIENT_LINE_NO | NUMBER | (5) | Yes | List order on screen within a line_type. |
| INGREDIENT_QTY | NUMBER | Yes | Item qty produced or consumed. | |
| INGREDIENT_ITEM_UOM | VARCHAR2 | (4) | Uom of qty. | |
| INGREDIENT_RELEASE_TYPE | NUMBER | (5) | Yes | 0=automatic release; 1=partial release. |
| INGREDIENT_SCRAP_FACTOR | NUMBER | Yes | Scrap factor decimal used to calculate required qty. | |
| INGREDIENT_SCALE_TYPE | NUMBER | (5) | Yes | 0=fixed, no scaling; 1=proportional scaling. |
| COST_ALLOCATION | NUMBER | If product, fractional cost absorption. | ||
| PHANTOM_TYPE | NUMBER | (5) | Yes | Phantom indicator. 0=not a phantom, 1=automatic phantom replacement, 2=manual phantom. |
| REWORK_TYPE | NUMBER | (5) | Yes | Not currently used. |
| PRODUCT_QTY | NUMBER | Item qty produced or consumed. | ||
| PRODUCT_UOM | VARCHAR2 | (4) | Uom of qty. | |
| INGREDIENT_ITEM_NO | VARCHAR2 | (32) | Yes | Name of the item. |
| INGREDIENT_DESC1 | VARCHAR2 | (70) | Yes | Short description of the item that is displayed during the item look up. |
| INGREDIENT_DESC2 | VARCHAR2 | (70) | Short description of the item that is not displayed during the item look up. | |
| PRODUCT_ITEM_NO | VARCHAR2 | (32) | Yes | Name of the item. |
| PRODUCT_DESC1 | VARCHAR2 | (70) | Yes | Short description of the item that is displayed during the item look up. |
| PRODUCT_DESC2 | VARCHAR2 | (70) | Short description of the item that is not displayed during the item look up. | |
| 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 | (15) | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT FORMULA_NO
, FORMULA_VERSION
, FORMULA_TYPE
, FORMULA_TYPE_MEANING
, SCALE_TYPE
, FORMULA_DESC1
, FORMULA_DESC2
, FORMULA_CLASS
, FORMULA_CONTROL_CLASS
, FORMULA_ID
, PRODUCT_ITEM_ID
, INGREDIENT_ITEM_ID
, INGREDIENT_FORMULALINE_ID
, INGREDIENT_LINE_NO
, INGREDIENT_QTY
, INGREDIENT_ITEM_UOM
, INGREDIENT_RELEASE_TYPE
, INGREDIENT_SCRAP_FACTOR
, INGREDIENT_SCALE_TYPE
, COST_ALLOCATION
, PHANTOM_TYPE
, REWORK_TYPE
, PRODUCT_QTY
, PRODUCT_UOM
, INGREDIENT_ITEM_NO
, INGREDIENT_DESC1
, INGREDIENT_DESC2
, PRODUCT_ITEM_NO
, PRODUCT_DESC1
, PRODUCT_DESC2
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPS.PMIFV_PRODUCTFORMULA_V;
APPS
FM_FORM_EFF
FM_FORM_MST
FM_MATL_DTL
IC_ITEM_MST
PMI_COST_ANALZ_PACK
- show dependent code
PMI_SECURITY_PKG
- show dependent code
APPS.PMIFV_PRODUCTFORMULA_V is not referenced by any database object
|
|
|
|