[Home] [Help] [Dependency Information]
Object Name: | PMITS_RECIPE_VALIDITY_RULE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMITS_RECIPE_VALIDITY_RULE_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECIPE_VALIDITY_RULE_ID | NUMBER | (15) | Yes | Recipe Validity Rule ID |
RECIPE_ID | NUMBER | (15) | Yes | Recipe ID |
ORGN_CODE | VARCHAR2 | (4) | Organization Code | |
ITEM_ID | NUMBER | (15) | Item ID | |
RECIPE_USE | VARCHAR2 | (80) | Yes | Recipe Use |
PREFERENCE | NUMBER | (15) | Yes | Preference |
START_DATE | DATE | Yes | Start Date | |
END_DATE | DATE | End Date | ||
MIN_QTY | NUMBER | Yes | Min Qty | |
MAX_QTY | NUMBER | Yes | Max Qty | |
STD_QTY | NUMBER | Yes | Standard Qty | |
ITEM_UM | VARCHAR2 | (4) | Item UOM | |
INV_MIN_QTY | NUMBER | Yes | The minimum qty for which this Validity Rule can be used, expressed in the primary UOM of an item. | |
INV_MAX_QTY | NUMBER | Yes | The maximum qty for which this Validity Rule can be used, expressed in the primary UOM of an item | |
TEXT_CODE | NUMBER | (10) | Text Code | |
DELETE_MARK | NUMBER | (5) | Yes | Delete Mark |
VALIDITY_RULE_STATUS | VARCHAR2 | (30) | Yes | Validity Rule Status |
LAB_TYPE | VARCHAR2 | (4) | Lab Type | |
RECIPE_NO | VARCHAR2 | (32) | Yes | Recipe Number |
RECIPE_VERSION | NUMBER | (5) | Yes | Recipe Version |
ITEM_NO | VARCHAR2 | (32) | Yes | Item Number |
ITEM_DESC1 | VARCHAR2 | (70) | Yes | Item Description |
FORMULA_NO | VARCHAR2 | (32) | Yes | Formula Number |
FORMULA_VERS | NUMBER | Yes | Formula Version | |
ROUTING_NO | VARCHAR2 | (32) | Routing Number | |
ROUTING_VERS | NUMBER | (5) | Routing Version | |
STATUS | VARCHAR2 | (80) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT RECIPE_VALIDITY_RULE_ID
, RECIPE_ID
, ORGN_CODE
, ITEM_ID
, RECIPE_USE
, PREFERENCE
, START_DATE
, END_DATE
, MIN_QTY
, MAX_QTY
, STD_QTY
, ITEM_UM
, INV_MIN_QTY
, INV_MAX_QTY
, TEXT_CODE
, DELETE_MARK
, VALIDITY_RULE_STATUS
, LAB_TYPE
, RECIPE_NO
, RECIPE_VERSION
, ITEM_NO
, ITEM_DESC1
, FORMULA_NO
, FORMULA_VERS
, ROUTING_NO
, ROUTING_VERS
, STATUS
FROM APPS.PMITS_RECIPE_VALIDITY_RULE_V;
APPS.PMITS_RECIPE_VALIDITY_RULE_V is not referenced by any database object
|
|
|