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 239: CS_INCIDENTS_ALL_B inc,

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

Line 346: CS_INCIDENTS_ALL_B inc,

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

Line 562: CS_INCIDENTS_ALL_B inc,

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

Line 953: CS_INCIDENTS_ALL_B inc,

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

Line 1234: FROM cs_incidents_all_b

1230:
1231: CURSOR l_sr_csr(p_incident_id IN NUMBER)
1232: IS
1233: SELECT owner_group_id,created_by
1234: FROM cs_incidents_all_b
1235: WHERE incident_id = p_incident_id;
1236:
1237: BEGIN
1238: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1296: FROM cs_incidents_all_b csi

1292: incident_location_id,
1293: customer_id,
1294: incident_location_id,
1295: owner_group_id
1296: FROM cs_incidents_all_b csi
1297: WHERE incident_id = p_incident_id;
1298:
1299: CURSOR l_addr_id_csr (b_incident_id IN NUMBER)
1300: IS

Line 1417: l_install_site_id cs_incidents_all_b.install_site_id%TYPE;

1413: --12.1
1414: Procedure SR_Post_Upd( x_return_status OUT NOCOPY VARCHAR2)
1415: IS
1416: l_incident_id cs_incidents_all.incident_id%TYPE;
1417: l_install_site_id cs_incidents_all_b.install_site_id%TYPE;
1418: l_is_install_site_updated char(1);
1419: l_sr_customer_id cs_incidents_all_b.customer_id%TYPE;
1420: l_is_sr_customer_updated char(1);
1421: l_inventory_item_id cs_incidents_all_b.inventory_item_id%TYPE;

Line 1419: l_sr_customer_id cs_incidents_all_b.customer_id%TYPE;

1415: IS
1416: l_incident_id cs_incidents_all.incident_id%TYPE;
1417: l_install_site_id cs_incidents_all_b.install_site_id%TYPE;
1418: l_is_install_site_updated char(1);
1419: l_sr_customer_id cs_incidents_all_b.customer_id%TYPE;
1420: l_is_sr_customer_updated char(1);
1421: l_inventory_item_id cs_incidents_all_b.inventory_item_id%TYPE;
1422: l_is_inventory_item_updated char(1);
1423: l_instance_id cs_incidents_all_b.customer_product_id%TYPE;

Line 1421: l_inventory_item_id cs_incidents_all_b.inventory_item_id%TYPE;

1417: l_install_site_id cs_incidents_all_b.install_site_id%TYPE;
1418: l_is_install_site_updated char(1);
1419: l_sr_customer_id cs_incidents_all_b.customer_id%TYPE;
1420: l_is_sr_customer_updated char(1);
1421: l_inventory_item_id cs_incidents_all_b.inventory_item_id%TYPE;
1422: l_is_inventory_item_updated char(1);
1423: l_instance_id cs_incidents_all_b.customer_product_id%TYPE;
1424: l_is_sr_instance_updated char(1);
1425: l_rec_count number;

Line 1423: l_instance_id cs_incidents_all_b.customer_product_id%TYPE;

1419: l_sr_customer_id cs_incidents_all_b.customer_id%TYPE;
1420: l_is_sr_customer_updated char(1);
1421: l_inventory_item_id cs_incidents_all_b.inventory_item_id%TYPE;
1422: l_is_inventory_item_updated char(1);
1423: l_instance_id cs_incidents_all_b.customer_product_id%TYPE;
1424: l_is_sr_instance_updated char(1);
1425: l_rec_count number;
1426: l_is_sr_contact_ins char(1);
1427: l_is_sr_contact_upd char(1);

Line 1435: l_incident_location_id cs_incidents_all_b.incident_location_id%TYPE;

1431: l_sqlerrno VARCHAR2(20);
1432: l_sqlerrmsg VARCHAR2(4000);
1433: l_error_msg VARCHAR2(4000);
1434: l_return_status VARCHAR2(2000);
1435: l_incident_location_id cs_incidents_all_b.incident_location_id%TYPE;
1436: l_is_incident_location_updated char(1);
1437: l_location_id JTF_TASKS_B.LOCATION_ID%TYPE;
1438: l_is_owner_changed char(1);
1439: l_old_owner NUMBER;

Line 1454: FROM cs_incidents_all_b

1450: contract_service_id,
1451: incident_location_id,
1452: owner_group_id,
1453: created_by
1454: FROM cs_incidents_all_b
1455: WHERE incident_id = p_incident_id;
1456:
1457: l_sr_post_upd_rec l_sr_post_upd_csr%ROWTYPE;
1458:

Line 1496: cs_incidents_all_b csa

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
1500: au.USER_ID=csa.created_by