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_NOTIFICATION_EVENT_PKG dependencies on HZ_PARTY_SITES

Line 1089: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),

1085: IS
1086: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address, b.TASK_ID,TASK_NAME,TASK_NUMBER,
1087: INCIDENT_NUMBER, INC_TL.SUMMARY,hp.party_name ,
1088: decode(nvl(inc.incident_location_type,'HZ_PARTY_SITE'), 'HZ_PARTY_SITE',
1089: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1090: 'HZ_LOCATION',
1091: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1092: ) location_id
1093: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,

Line 1117: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),

1113: IS
1114: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address, acc.TASK_ID,TASK_NAME,TASK_NUMBER,
1115: INCIDENT_NUMBER, INC_TL.SUMMARY,hp.party_name ,
1116: decode(nvl(inc.incident_location_type,'HZ_PARTY_SITE'), 'HZ_PARTY_SITE',
1117: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1118: 'HZ_LOCATION',
1119: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1120: ) location_id
1121: FROM ASG_USER AU, CSM_TASKS_ACC ACC,

Line 1141: (select location_id from hz_party_sites where party_site_id =tsk.address_id) location_id

1137:
1138: CURSOR c_user_task2(b_task_id NUMBER)
1139: IS
1140: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address, acc.TASK_ID,TASK_NAME,TASK_NUMBER,
1141: (select location_id from hz_party_sites where party_site_id =tsk.address_id) location_id
1142: FROM ASG_USER AU, CSM_TASKS_ACC ACC,
1143: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr
1144: WHERE acc.TASK_ID=b_task_id
1145: AND acc.TASK_ID=tsk.TASK_ID

Line 1157: (select location_id from hz_party_sites where party_site_id =tsk.address_id) location_id

1153:
1154: CURSOR c_user_task_assigned2(b_task_ass_id NUMBER)
1155: IS
1156: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address, b.TASK_ID,TASK_NAME,TASK_NUMBER,
1157: (select location_id from hz_party_sites where party_site_id =tsk.address_id) location_id
1158: FROM ASG_USER AU, JTF_TASK_ASSIGNMENTS b,CSM_TASK_ASSIGNMENTS_ACC ACC,
1159: JTF_TASKS_B tsk,JTF_TASKS_TL tsk_tl, fnd_user usr
1160: WHERE au.RESOURCE_ID=b.RESOURCE_ID
1161: AND b.TASK_ASSIGNMENT_ID=b_task_ass_id

Line 1175: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),

1171: CURSOR c_user_sr(b_inc_id NUMBER)
1172: IS
1173: SELECT usr.USER_ID,usr.USER_NAME,usr.email_address,acc.INCIDENT_ID,INCIDENT_NUMBER, INC_TL.SUMMARY,hp.party_name,
1174: decode(nvl(inc.incident_location_type,'HZ_PARTY_SITE'), 'HZ_PARTY_SITE',
1175: (select location_id from hz_party_sites where party_site_id = NVL(inc.incident_location_id, inc.install_site_id)),
1176: 'HZ_LOCATION',
1177: (select location_id from hz_locations where location_id = NVL(inc.incident_location_id, inc.install_site_id))
1178: ) location_id
1179: FROM ASG_USER AU, CSM_INCIDENTS_ALL_ACC ACC,cs_incidents_all_b INC,