VIEW: APPS.CSM_QUERY_V

Source

View Text - Preformatted

SELECT acc.ACCESS_ID, acc.USER_ID, acc.QUERY_ID, b.QUERY_NAME, tl.DESCRIPTION, b.QUERY_TYPE, b.QUERY_TEXT1, b.QUERY_TEXT2, b.QUERY_OUTPUT_FORMAT, b.MIME_TYPE, b.WORK_FLOW, b.RETENTION_DAYS, b.SAVED_QUERY, b.TEMPLATE, b.TEMPLATE_FILE, b.PARENT_QUERY_ID, b.SEEDED, b.EXECUTION_MODE, b.RETENTION_POLICY FROM csm_query_acc acc, csm_query_tl tl, csm_query_b b WHERE acc.query_id = b.query_id AND acc.user_id = asg_base.get_user_id AND acc.query_id = tl.query_id AND tl.LANGUAGE = asg_base.get_language

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, ACC.USER_ID
, ACC.QUERY_ID
, B.QUERY_NAME
, TL.DESCRIPTION
, B.QUERY_TYPE
, B.QUERY_TEXT1
, B.QUERY_TEXT2
, B.QUERY_OUTPUT_FORMAT
, B.MIME_TYPE
, B.WORK_FLOW
, B.RETENTION_DAYS
, B.SAVED_QUERY
, B.TEMPLATE
, B.TEMPLATE_FILE
, B.PARENT_QUERY_ID
, B.SEEDED
, B.EXECUTION_MODE
, B.RETENTION_POLICY
FROM CSM_QUERY_ACC ACC
, CSM_QUERY_TL TL
, CSM_QUERY_B B
WHERE ACC.QUERY_ID = B.QUERY_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.QUERY_ID = TL.QUERY_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE