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 238: FROM ASG_USER usr,

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

Line 252: AND not exists (select 1 from asg_user where group_id=inc.owner_group_id) --is_not mfs_grp

248: )
249: OR
250: ((
251: (inc.owner_group_id IS NOT NULL
252: AND not exists (select 1 from asg_user where group_id=inc.owner_group_id) --is_not mfs_grp
253: )
254: OR
255: (inc.owner_group_id IS NULL)
256: )

Line 345: FROM ASG_USER usr,

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

Line 359: AND not exists (select 1 from asg_user where group_id=inc.owner_group_id) --is_not mfs_grp

355: )
356: OR
357: ((
358: (inc.owner_group_id IS NOT NULL
359: AND not exists (select 1 from asg_user where group_id=inc.owner_group_id) --is_not mfs_grp
360: )
361: OR
362: (inc.owner_group_id IS NULL)
363: )

Line 561: FROM ASG_USER usr,

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

Line 575: AND not exists (select 1 from asg_user where group_id=inc.owner_group_id) --is_not mfs_grp

571: )
572: OR
573: ((
574: (inc.owner_group_id IS NOT NULL
575: AND not exists (select 1 from asg_user where group_id=inc.owner_group_id) --is_not mfs_grp
576: )
577: OR
578: (inc.owner_group_id IS NULL)
579: )

Line 952: FROM ASG_USER usr,

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

Line 966: AND not exists (select 1 from asg_user where group_id=inc.owner_group_id) --is_not mfs_grp

962: )
963: OR
964: ((
965: (inc.owner_group_id IS NOT NULL
966: AND not exists (select 1 from asg_user where group_id=inc.owner_group_id) --is_not mfs_grp
967: )
968: OR
969: (inc.owner_group_id IS NULL)
970: )

Line 1495: FROM ASG_USER au,

1491: --12.1XB6
1492: CURSOR l_is_mobile_sr_csr(p_incident_id IN NUMBER)
1493: IS
1494: SELECT 1
1495: FROM ASG_USER au,
1496: cs_incidents_all_b csa
1497: WHERE csa.incident_id = p_incident_id
1498: AND (csa.OWNER_GROUP_ID = au.GROUP_ID AND au.USER_ID=au.OWNER_ID)
1499: OR

Line 2212: asg_user au

2208: effective_date_start,
2209: effective_date_end,
2210: default_code
2211: FROM csp_inv_loc_assignments cila,
2212: asg_user au
2213: WHERE cila.csp_inv_loc_assignment_id = p_csp_inv_loc_assignment_id
2214: AND au.resource_id = cila.resource_id;
2215:
2216: BEGIN

Line 2285: asg_user au

2281: cila.resource_id,
2282: au.user_id,
2283: cila.default_code
2284: FROM csp_inv_loc_assignments cila,
2285: asg_user au
2286: WHERE cila.csp_inv_loc_assignment_id = p_csp_inv_loc_assignment_id
2287: AND au.resource_id = cila.resource_id;
2288:
2289: BEGIN