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

VIEW: APPS.IES_SVY_FOOTPRINT_V

Object Details
Object Name: IES_SVY_FOOTPRINT_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


This is a view on a join with ies_transactions, ies_panels, ies_panel_data, ies_footprinting_data. It gathers data for footprinting report.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DSCRIPT_ID NUMBER
Yes Foreign Key to IES_DEPLOYED_SCRIPTS
TRANSACTION_ID NUMBER
Yes Foreign key to IES_TRANSACTIONS
START_TIME DATE

Time the script was started
PANEL_NAME VARCHAR2 (256) Yes Name of the Panel
PANEL_ID NUMBER
Yes Foreign Key to IES_PANEL
TOTAL_TIME NUMBER

Total Time spent on that panel
NUM_PANEL_DATA_ID NUMBER

Foreign key to IES_PANEL_DATA
MIN_TIME NUMBER

Minimum time spent on this panel across all run of the script
MAX_TIME NUMBER

Maximum time spent on this panel across all run of the script
Query Text

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


SELECT DSCRIPT_ID
,      TRANSACTION_ID
,      START_TIME
,      PANEL_NAME
,      PANEL_ID
,      TOTAL_TIME
,      NUM_PANEL_DATA_ID
,      MIN_TIME
,      MAX_TIME
FROM APPS.IES_SVY_FOOTPRINT_V;

Dependencies

[top of page]

APPS.IES_SVY_FOOTPRINT_V references the following:

SchemaAPPS
SynonymIES_FOOTPRINTING_DATA
SynonymIES_PANELS
SynonymIES_PANEL_DATA
SynonymIES_TRANSACTIONS

APPS.IES_SVY_FOOTPRINT_V is not referenced by any database object