VIEW: APPS.CSM_AD_SIMPLE_SEARCH_V

Source

View Text - Preformatted

SELECT acc.access_id, casv.ID, casv.SEARCH_TYPE_ID, casv.NAME, casv.COLUMN_NAME , casv.DISPLAY_SEQ , casv.GROUP_TYPE, casv.level_id, casv.level_value, casv.DB_TYPE, casv.OPERATION FROM CSM_AD_SIMPLE_SEARCH_VIEW casv , CSM_AD_SIMPLE_SEARCH_ACC acc WHERE casv.id=acc.id and NVL(casv.IS_REMOVED,'N')='N'

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, CASV.ID
, CASV.SEARCH_TYPE_ID
, CASV.NAME
, CASV.COLUMN_NAME
, CASV.DISPLAY_SEQ
, CASV.GROUP_TYPE
, CASV.LEVEL_ID
, CASV.LEVEL_VALUE
, CASV.DB_TYPE
, CASV.OPERATION
FROM CSM_AD_SIMPLE_SEARCH_VIEW CASV
, CSM_AD_SIMPLE_SEARCH_ACC ACC
WHERE CASV.ID=ACC.ID
AND NVL(CASV.IS_REMOVED
, 'N')='N'