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.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on CS_SR_EVENT_CODES_B

Line 123: CS_SR_EVENT_CODES_B cec

119: to_char(null) role_group_type,
120: to_char(null) role_group_code
121: FROM CS_SR_ACTION_TRIGGERS csat,
122: CS_SR_ACTION_DETAILS csad,
123: CS_SR_EVENT_CODES_B cec
124: WHERE
125: cec.WF_BUSINESS_EVENT_ID = l_event_name
126: and csat.EVENT_CODE = cec.EVENT_CODE
127: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))

Line 151: CS_SR_EVENT_CODES_B cec

147: to_char(null) role_group_type,
148: to_char(null) role_group_code
149: FROM CS_SR_ACTION_TRIGGERS csat,
150: CS_SR_ACTION_DETAILS csad,
151: CS_SR_EVENT_CODES_B cec
152: WHERE
153: cec.WF_BUSINESS_EVENT_ID = l_event_name
154: and csat.EVENT_CODE = cec.EVENT_CODE
155: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))

Line 189: CS_SR_EVENT_CODES_B cec

185: role_group_type,
186: role_group_code
187: FROM CS_SR_ACTION_TRIGGERS csat,
188: CS_SR_ACTION_DETAILS csad,
189: CS_SR_EVENT_CODES_B cec
190: /* 03/01/2004 - RHUNGUND - Bug fix for 3412833
191: Commenting the following table from the FROM clause since it was resulting
192: in a cartesian join
193:

Line 625: CS_SR_EVENT_CODES_B cec

621: csat.incident_status_id trigger_incident_status_id,
622: csat.relationship_type_id trigger_link_type
623: FROM CS_SR_ACTION_TRIGGERS csat,
624: CS_SR_ACTION_DETAILS csad,
625: CS_SR_EVENT_CODES_B cec
626: WHERE
627: cec.WF_BUSINESS_EVENT_ID = l_event_name
628: and csat.EVENT_CODE = cec.EVENT_CODE
629: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))

Line 4746: CS_SR_EVENT_CODES_B cec

4742: csad.action_code,
4743: csad.notification_template_id
4744: FROM CS_SR_ACTION_TRIGGERS csat,
4745: CS_SR_ACTION_DETAILS csad,
4746: CS_SR_EVENT_CODES_B cec
4747: WHERE
4748: cec.WF_BUSINESS_EVENT_ID = l_event_name
4749: and csat.EVENT_CODE = cec.EVENT_CODE
4750: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))

Line 5037: FROM CS_SR_EVENT_CODES_B cec,

5033: csat.incident_status_id trigger_incident_status_id,
5034: csad.relationship_type_id detail_link_type,
5035: csad.incident_status_id detail_incident_status_id,
5036: csad.resolution_code
5037: FROM CS_SR_EVENT_CODES_B cec,
5038: CS_SR_ACTION_TRIGGERS csat,
5039: CS_SR_ACTION_DETAILS csad
5040: WHERE
5041: cec.WF_BUSINESS_EVENT_ID = l_event_name

Line 6051: CS_SR_EVENT_CODES_B cec

6047: csad.action_code,
6048: to_char(csad.event_condition_id) || csad.action_code index_cols
6049: FROM CS_SR_ACTION_TRIGGERS csat,
6050: CS_SR_ACTION_DETAILS csad,
6051: CS_SR_EVENT_CODES_B cec
6052: WHERE
6053: cec.WF_BUSINESS_EVENT_ID = l_event_name
6054: and csat.EVENT_CODE = cec.EVENT_CODE
6055: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))

Line 6076: CS_SR_EVENT_CODES_B cec

6072: csad.action_code,
6073: to_char(csad.event_condition_id) || csad.action_code index_cols
6074: FROM CS_SR_ACTION_TRIGGERS csat,
6075: CS_SR_ACTION_DETAILS csad,
6076: CS_SR_EVENT_CODES_B cec
6077: WHERE
6078: cec.WF_BUSINESS_EVENT_ID = l_event_name
6079: and csat.EVENT_CODE = cec.EVENT_CODE
6080: and TRUNC(SYSDATE) BETWEEN TRUNC(NVL(csat.start_date_active, SYSDATE))