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.CS_SR_DELETE_UTIL dependencies on JTF_OBJECT_PURGE_PARAM_TMP

Line 1430: jtf_object_purge_param_tmp

1426: object_id
1427: BULK COLLECT INTO
1428: l_incident_id_tbl
1429: FROM
1430: jtf_object_purge_param_tmp
1431: WHERE
1432: object_type = 'SR'
1433: AND p_processing_set_id = processing_set_id
1434: AND NVL(purge_status, 'S') = 'S';

Line 1562: , jtf_object_purge_param_tmp j

1558: , l_inc_creation_date_tbl
1559: , l_inc_last_update_date_tbl
1560: FROM
1561: cs_incidents_all_b c
1562: , jtf_object_purge_param_tmp j
1563: WHERE
1564: j.object_type = 'SR'
1565: AND j.object_id = c.incident_id
1566: AND NVL

Line 1614: , jtf_object_purge_param_tmp j

1610: , l_source_lang_tbl
1611: , l_summary_tbl
1612: FROM
1613: cs_incidents_all_tl c
1614: , jtf_object_purge_param_tmp j
1615: WHERE
1616: j.object_type = 'SR'
1617: AND j.object_id = c.incident_id
1618: AND NVL

Line 1682: jtf_object_purge_param_tmp j

1678: BULK COLLECT INTO
1679: l_incident_id_status_tbl
1680: , l_purge_error_message_tbl
1681: FROM
1682: jtf_object_purge_param_tmp j
1683: WHERE
1684: j.object_type = 'SR'
1685: AND NVL
1686: (

Line 1732: SELECT /+ cardinality(jtf_object_purge_param_tmp, 10) /

1728: DELETE /*+ index(t) */ cs_incidents_all_tl t
1729: WHERE
1730: incident_id IN
1731: (
1732: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
1733: object_id
1734: FROM
1735: jtf_object_purge_param_tmp
1736: WHERE

Line 1735: jtf_object_purge_param_tmp

1731: (
1732: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
1733: object_id
1734: FROM
1735: jtf_object_purge_param_tmp
1736: WHERE
1737: object_type = 'SR'
1738: AND p_processing_set_id = processing_set_id
1739: AND NVL

Line 1786: SELECT /+ cardinality(jtf_object_purge_param_tmp, 10) /

1782: DELETE /*+ index(b) */ cs_incidents_all_b b
1783: WHERE
1784: incident_id IN
1785: (
1786: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
1787: object_id
1788: FROM
1789: jtf_object_purge_param_tmp
1790: WHERE

Line 1789: jtf_object_purge_param_tmp

1785: (
1786: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
1787: object_id
1788: FROM
1789: jtf_object_purge_param_tmp
1790: WHERE
1791: object_type = 'SR'
1792: AND p_processing_set_id = processing_set_id
1793: AND NVL

Line 1912: jtf_object_purge_param_tmp j

1908: (
1909: SELECT
1910: object_id
1911: FROM
1912: jtf_object_purge_param_tmp j
1913: WHERE
1914: j.object_type = 'SR'
1915: AND NVL
1916: (

Line 2230: jtf_object_purge_param_tmp

2226: (
2227: SELECT /*+ unnest no_semijoin cardinality(10) */
2228: object_id
2229: FROM
2230: jtf_object_purge_param_tmp
2231: WHERE
2232: object_type = 'SR'
2233: AND p_processing_set_id = processing_set_id
2234: AND NVL

Line 2276: jtf_object_purge_param_tmp

2272: (
2273: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2274: object_id
2275: FROM
2276: jtf_object_purge_param_tmp
2277: WHERE
2278: object_type = 'SR'
2279: AND p_processing_set_id = processing_set_id
2280: AND NVL(purge_status, 'S') = 'S'

Line 2318: jtf_object_purge_param_tmp

2314: (
2315: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2316: object_id
2317: FROM
2318: jtf_object_purge_param_tmp
2319: WHERE
2320: object_type = 'SR'
2321: AND p_processing_set_id = processing_set_id
2322: AND NVL(purge_status, 'S') = 'S'

Line 2360: jtf_object_purge_param_tmp

2356: (
2357: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2358: object_id
2359: FROM
2360: jtf_object_purge_param_tmp
2361: WHERE
2362: object_type = 'SR'
2363: AND p_processing_set_id = processing_set_id
2364: AND NVL(purge_status, 'S') = 'S'

Line 2399: SELECT /+ cardinality(jtf_object_purge_param_tmp, 10) /

2395:
2396: DELETE /*+ index(c) */ cs_hz_sr_contact_points c
2397: WHERE incident_id IN
2398: (
2399: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
2400: object_id
2401: FROM
2402: jtf_object_purge_param_tmp
2403: WHERE

Line 2402: jtf_object_purge_param_tmp

2398: (
2399: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
2400: object_id
2401: FROM
2402: jtf_object_purge_param_tmp
2403: WHERE
2404: object_type = 'SR'
2405: AND p_processing_set_id = processing_set_id
2406: AND NVL(purge_status, 'S') = 'S'

Line 2614: SELECT /+ cardinality(JTF_OBJECT_PURGE_PARAM_TMP, 10) /

2610:
2611: DELETE /*+ index(t) */ cs_incidents_audit_tl t
2612: WHERE incident_id IN
2613: (
2614: SELECT /*+ cardinality(JTF_OBJECT_PURGE_PARAM_TMP, 10) */
2615: object_id
2616: FROM
2617: jtf_object_purge_param_tmp
2618: WHERE

Line 2617: jtf_object_purge_param_tmp

2613: (
2614: SELECT /*+ cardinality(JTF_OBJECT_PURGE_PARAM_TMP, 10) */
2615: object_id
2616: FROM
2617: jtf_object_purge_param_tmp
2618: WHERE
2619: object_type = 'SR'
2620: AND p_processing_set_id = processing_set_id
2621: AND NVL(purge_status, 'S') = 'S'

Line 2658: jtf_object_purge_param_tmp

2654: (
2655: SELECT /*+ unnest no_semijoin cardinality(10) */
2656: object_id
2657: FROM
2658: jtf_object_purge_param_tmp
2659: WHERE
2660: object_type = 'SR'
2661: AND p_processing_set_id = processing_set_id
2662: AND NVL(purge_status, 'S') = 'S'

Line 2871: SELECT /+ cardinality(jtf_object_purge_param_tmp, 10) /

2867:
2868: DELETE /*+ index(t) */ cug_incidnt_attr_vals_tl t
2869: WHERE incidnt_attr_val_id IN
2870: (
2871: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
2872: c.incidnt_attr_val_id
2873: FROM
2874: jtf_object_purge_param_tmp j
2875: , cug_incidnt_attr_vals_b c

Line 2874: jtf_object_purge_param_tmp j

2870: (
2871: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */
2872: c.incidnt_attr_val_id
2873: FROM
2874: jtf_object_purge_param_tmp j
2875: , cug_incidnt_attr_vals_b c
2876: WHERE
2877: j.object_type = 'SR'
2878: AND p_processing_set_id = j.processing_set_id

Line 2917: jtf_object_purge_param_tmp

2913: (
2914: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2915: object_id
2916: FROM
2917: jtf_object_purge_param_tmp
2918: WHERE
2919: object_type = 'SR'
2920: AND p_processing_set_id = processing_set_id
2921: AND NVL(purge_status, 'S') = 'S'

Line 2959: jtf_object_purge_param_tmp j

2955: (
2956: SELECT /*+ unnest no_semijoin leading(j) use_nl(c) cardinality(10) */
2957: audit_extension_id
2958: FROM
2959: jtf_object_purge_param_tmp j
2960: , cs_incidents_ext_audit c
2961: WHERE
2962: j.object_type = 'SR'
2963: AND p_processing_set_id = j.processing_set_id

Line 3003: jtf_object_purge_param_tmp

2999: (
3000: SELECT /*+ no_unnest no_semijoin cardinality(10) */
3001: object_id
3002: FROM
3003: jtf_object_purge_param_tmp
3004: WHERE
3005: object_type = 'SR'
3006: AND p_processing_set_id = processing_set_id
3007: AND NVL(purge_status, 'S') = 'S'

Line 3045: jtf_object_purge_param_tmp

3041: (
3042: SELECT /*+ no_unnest no_semijoin cardinality(10) */
3043: object_id
3044: FROM
3045: jtf_object_purge_param_tmp
3046: WHERE
3047: object_type = 'SR'
3048: AND p_processing_set_id = processing_set_id
3049: AND NVL(purge_status, 'S') = 'S'