VIEW: APPS.CSF_M_STATE_TRANSITIONS_V

Source

View Text - Preformatted

SELECT acc.access_id, jst.state_transition_id, jst.initial_state_id, jst.final_state_id, jst.RULE_ID FROM jtf_state_transitions jst, csm_state_transitions_acc acc WHERE acc.state_transition_id = jst.state_transition_id AND acc.user_id = asg_base.get_user_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, JST.STATE_TRANSITION_ID
, JST.INITIAL_STATE_ID
, JST.FINAL_STATE_ID
, JST.RULE_ID
FROM JTF_STATE_TRANSITIONS JST
, CSM_STATE_TRANSITIONS_ACC ACC
WHERE ACC.STATE_TRANSITION_ID = JST.STATE_TRANSITION_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID