[Home] [Help]
[Dependency Information]
VIEW: APPS.MSD_FLD_SER_USG_HISTORY_V
Object Details
Object Name: | MSD_FLD_SER_USG_HISTORY_V |
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
INVENTORY_ITEM_ID |
NUMBER |
|
Yes |
|
ITEM_NAME |
VARCHAR2 |
(250) |
Yes |
|
ZONE_ID |
NUMBER |
|
|
|
ZONE |
VARCHAR2 |
(30) |
|
|
USG_DATE |
DATE |
|
|
|
USG_QUANTITY |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, ITEM_NAME
, ZONE_ID
, ZONE
, USG_DATE
, USG_QUANTITY
FROM APPS.MSD_FLD_SER_USG_HISTORY_V;
Dependencies
[top of page]
APPS.MSD_FLD_SER_USG_HISTORY_V references the following:
-
APPS
-
MSC_ITEMS
-
MSD_DEM_FLD_SER_USG_HISTORY
APPS.MSD_FLD_SER_USG_HISTORY_V is referenced by following:
-
APPS
-
MSC_MSD_HISTORY_V