VIEW: APPS.CSM_AD_SEARCH_REGION_V

Source

View Text - Preformatted

SELECT acc.access_id, casv.ID, casv.SEARCH_TYPE_ID, casv.NAME, casv.COLUMN_NAME, casv.FIELD_TYPE, casv.BASE_VO, casv.PARAMETERS, casv.VO_TEXT_COL, casv.VO_VALUE_COL, casv.DISPLAY_SEQ, casv.level_id, casv.level_value, casv.DB_TYPE, casv.OPERATION FROM CSM_AD_SEARCH_REGION_VIEW casv , CSM_AD_SEARCH_REGION_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.FIELD_TYPE
, CASV.BASE_VO
, CASV.PARAMETERS
, CASV.VO_TEXT_COL
, CASV.VO_VALUE_COL
, CASV.DISPLAY_SEQ
, CASV.LEVEL_ID
, CASV.LEVEL_VALUE
, CASV.DB_TYPE
, CASV.OPERATION
FROM CSM_AD_SEARCH_REGION_VIEW CASV
, CSM_AD_SEARCH_REGION_ACC ACC
WHERE CASV.ID=ACC.ID
AND NVL(CASV.IS_REMOVED
, 'N')='N'