VIEW: APPS.CSM_QUERY_VARIABLES_V

Source

View Text - Preformatted

SELECT acc.ACCESS_ID, acc.USER_ID, acc.QUERY_ID, b.VARIABLE_ID, b.VARIABLE_NAME, b.VARIABLE_TYPE, b.VARIABLE_VALUE_CHAR, b.VARIABLE_VALUE_DATE, b.HIDDEN, b.DEFAULT_FLAG, acc.GEN_PK FROM csm_query_variables_ACC acc, CSM_QUERY_VARIABLES_B b WHERE acc.user_id = asg_base.get_user_id AND acc.query_id = b.query_id AND acc.variable_id = b.variable_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, ACC.USER_ID
, ACC.QUERY_ID
, B.VARIABLE_ID
, B.VARIABLE_NAME
, B.VARIABLE_TYPE
, B.VARIABLE_VALUE_CHAR
, B.VARIABLE_VALUE_DATE
, B.HIDDEN
, B.DEFAULT_FLAG
, ACC.GEN_PK
FROM CSM_QUERY_VARIABLES_ACC ACC
, CSM_QUERY_VARIABLES_B B
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.QUERY_ID = B.QUERY_ID
AND ACC.VARIABLE_ID = B.VARIABLE_ID