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

VIEW: APPS.FM_FORM_EFF_VW1

Object Details
Object Name: FM_FORM_EFF_VW1
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMD.FM_FORM_EFF_VW1
Subobject Name:
Status: VALID

View Type

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


NOT CURRENTLY USED.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGN_CODE VARCHAR2 (4)
Organization Code
ITEM_ID NUMBER (15)
Item ID
END_DATE DATE

End Date
FMEFF_ID NUMBER (15) Yes Formula Effectivity Identifier
STD_QTY NUMBER
Yes Standard Quantity
ITEM_UM VARCHAR2 (4)
Item UOM
FORMULA_ID NUMBER (10) Yes Formula Identifier
Query Text

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


SELECT ORGN_CODE
,      ITEM_ID
,      END_DATE
,      FMEFF_ID
,      STD_QTY
,      ITEM_UM
,      FORMULA_ID
FROM APPS.FM_FORM_EFF_VW1;

Dependencies

[top of page]

APPS.FM_FORM_EFF_VW1 references the following:

SchemaAPPS
SynonymFM_FORM_EFF

APPS.FM_FORM_EFF_VW1 is not referenced by any database object