DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.GMF_FORM_EFF_VW

Object Details
Object Name: GMF_FORM_EFF_VW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMF.GMF_FORM_EFF_VW
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Internal helper view for Standard Cost Rollup


[View Source]

Columns
Name Datatype Length Mandatory Comments
RECIPE_ID NUMBER (15) Yes Recipe ID - Primary Key, Unique Identifier for a Recipe
FMEFF_ID NUMBER (15) Yes Validity Rule ID - Primary Key, Unique Identifier for a Recipe Validity Rule
VALIDITY_RULE_STATUS VARCHAR2 (30) Yes The Status of the Recipe Validity Rule. The combination of the Recipe and Validity Rule status will be used to determine what a Recipe can be used for. See the GMD_STATUS table for a list of possible Status's.
STATUS_TYPE VARCHAR2 (30) Yes Status Type
ORGN_CODE VARCHAR2 (4)
Organization Code
ITEM_ID NUMBER (15)
The Item ID (Product) that this Validity Rule is for.
FORMULA_USE VARCHAR2 (30) Yes Formula Use
END_DATE DATE

he start date of the Validity Rule (cannot be used before this date).
START_DATE DATE
Yes The end date of the Validity Rule (cannot be used after this date). This field can be updated even if the Validity Rule is Frozen in order to prevent it from being used anymore.
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.
MIN_QTY NUMBER
Yes The minimum qty for which this Validity Rule can be used, expressed in the UOM entered in the item_um column (derived from the Formula Material line).
MAX_QTY NUMBER
Yes The minimum qty for which this Validity Rule can be used, expressed in the UOM entered in the item_um column (derived from the Formula Material line).
STD_QTY NUMBER
Yes The Standard Batch size for this Validity Rule.
ITEM_UM VARCHAR2 (4)
Unit of Measure for the Min and Max Quantity (derived from the Formula).
PREFERENCE NUMBER (15) Yes Preference indicator used by MRP to select which effectiviity to use if more than one meets the requirements. MRP will select the effectivity with the lowest number in this column.
ROUTING_ID NUMBER (15)
Routing Id
FORMULA_ID NUMBER (10) Yes Formula Id
CUST_ID NUMBER

Cust Id
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
Text Code
TRANS_CNT NUMBER

Trans Cnt
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
PLANNED_PROCESS_LOSS NUMBER

This is the process loss for the validity rule based on the standard quantity
INVENTORY_ITEM_ID NUMBER (15)
Inventory Item Id
REVISION VARCHAR2 (3)
Revision
ORGANIZATION_ID NUMBER (15)
Organization Id
DETAIL_UOM VARCHAR2 (3)
Detail Uom
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RECIPE_ID
,      FMEFF_ID
,      VALIDITY_RULE_STATUS
,      STATUS_TYPE
,      ORGN_CODE
,      ITEM_ID
,      FORMULA_USE
,      END_DATE
,      START_DATE
,      INV_MIN_QTY
,      INV_MAX_QTY
,      MIN_QTY
,      MAX_QTY
,      STD_QTY
,      ITEM_UM
,      PREFERENCE
,      ROUTING_ID
,      FORMULA_ID
,      CUST_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      DELETE_MARK
,      TEXT_CODE
,      TRANS_CNT
,      LAST_UPDATE_LOGIN
,      PLANNED_PROCESS_LOSS
,      INVENTORY_ITEM_ID
,      REVISION
,      ORGANIZATION_ID
,      DETAIL_UOM
FROM APPS.GMF_FORM_EFF_VW;

Dependencies

[top of page]

APPS.GMF_FORM_EFF_VW references the following:

SchemaAPPS
SynonymGMD_RECIPES_B
SynonymGMD_RECIPE_VALIDITY_RULES
SynonymGMD_STATUS_B

APPS.GMF_FORM_EFF_VW is not referenced by any database object