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_WF_PKG dependencies on ASG_USER

Line 237: FROM ASG_USER usr,

233:
234: --12.1XB7
235: CURSOR c_sr_grp_owner(b_task_id number) IS
236: SELECT USER_ID
237: FROM ASG_USER usr,
238: CS_INCIDENTS_ALL_B inc,
239: JTF_TASKS_B tsk
240: WHERE tsk.TASK_ID=b_task_id
241: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'

Line 247: FROM ASG_USER usr,

243: AND usr.GROUP_ID=inc.owner_group_id --is_mfs_grp
244: AND usr.USER_ID=usr.OWNER_ID
245: UNION ALL
246: SELECT USER_ID --not mfs grp, get SR created by
247: FROM ASG_USER usr,
248: CS_INCIDENTS_ALL_B inc,
249: JTF_TASKS_B tsk
250: WHERE tsk.TASK_ID=b_task_id
251: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'

Line 341: FROM ASG_USER usr,

337:
338: --12.1XB7
339: CURSOR c_sr_grp_owner(b_task_id number) IS
340: SELECT USER_ID
341: FROM ASG_USER usr,
342: CS_INCIDENTS_ALL_B inc,
343: JTF_TASKS_B tsk
344: WHERE tsk.TASK_ID=b_task_id
345: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'

Line 351: FROM ASG_USER usr,

347: AND usr.GROUP_ID=inc.owner_group_id --is_mfs_grp
348: AND usr.USER_ID=usr.OWNER_ID
349: UNION ALL
350: SELECT USER_ID --not mfs grp, get SR created by
351: FROM ASG_USER usr,
352: CS_INCIDENTS_ALL_B inc,
353: JTF_TASKS_B tsk
354: WHERE tsk.TASK_ID=b_task_id
355: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'

Line 557: FROM ASG_USER usr,

553:
554: --12.1XB7
555: CURSOR c_sr_grp_owner(b_task_id number) IS
556: SELECT USER_ID
557: FROM ASG_USER usr,
558: CS_INCIDENTS_ALL_B inc,
559: JTF_TASKS_B tsk
560: WHERE tsk.TASK_ID=b_task_id
561: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'

Line 567: FROM ASG_USER usr,

563: AND usr.GROUP_ID=inc.owner_group_id --is_mfs_grp
564: AND usr.USER_ID=usr.OWNER_ID
565: UNION ALL
566: SELECT USER_ID --not mfs grp, get SR created by
567: FROM ASG_USER usr,
568: CS_INCIDENTS_ALL_B inc,
569: JTF_TASKS_B tsk
570: WHERE tsk.TASK_ID=b_task_id
571: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'

Line 950: FROM ASG_USER usr,

946:
947: --12.1XB7
948: CURSOR c_sr_grp_owner(b_task_id number) IS
949: SELECT USER_ID
950: FROM ASG_USER usr,
951: CS_INCIDENTS_ALL_B inc,
952: JTF_TASKS_B tsk
953: WHERE tsk.TASK_ID=b_task_id
954: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'

Line 960: FROM ASG_USER usr,

956: AND usr.GROUP_ID=inc.owner_group_id --is_mfs_grp
957: AND usr.USER_ID=usr.OWNER_ID
958: UNION ALL
959: SELECT USER_ID --not mfs grp, get SR created by
960: FROM ASG_USER usr,
961: CS_INCIDENTS_ALL_B inc,
962: JTF_TASKS_B tsk
963: WHERE tsk.TASK_ID=b_task_id
964: AND tsk.SOURCE_OBJECT_TYPE_CODE='SR'

Line 1503: AND EXISTS(SELECT 1 FROM ASG_USER WHERE GROUP_ID=csa.OWNER_GROUP_ID AND NVL(MULTI_PLATFORM,'N')='N')

1499: IS
1500: SELECT 1
1501: FROM cs_incidents_all_b csa
1502: WHERE csa.incident_id = p_incident_id
1503: AND EXISTS(SELECT 1 FROM ASG_USER WHERE GROUP_ID=csa.OWNER_GROUP_ID AND NVL(MULTI_PLATFORM,'N')='N')
1504: UNION ALL
1505: SELECT 1
1506: FROM cs_incidents_all_b csa
1507: WHERE csa.incident_id = p_incident_id

Line 1508: AND EXISTS(SELECT 1 FROM ASG_USER WHERE USER_ID=csa.created_by AND NVL(MULTI_PLATFORM,'N')='N')

1504: UNION ALL
1505: SELECT 1
1506: FROM cs_incidents_all_b csa
1507: WHERE csa.incident_id = p_incident_id
1508: AND EXISTS(SELECT 1 FROM ASG_USER WHERE USER_ID=csa.created_by AND NVL(MULTI_PLATFORM,'N')='N')
1509: UNION ALL
1510: SELECT 1
1511: FROM jtf_tasks_b jt
1512: WHERE jt.source_object_id = p_incident_id

Line 1514: AND EXISTS(SELECT 1 FROM ASG_USER WHERE USER_ID=jt.created_by AND NVL(MULTI_PLATFORM,'N')='N')

1510: SELECT 1
1511: FROM jtf_tasks_b jt
1512: WHERE jt.source_object_id = p_incident_id
1513: AND jt.source_object_type_code = 'SR'
1514: AND EXISTS(SELECT 1 FROM ASG_USER WHERE USER_ID=jt.created_by AND NVL(MULTI_PLATFORM,'N')='N')
1515: UNION ALL
1516: SELECT 1
1517: FROM jtf_task_assignments jta,
1518: jtf_tasks_b jt

Line 1523: AND EXISTS(SELECT 1 FROM ASG_USER WHERE resource_id = jta.resource_id);

1519: WHERE jt.source_object_id = p_incident_id
1520: AND jt.source_object_type_code = 'SR'
1521: AND jta.task_id = jt.task_id
1522: AND jta.resource_type_code='RS_EMPLOYEE'
1523: AND EXISTS(SELECT 1 FROM ASG_USER WHERE resource_id = jta.resource_id);
1524:
1525: BEGIN
1526:
1527: l_incident_id := cs_servicerequest_pvt.user_hooks_rec.request_id;

Line 2228: asg_user au

2224: effective_date_start,
2225: effective_date_end,
2226: default_code
2227: FROM csp_inv_loc_assignments cila,
2228: asg_user au
2229: WHERE cila.csp_inv_loc_assignment_id = p_csp_inv_loc_assignment_id
2230: AND au.resource_id = cila.resource_id;
2231:
2232: BEGIN

Line 2301: asg_user au

2297: cila.resource_id,
2298: au.user_id,
2299: cila.default_code
2300: FROM csp_inv_loc_assignments cila,
2301: asg_user au
2302: WHERE cila.csp_inv_loc_assignment_id = p_csp_inv_loc_assignment_id
2303: AND au.resource_id = cila.resource_id;
2304:
2305: BEGIN

Line 2402: asg_user au

2398: FROM po_location_associations_all pla,
2399: hz_cust_site_uses_all csu,
2400: hz_cust_acct_sites_all cas,
2401: csp_rs_cust_relations rcr,
2402: asg_user au
2403: WHERE pla.location_id = p_locationid
2404: AND csu.site_use_id = pla.site_use_id
2405: AND csu.site_use_code = 'SHIP_TO'
2406: AND csu.cust_acct_site_id = cas.cust_acct_site_id