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 1734: jtf_object_purge_param_tmp

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

Line 1787: jtf_object_purge_param_tmp

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

Line 1910: jtf_object_purge_param_tmp j

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

Line 2228: jtf_object_purge_param_tmp

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

Line 2274: jtf_object_purge_param_tmp

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

Line 2316: jtf_object_purge_param_tmp

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

Line 2358: jtf_object_purge_param_tmp

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

Line 2399: jtf_object_purge_param_tmp

2395: (
2396: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2397: object_id
2398: FROM
2399: jtf_object_purge_param_tmp
2400: WHERE
2401: object_type = 'SR'
2402: AND p_processing_set_id = processing_set_id
2403: AND NVL(purge_status, 'S') = 'S'

Line 2613: jtf_object_purge_param_tmp

2609: (
2610: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2611: object_id
2612: FROM
2613: jtf_object_purge_param_tmp
2614: WHERE
2615: object_type = 'SR'
2616: AND p_processing_set_id = processing_set_id
2617: AND NVL(purge_status, 'S') = 'S'

Line 2654: jtf_object_purge_param_tmp

2650: (
2651: SELECT /*+ unnest no_semijoin cardinality(10) */
2652: object_id
2653: FROM
2654: jtf_object_purge_param_tmp
2655: WHERE
2656: object_type = 'SR'
2657: AND p_processing_set_id = processing_set_id
2658: AND NVL(purge_status, 'S') = 'S'

Line 2870: jtf_object_purge_param_tmp j

2866: (
2867: SELECT /*+ no_unnest no_semijoin leading(j) use_concat cardinality(10) */
2868: c.incidnt_attr_val_id
2869: FROM
2870: jtf_object_purge_param_tmp j
2871: , cug_incidnt_attr_vals_b c
2872: WHERE
2873: j.object_type = 'SR'
2874: AND p_processing_set_id = j.processing_set_id

Line 2913: jtf_object_purge_param_tmp

2909: (
2910: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2911: object_id
2912: FROM
2913: jtf_object_purge_param_tmp
2914: WHERE
2915: object_type = 'SR'
2916: AND p_processing_set_id = processing_set_id
2917: AND NVL(purge_status, 'S') = 'S'

Line 2955: jtf_object_purge_param_tmp j

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

Line 2999: jtf_object_purge_param_tmp

2995: (
2996: SELECT /*+ no_unnest no_semijoin cardinality(10) */
2997: object_id
2998: FROM
2999: jtf_object_purge_param_tmp
3000: WHERE
3001: object_type = 'SR'
3002: AND p_processing_set_id = processing_set_id
3003: AND NVL(purge_status, 'S') = 'S'

Line 3041: jtf_object_purge_param_tmp

3037: (
3038: SELECT /*+ no_unnest no_semijoin cardinality(10) */
3039: object_id
3040: FROM
3041: jtf_object_purge_param_tmp
3042: WHERE
3043: object_type = 'SR'
3044: AND p_processing_set_id = processing_set_id
3045: AND NVL(purge_status, 'S') = 'S'