VIEW: APPS.CSM_AD_SEARCH_TITLE_V

Source

View Text - Preformatted

SELECT acc.access_id, cast. ID, cast.SEARCH_TYPE, cast.SEARCH_TITLE, cast. VO_NAME, cast.level_id, cast.level_value, cast.SEARCH_TYPE_ID FROM CSM_AD_SEARCH_TITLE_VIEW cast, CSM_AD_SEARCH_TITLE_ACC acc WHERE cast.search_type = acc.search_type

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, CAST. ID
, CAST.SEARCH_TYPE
, CAST.SEARCH_TITLE
, CAST. VO_NAME
, CAST.LEVEL_ID
, CAST.LEVEL_VALUE
, CAST.SEARCH_TYPE_ID
FROM CSM_AD_SEARCH_TITLE_VIEW CAST
, CSM_AD_SEARCH_TITLE_ACC ACC
WHERE CAST.SEARCH_TYPE = ACC.SEARCH_TYPE