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 CS_INCIDENTS_ALL_TL

Line 1599: -- Collect all the information from the cs_incidents_all_tl

1595: || 'CS_INCIDENTS_PURGE_AUDIT_TL table'
1596: );
1597: END IF ;
1598:
1599: -- Collect all the information from the cs_incidents_all_tl
1600: -- table that needs to be entered in the purge audit table
1601:
1602: SELECT
1603: incident_id

Line 1613: cs_incidents_all_tl c

1609: , l_language_tbl
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

Line 1720: , 'Deleting rows from table CS_INCIDENTS_ALL_TL'

1716: fnd_log.string
1717: (
1718: fnd_log.level_statement
1719: , L_LOG_MODULE || 'del_srtl_start'
1720: , 'Deleting rows from table CS_INCIDENTS_ALL_TL'
1721: );
1722: END IF ;
1723:
1724: -- Delete all the translatable attributes of the

Line 1728: DELETE /+ index(t) / cs_incidents_all_tl t

1724: -- Delete all the translatable attributes of the
1725: -- service request from the table
1726: -- Bug 10090362: Changed the hint in the sub query
1727:
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) */

Line 1754: , 'After deleting rows from table CS_INCIDENTS_ALL_TL ' || l_row_count