VIEW: APPS.CSF_DC_QUERIES_VL

Source

View Text - Preformatted

SELECT cdqb.rowid row_id , cdqb.query_id , cdqb.created_by , cdqb.creation_date , cdqb.last_updated_by , cdqb.last_update_date , cdqb.last_update_login , cdqb.object_version_number , cdqt.name , cdqt.description , cdqb.where_clause , cdqb.user_id , cdqb.seeded_flag , cdqb.start_date_active , cdqb.end_date_active from csf_dc_queries_b cdqb , csf_dc_queries_tl cdqt WHERE cdqb.query_id = cdqt.query_id and cdqt.language = userenv('LANG')

View Text - HTML Formatted

SELECT CDQB.ROWID ROW_ID
, CDQB.QUERY_ID
, CDQB.CREATED_BY
, CDQB.CREATION_DATE
, CDQB.LAST_UPDATED_BY
, CDQB.LAST_UPDATE_DATE
, CDQB.LAST_UPDATE_LOGIN
, CDQB.OBJECT_VERSION_NUMBER
, CDQT.NAME
, CDQT.DESCRIPTION
, CDQB.WHERE_CLAUSE
, CDQB.USER_ID
, CDQB.SEEDED_FLAG
, CDQB.START_DATE_ACTIVE
, CDQB.END_DATE_ACTIVE
FROM CSF_DC_QUERIES_B CDQB
, CSF_DC_QUERIES_TL CDQT
WHERE CDQB.QUERY_ID = CDQT.QUERY_ID
AND CDQT.LANGUAGE = USERENV('LANG')