[Home] [Help] [Dependency Information]
Object Name: | PMIBV_PRODUCTFORMULA_INV_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMIBV_PRODUCTFORMULA_INV_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Formula Detail with Onhand Quantity of the Ingredients
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). |
SCALE_TYPE | NUMBER | (5) | Yes | Controls scaling behavior of formula. 0=Formula cannot be scaled, 1=Formula can be scaled. |
FORMULA_DESC1 | VARCHAR2 | (70) | Yes | Formula description. |
FORMULA_DESC2 | VARCHAR2 | (70) | 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 | Yes | Item qty produced or consumed. | |
PRODUCT_UOM | VARCHAR2 | (4) | Uom of qty. | |
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
, 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
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPS.PMIBV_PRODUCTFORMULA_INV_V;
APPS.PMIBV_PRODUCTFORMULA_INV_V is not referenced by any database object
|
|
|