DBA Data[Home] [Help]

VIEW: APPS.CSF_DC_QUERY_EXTNS_V

Source

View Text - Preformatted

SELECT a.rowid row_id, a.user_id, a.query_id, a.created_by, a.creation_date, a.last_updated_by, a.last_update_date, a.last_update_login, a.object_version_number, a.owner_enabled_flag, b.name query_name, b.where_clause, b.seeded_flag from csf_dc_query_extns a, csf_dc_queries_vl b WHERE a.query_id = b.query_id
View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.USER_ID
, A.QUERY_ID
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.OBJECT_VERSION_NUMBER
, A.OWNER_ENABLED_FLAG
, B.NAME QUERY_NAME
, B.WHERE_CLAUSE
, B.SEEDED_FLAG
FROM CSF_DC_QUERY_EXTNS A
, CSF_DC_QUERIES_VL B
WHERE A.QUERY_ID = B.QUERY_ID