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 CS_INCIDENTS_ALL_B

Line 238: CS_INCIDENTS_ALL_B inc,

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'
242: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID

Line 248: CS_INCIDENTS_ALL_B inc,

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'
252: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID

Line 342: CS_INCIDENTS_ALL_B inc,

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'
346: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID

Line 352: CS_INCIDENTS_ALL_B inc,

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'
356: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID

Line 558: CS_INCIDENTS_ALL_B inc,

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'
562: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID

Line 568: CS_INCIDENTS_ALL_B inc,

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'
572: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID

Line 951: CS_INCIDENTS_ALL_B inc,

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'
955: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID

Line 961: CS_INCIDENTS_ALL_B inc,

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'
965: AND tsk.SOURCE_OBJECT_ID=inc.INCIDENT_ID

Line 1237: FROM cs_incidents_all_b

1233:
1234: CURSOR l_sr_csr(p_incident_id IN NUMBER)
1235: IS
1236: SELECT owner_group_id,created_by
1237: FROM cs_incidents_all_b
1238: WHERE incident_id = p_incident_id;
1239:
1240: BEGIN
1241:

Line 1302: FROM cs_incidents_all_b csi

1298: incident_location_id,
1299: customer_id,
1300: incident_location_id,
1301: owner_group_id
1302: FROM cs_incidents_all_b csi
1303: WHERE incident_id = p_incident_id;
1304:
1305: CURSOR l_addr_id_csr (b_incident_id IN NUMBER)
1306: IS

Line 1423: l_install_site_id cs_incidents_all_b.install_site_id%TYPE;

1419: --12.1
1420: Procedure SR_Post_Upd( x_return_status OUT NOCOPY VARCHAR2)
1421: IS
1422: l_incident_id cs_incidents_all.incident_id%TYPE;
1423: l_install_site_id cs_incidents_all_b.install_site_id%TYPE;
1424: l_is_install_site_updated char(1);
1425: l_sr_customer_id cs_incidents_all_b.customer_id%TYPE;
1426: l_is_sr_customer_updated char(1);
1427: l_inventory_item_id cs_incidents_all_b.inventory_item_id%TYPE;

Line 1425: l_sr_customer_id cs_incidents_all_b.customer_id%TYPE;

1421: IS
1422: l_incident_id cs_incidents_all.incident_id%TYPE;
1423: l_install_site_id cs_incidents_all_b.install_site_id%TYPE;
1424: l_is_install_site_updated char(1);
1425: l_sr_customer_id cs_incidents_all_b.customer_id%TYPE;
1426: l_is_sr_customer_updated char(1);
1427: l_inventory_item_id cs_incidents_all_b.inventory_item_id%TYPE;
1428: l_is_inventory_item_updated char(1);
1429: l_instance_id cs_incidents_all_b.customer_product_id%TYPE;

Line 1427: l_inventory_item_id cs_incidents_all_b.inventory_item_id%TYPE;

1423: l_install_site_id cs_incidents_all_b.install_site_id%TYPE;
1424: l_is_install_site_updated char(1);
1425: l_sr_customer_id cs_incidents_all_b.customer_id%TYPE;
1426: l_is_sr_customer_updated char(1);
1427: l_inventory_item_id cs_incidents_all_b.inventory_item_id%TYPE;
1428: l_is_inventory_item_updated char(1);
1429: l_instance_id cs_incidents_all_b.customer_product_id%TYPE;
1430: l_is_sr_instance_updated char(1);
1431: l_rec_count number;

Line 1429: l_instance_id cs_incidents_all_b.customer_product_id%TYPE;

1425: l_sr_customer_id cs_incidents_all_b.customer_id%TYPE;
1426: l_is_sr_customer_updated char(1);
1427: l_inventory_item_id cs_incidents_all_b.inventory_item_id%TYPE;
1428: l_is_inventory_item_updated char(1);
1429: l_instance_id cs_incidents_all_b.customer_product_id%TYPE;
1430: l_is_sr_instance_updated char(1);
1431: l_rec_count number;
1432: l_is_sr_contact_ins char(1);
1433: l_is_sr_contact_upd char(1);

Line 1441: l_incident_location_id cs_incidents_all_b.incident_location_id%TYPE;

1437: l_sqlerrno VARCHAR2(20);
1438: l_sqlerrmsg VARCHAR2(4000);
1439: l_error_msg VARCHAR2(4000);
1440: l_return_status VARCHAR2(2000);
1441: l_incident_location_id cs_incidents_all_b.incident_location_id%TYPE;
1442: l_is_incident_location_updated char(1);
1443: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE;
1444: l_is_owner_changed char(1);
1445: l_old_owner NUMBER;

Line 1460: FROM cs_incidents_all_b

1456: contract_service_id,
1457: incident_location_id,
1458: owner_group_id,
1459: created_by
1460: FROM cs_incidents_all_b
1461: WHERE incident_id = p_incident_id;
1462:
1463: l_sr_post_upd_rec l_sr_post_upd_csr%ROWTYPE;
1464:

Line 1501: FROM cs_incidents_all_b csa

1497: --12.1XB6
1498: CURSOR l_is_mobile_sr_csr(p_incident_id IN NUMBER)
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

Line 1506: 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
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