VIEW: APPS.IES_SVY_FOOTPRINT_V

Source

View Text - Preformatted

SELECT a.dscript_id DSCRIPT_ID, a.transaction_id TRANSACTION_ID, trunc(a.start_time) START_TIME, b.panel_name PANEL_NAME, b.panel_id PANEL_ID, SUM(c.elapsed_time) TOTAL_TIME, COUNT(c.panel_data_id) NUM_PANEL_DATA_ID, MIN(c.elapsed_time) MIN_TIME, MAX(c.elapsed_time) MAX_TIME FROM ies_transactions a, ies_panels b, ies_footprinting_data c, ies_panel_data d WHERE a.dscript_id = b.dscript_id AND a.transaction_id = d.transaction_id AND c.panel_data_id = d.panel_data_id AND b.panel_id = d.panel_id GROUP BY a.dscript_ID, a.transaction_id, start_time, panel_name, b.panel_id

View Text - HTML Formatted

SELECT A.DSCRIPT_ID DSCRIPT_ID
, A.TRANSACTION_ID TRANSACTION_ID
, TRUNC(A.START_TIME) START_TIME
, B.PANEL_NAME PANEL_NAME
, B.PANEL_ID PANEL_ID
, SUM(C.ELAPSED_TIME) TOTAL_TIME
, COUNT(C.PANEL_DATA_ID) NUM_PANEL_DATA_ID
, MIN(C.ELAPSED_TIME) MIN_TIME
, MAX(C.ELAPSED_TIME) MAX_TIME
FROM IES_TRANSACTIONS A
, IES_PANELS B
, IES_FOOTPRINTING_DATA C
, IES_PANEL_DATA D
WHERE A.DSCRIPT_ID = B.DSCRIPT_ID
AND A.TRANSACTION_ID = D.TRANSACTION_ID
AND C.PANEL_DATA_ID = D.PANEL_DATA_ID
AND B.PANEL_ID = D.PANEL_ID GROUP BY A.DSCRIPT_ID
, A.TRANSACTION_ID
, START_TIME
, PANEL_NAME
, B.PANEL_ID