[Home] [Help]
828: FROM jtf_rs_resource_extns res,
829: jtf_task_assignments a,
830: jtf_tasks_b ct,
831: jtf_tasks_tl ctl,
832: cs_incidents_all_b cia,
833: hz_parties hzp,
834: jtf_task_statuses_b jts,
835: jtf_task_statuses_tl jtstl
836: WHERE res.user_id IN '|| l_user_lst || '
870: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_end_date), '''|| g_date_format_mask ||''') scheduled_end_date
871: FROM jtf_task_assignments a,
872: jtf_tasks_b ct,
873: jtf_tasks_tl ctl,
874: cs_incidents_all_b cia,
875: hz_parties hzp,
876: jtf_task_statuses_b jts,
877: jtf_task_statuses_tl jtstl,
878: jtf_rs_groups_tl gtl
1449: jtf_task_types_b ttb,
1450: jtf_task_types_tl tttl,
1451: jtf_task_statuses_b ts,
1452: jtf_task_statuses_tl tstl,
1453: cs_incidents_all_b csb,
1454: cs_incidents_all_tl cstl,
1455: hz_parties hzp,
1456: hz_party_sites hzps,
1457: hz_locations hzloc
1487:
1488: CURSOR c_system_items(p_incident_id NUMBER)
1489: IS
1490: SELECT item.segment1 AS item
1491: FROM cs_incidents_all_b csb,
1492: mtl_system_items_b item
1493: WHERE csb.incident_id = p_incident_id
1494: AND item.inventory_item_id(+) = csb.inventory_item_id
1495: AND item.organization_id = csb.org_id;
1496:
1497: CURSOR c_item_instance(p_incident_id NUMBER)
1498: IS
1499: SELECT inst.serial_number
1500: FROM cs_incidents_all_b csb,
1501: csi_item_instances inst
1502: WHERE csb.incident_id = p_incident_id
1503: AND inst.instance_id(+) = csb.customer_product_id
1504: AND inst.inv_master_organization_id = csb.org_id
1625: AS
1626: CURSOR c_incidents(p_incident_number VARCHAR2, p_resource_id NUMBER)
1627: IS
1628: SELECT sr.incident_id, tsk.TASK_NUMBER
1629: FROM cs_incidents_all_b sr,
1630: jtf_tasks_b tsk
1631: WHERE sr.incident_number = p_incident_number
1632: AND tsk.source_object_id = sr.incident_id
1633: AND tsk.source_object_type_code = 'SR';
1642: hzp.party_name customer,
1643: csb.problem_code,
1644: csb.resolution_code,
1645: ADJUST_TIME(csb.incident_date) reported_date
1646: FROM cs_incidents_all_b csb,
1647: cs_incidents_all_tl cstl,
1648: cs_incident_types it,
1649: cs_incident_types_tl ittl,
1650: cs_incident_severities isev,
1668:
1669: CURSOR c_system_items(p_incident_id NUMBER)
1670: IS
1671: SELECT item.segment1 AS item
1672: FROM cs_incidents_all_b csb,
1673: mtl_system_items_b item
1674: WHERE csb.incident_id = p_incident_id
1675: AND item.inventory_item_id(+) = csb.inventory_item_id
1676: AND item.organization_id = csb.org_id;
1678: CURSOR c_item_instance(p_incident_id NUMBER)
1679: IS
1680: SELECT inst.instance_number AS instance,
1681: inst.serial_number
1682: FROM cs_incidents_all_b csb,
1683: csi_item_instances inst
1684: WHERE csb.incident_id = p_incident_id
1685: AND inst.instance_id(+) = csb.customer_product_id
1686: AND inst.inv_master_organization_id = csb.org_id
1707: SELECT nttl.notes note_text,
1708: lkp.meaning note_status,
1709: rs.source_name entered_by,
1710: ADJUST_TIME(ntb.entered_date) entered_date
1711: FROM cs_incidents_all_b cs,
1712: jtf_notes_b ntb,
1713: jtf_notes_tl nttl,
1714: jtf_rs_resource_extns rs,
1715: fnd_lookup_values lkp
1849: IS
1850: SELECT csi.instance_id,
1851: cs.contract_service_id
1852: FROM csi_item_instances csi,
1853: cs_incidents_all_b cs,
1854: jtf_tasks_b tsk,
1855: jtf_task_assignments ass
1856: WHERE csi.serial_number = p_serial_number
1857: AND csi.instance_id = cs.customer_product_id
1864: IS
1865: SELECT csi.instance_id,
1866: cs.contract_service_id
1867: FROM csi_item_instances csi,
1868: cs_incidents_all_b cs,
1869: jtf_tasks_b tsk,
1870: jtf_task_assignments ass
1871: WHERE csi.serial_number = p_serial_number
1872: AND csi.instance_id = cs.customer_product_id
1890: IS
1891: SELECT csi.instance_id,
1892: cs.contract_service_id
1893: FROM csi_item_instances csi,
1894: cs_incidents_all_b cs,
1895: jtf_tasks_b tsk,
1896: JTF_TASK_ASSIGNMENTS ASS,
1897: JTF_RS_GROUP_MEMBERS jtm
1898: WHERE csi.serial_number = p_serial_number