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_EMAIL_QUERY_PKG dependencies on JTF_TASKS_B

Line 224: jtf_tasks_b jtb

220: CURSOR c_task_assignment( p_resource_id NUMBER, p_task_number VARCHAR2)
221: IS
222: SELECT count(*) over () row_count
223: FROM jtf_task_assignments jta,
224: jtf_tasks_b jtb
225: WHERE jtb.task_number = p_task_number
226: AND jtb.task_id = jta.task_id
227: AND jta.resource_id = p_resource_id;
228:

Line 244: jtf_tasks_b jtb

240: AND rb.ROLE_CODE = 'CSF_THIRD_PARTY_ADMINISTRATOR'
241: AND rr.ROLE_RESOURCE_ID = gm.RESOURCE_ID
242: AND gm.GROUP_ID IN (SELECT jta.resource_id
243: FROM jtf_task_assignments jta,
244: jtf_tasks_b jtb
245: WHERE jtb.task_number = p_task_number
246: AND jtb.task_id = jta.task_id
247: AND jta.resource_type_code ='RS_GROUP');
248:

Line 253: JTF_TASKS_B JTB,

249: CURSOR c_tech_task_assignment( p_resource_id NUMBER, p_task_number VARCHAR2)
250: IS
251: SELECT count(*) over () row_count
252: from JTF_TASK_ASSIGNMENTS JTA,
253: JTF_TASKS_B JTB,
254: JTF_RS_GROUP_MEMBERS jtm
255: WHERE jtb.task_number = p_task_number
256: and JTB.TASK_ID = JTA.TASK_ID
257: and JTA.RESOURCE_ID = JTM.RESOURCE_ID

Line 830: jtf_tasks_b ct,

826: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_start_date), '''|| g_date_format_mask ||''') scheduled_start_date,
827: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_end_date), '''|| g_date_format_mask ||''') scheduled_end_date
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,

Line 872: jtf_tasks_b ct,

868: jtstl.name task_status,
869: to_char(CSM_EMAIL_QUERY_PKG.ADJUST_TIME(ct.scheduled_start_date), '''|| g_date_format_mask ||''') scheduled_start_date,
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,

Line 936: jtf_tasks_b jtb

932: jta.last_updated_by,
933: jta.task_assignment_id,
934: jta.assignment_status_id
935: FROM jtf_task_assignments jta,
936: jtf_tasks_b jtb
937: WHERE jtb.task_number = p_task_number
938: AND jtb.task_id = jta.task_id
939: AND jta.resource_id = p_resource_id
940: UNION ALL

Line 948: jtf_tasks_b jtb

944: jta.last_updated_by,
945: jta.task_assignment_id,
946: jta.assignment_status_id
947: FROM jtf_task_assignments jta,
948: jtf_tasks_b jtb
949: WHERE jtb.task_number = p_task_number
950: AND jtb.task_id = jta.task_id
951: AND jta.resource_type_code ='RS_GROUP'
952: AND jta.resource_id IN ( SELECT gm.GROUP_ID from

Line 1288: FROM jtf_tasks_b jtb

1284:
1285: CURSOR c_task( p_task_number VARCHAR2, p_user_id NUMBER)
1286: IS
1287: SELECT jtb.task_id
1288: FROM jtf_tasks_b jtb
1289: WHERE jtb.task_number = p_task_number;
1290:
1291: CURSOR c_note_status(p_meaning VARCHAR2)
1292: IS

Line 1445: FROM jtf_tasks_b tsk,

1441: || hzloc.postal_code || decode(hzloc.postal_code, NULL, '', ',')
1442: || hzloc.country
1443: AS
1444: address
1445: FROM jtf_tasks_b tsk,
1446: jtf_tasks_tl tsktl,
1447: jtf_task_priorities_b tpb,
1448: jtf_task_priorities_tl tptl,
1449: jtf_task_types_b ttb,

Line 1482: FROM jtf_tasks_b tsk,

1478: CURSOR c_task_uom(p_task_id NUMBER)
1479: IS
1480: SELECT tsk.planned_effort,
1481: uom.unit_of_measure
1482: FROM jtf_tasks_b tsk,
1483: mtl_units_of_measure_tl uom
1484: WHERE tsk.task_id = p_task_id
1485: AND uom.uom_code(+) = tsk.planned_effort_uom
1486: AND uom.LANGUAGE = userenv('LANG');

Line 1513: FROM jtf_tasks_b tsk,

1509: SELECT nttl.notes note_text,
1510: lkp.meaning note_status,
1511: rs.source_name entered_by,
1512: ADJUST_TIME(ntb.entered_date) entered_date
1513: FROM jtf_tasks_b tsk,
1514: jtf_notes_b ntb,
1515: jtf_notes_tl nttl,
1516: jtf_rs_resource_extns rs,
1517: fnd_lookup_values lkp

Line 1630: jtf_tasks_b tsk

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';
1634:

Line 1854: jtf_tasks_b tsk,

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
1858: AND tsk.source_object_id = cs.incident_id

Line 1869: jtf_tasks_b tsk,

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
1873: AND tsk.source_object_id = cs.incident_id

Line 1895: jtf_tasks_b tsk,

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
1899: AND csi.instance_id = cs.customer_product_id