[Home] [Help]
VIEW: APPS.CSM_STATE_RESPONSIBILITIES_V
Source
View Text - Preformatted
SELECT ACC.ACCESS_ID , B.STATE_RESPONSIBILITY_ID , B.RESPONSIBILITY_ID , B.RULE_ID FROM JTF_STATE_RESPONSIBILITIES B , CSM_STATE_RESPONSIBILITY_ACC ACC WHERE B.STATE_RESPONSIBILITY_ID = ACC.STATE_RESPONSIBILITY_ID
View Text - HTML Formatted
SELECT ACC.ACCESS_ID
, B.STATE_RESPONSIBILITY_ID
, B.RESPONSIBILITY_ID
, B.RULE_ID
FROM JTF_STATE_RESPONSIBILITIES B
, CSM_STATE_RESPONSIBILITY_ACC ACC
WHERE B.STATE_RESPONSIBILITY_ID = ACC.STATE_RESPONSIBILITY_ID