VIEW: APPS.CSM_QUERY_INSTANCES_V

Source

View Text - Preformatted

SELECT acc.ACCESS_ID, acc.USER_ID, acc.QUERY_ID, acc.INSTANCE_ID, acc.INSTANCE_NAME, acc.QUERY_START_TIME, acc.QUERY_END_TIME, acc.STATUS, acc.ERROR_DESCRIPTION FROM csm_query_instances_acc acc WHERE acc.user_id = asg_base.get_user_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, ACC.USER_ID
, ACC.QUERY_ID
, ACC.INSTANCE_ID
, ACC.INSTANCE_NAME
, ACC.QUERY_START_TIME
, ACC.QUERY_END_TIME
, ACC.STATUS
, ACC.ERROR_DESCRIPTION
FROM CSM_QUERY_INSTANCES_ACC ACC
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID