eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_STATE_TRANSITION_EVENT_PKG dependencies on JTF_STATE_TRANSITIONS

Line 16: FROM JTF_STATE_TRANSITIONS trn

12: SELECT ACCESS_ID,USER_ID
13: FROM CSM_STATE_TRANSITIONS_ACC acc
14: WHERE acc.USER_ID = p_user_id
15: AND STATE_TRANSITION_ID not in (SELECT STATE_TRANSITION_ID
16: FROM JTF_STATE_TRANSITIONS trn
17: WHERE RULE_ID IN (SELECT sresp.RULE_ID
18: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule
19: WHERE RESPONSIBILITY_ID = p_resp_id
20: AND sresp.RULE_ID = srule.RULE_ID

Line 25: FROM JTF_STATE_TRANSITIONS trn,

21: AND srule.STATE_TYPE = 'TASK_STATUS'));
22:
23: CURSOR l_updates_cur IS
24: SELECT acc.ACCESS_ID,acc.USER_ID
25: FROM JTF_STATE_TRANSITIONS trn,
26: CSM_STATE_TRANSITIONS_ACC acc
27: WHERE trn.state_transition_id = acc.state_transition_id
28: AND acc.user_id = p_user_id AND trn.LAST_UPDATE_DATE > p_lrd;
29:

Line 76: FROM JTF_STATE_TRANSITIONS trn

72: l_str_tab asg_download.access_list;
73:
74: CURSOR l_inserts_cur IS
75: SELECT CSM_STATE_TRANSITIONS_ACC_S.NEXTVAL,p_user_id,trn.state_transition_id
76: FROM JTF_STATE_TRANSITIONS trn
77: WHERE trn.RULE_ID IN (SELECT sresp.RULE_ID
78: FROM JTF_STATE_RESPONSIBILITIES sresp, JTF_STATE_RULES_B srule
79: WHERE sresp.RULE_ID = srule.RULE_ID
80: AND srule.STATE_TYPE = 'TASK_STATUS'