DBA Data[Home] [Help]

APPS.JTF_TERR_RPT dependencies on ALL_OBJECTS

Line 42: (select owner from sys.all_objects where object_name='JTF_TAE_RPT_STAGING_OUT' and object_type='TABLE')

38: select owner
39: into l_ora_schemaname
40: from all_synonyms
41: where table_owner=
42: (select owner from sys.all_objects where object_name='JTF_TAE_RPT_STAGING_OUT' and object_type='TABLE')
43: and synonym_name='JTF_TAE_RPT_STAGING_OUT';
44:
45: /*delete from APPS.jtf_tae_rpt_staging_out
46: where session_id in (select session_id from l_ora_schemaname ||'.icx_sessions

Line 72: (select owner from sys.all_objects where object_name='JTF_TAE_RPT_STAGING_OUT' and object_type='TABLE')

68: select owner
69: into l_ora_schemaname
70: from all_synonyms
71: where table_owner=
72: (select owner from sys.all_objects where object_name='JTF_TAE_RPT_STAGING_OUT' and object_type='TABLE')
73: and synonym_name='JTF_TAE_RPT_STAGING_OUT';
74:
75: -- delete previous data for the older dead sessions
76: cleanup;

Line 287: (select owner from sys.all_objects where object_name='JTF_TAE_RPT_STAGING_OUT' and object_type='TABLE')

283: select owner
284: into l_ora_schemaname
285: from all_synonyms
286: where table_owner=
287: (select owner from sys.all_objects where object_name='JTF_TAE_RPT_STAGING_OUT' and object_type='TABLE')
288: and synonym_name='JTF_TAE_RPT_STAGING_OUT';
289:
290: /*delete from APPS.jtf_tae_rpt_staging_out
291: where session_id = p_session_id; */