VIEW: APPS.FND_IMP_SSUMMARY_VL

Source

View Text - Preformatted

SELECT x.snapshot_id snapshot_id, x.snapshot_name snapshot_name, x.snapshot_type snapshot_type, x.appl_top_id appl_top_id, y.name appl_top_name, y.description appl_top_desc from ad_snapshots x, ad_appl_tops y WHERE x.appl_top_id = y.appl_top_id(+)

View Text - HTML Formatted

SELECT X.SNAPSHOT_ID SNAPSHOT_ID
, X.SNAPSHOT_NAME SNAPSHOT_NAME
, X.SNAPSHOT_TYPE SNAPSHOT_TYPE
, X.APPL_TOP_ID APPL_TOP_ID
, Y.NAME APPL_TOP_NAME
, Y.DESCRIPTION APPL_TOP_DESC
FROM AD_SNAPSHOTS X
, AD_APPL_TOPS Y
WHERE X.APPL_TOP_ID = Y.APPL_TOP_ID(+)