DBA Data[Home] [Help]

VIEW: APPS.QPR_DASHBOARD_MASTER_VL

Source

View Text - Preformatted

SELECT b.dashboard_id, t.dashboard_name, b.user_id, b.plan_id, b.dashboard_type, b.default_flag, b.source_template_id, b.creation_date, b.created_by, b.last_update_date, b.last_updated_by, b.last_update_login FROM qpr_dashboard_master_b b, qpr_dashboard_master_tl t WHERE b.dashboard_id = t.dashboard_id and t.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.DASHBOARD_ID
, T.DASHBOARD_NAME
, B.USER_ID
, B.PLAN_ID
, B.DASHBOARD_TYPE
, B.DEFAULT_FLAG
, B.SOURCE_TEMPLATE_ID
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
FROM QPR_DASHBOARD_MASTER_B B
, QPR_DASHBOARD_MASTER_TL T
WHERE B.DASHBOARD_ID = T.DASHBOARD_ID
AND T.LANGUAGE = USERENV('LANG')