DBA Data[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