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.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on AD_SNAPSHOT_FILES_S

Line 544: 'from ad_snapshot_files sf, ad_file_versions afv ';

540: 'afv.version_segment5 desc, afv.version_segment6 desc, '||
541: 'afv.version_segment7 desc, afv.version_segment8 desc, '||
542: 'afv.version_segment9 desc, afv.version_segment10 desc, '||
543: 'afv.translation_level desc nulls last) as r '||
544: 'from ad_snapshot_files sf, ad_file_versions afv ';
545:
546: if p_limit_to_candidate_files then
547: l_str2 :=
548: ', ad_patch_hist_snaps_temp t ' ||

Line 734: ad_snapshot_files_s.nextval,

730: server_type_node_flag, server_type_web_flag,
731: dest_file_id, file_type_flag
732: )
733: select
734: ad_snapshot_files_s.nextval,
735: l_global_snapshot_id, file_id, containing_file_id,
736: file_version_id,
737: update_source_id, update_type,
738: sysdate, sysdate, 5, 5,

Line 743: from ad_snapshot_files sf

739: p_cur_appl_top_id, 'N',
740: server_type_admin_flag, server_type_forms_flag,
741: server_type_node_flag, server_type_web_flag,
742: dest_file_id, file_type_flag
743: from ad_snapshot_files sf
744: where snapshot_id = l_preseeded_snapshot_id
745: and not exists (select /*+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) */
746: 'Already exists'
747: from ad_snapshot_files sf2

Line 747: from ad_snapshot_files sf2

743: from ad_snapshot_files sf
744: where snapshot_id = l_preseeded_snapshot_id
745: and not exists (select /*+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) */
746: 'Already exists'
747: from ad_snapshot_files sf2
748: where sf2.snapshot_id = l_global_snapshot_id
749: and sf2.file_id = sf.file_id
750: and nvl(sf2.containing_file_id, -1) =
751: nvl(sf.containing_file_id, -1));

Line 878: ad_snapshot_files_s.nextval, l_global_snapshot_id,

874: update_source_id, update_type,
875: creation_date, last_update_date, created_by, last_updated_by
876: )
877: select
878: ad_snapshot_files_s.nextval, l_global_snapshot_id,
879: t.file_id, t.containing_file_id, t.file_version_id,
880: t.dest_file_id, t.file_type_flag,
881: decode(l_count_appltops, 1, p_cur_appl_top_id, null),
882: decode(l_count_appltops, 1, 'N', null),

Line 898: from ad_snapshot_files sf2

894: from
895: ad_snapshot_files_temp
896: group by file_id) t
897: where not exists (select 'Already exists'
898: from ad_snapshot_files sf2
899: where sf2.snapshot_id = l_global_snapshot_id
900: and sf2.file_id = t.file_id
901: and nvl(sf2.containing_file_id, -1) =
902: nvl(t.containing_file_id, -1)

Line 1766: ad_snapshot_files_s.nextval,

1762: irep_gathered_flag,
1763: last_patched_date
1764: )
1765: select
1766: ad_snapshot_files_s.nextval,
1767: l_snapshot_id,
1768: t.file_id,
1769: decode(t.action_code, L_ARCH_CLIB_ACT_CD, t.clib_arch_file_id,
1770: L_ARCH_AZIP_ACT_CD, l_apps_zip_f_id,

Line 1785: from ad_snapshot_files sf

1781: from ad_patch_hist_snaps_temp t
1782: where t.action_code in (L_ARCH_NONE_ACT_CD, L_ARCH_CLIB_ACT_CD,
1783: L_ARCH_AZIP_ACT_CD)
1784: and not exists (select 'Already exists'
1785: from ad_snapshot_files sf
1786: where sf.snapshot_id = l_snapshot_id
1787: and sf.file_id = t.file_id
1788: and ((sf.containing_file_id is null and
1789: t.action_code = L_ARCH_NONE_ACT_CD)

Line 1830: ad_snapshot_files_s.nextval,

1826: creation_date, last_update_date, last_updated_by,
1827: created_by, appl_top_id, inconsistent_flag
1828: )
1829: select
1830: ad_snapshot_files_s.nextval,
1831: l_global_snapshot_id, -- Global Snapshot ID here
1832: t.file_id,
1833: decode(t.action_code, L_ARCH_CLIB_ACT_CD, t.clib_arch_file_id,
1834: L_ARCH_AZIP_ACT_CD, l_apps_zip_f_id,

Line 1849: from ad_snapshot_files sf

1845: where
1846: t.action_code in (L_ARCH_NONE_ACT_CD, L_ARCH_CLIB_ACT_CD,
1847: L_ARCH_AZIP_ACT_CD)
1848: and not exists (select 'Already exists'
1849: from ad_snapshot_files sf
1850: where sf.snapshot_id = l_global_snapshot_id
1851: and sf.file_id = t.file_id
1852: and ((sf.containing_file_id is null and
1853: t.action_code = L_ARCH_NONE_ACT_CD)

Line 1885: update ad_snapshot_files sf

1881:
1882: -- update existing files if higher version, or if dest_file_id
1883: -- or file_type_flag is different (Current View)
1884:
1885: update ad_snapshot_files sf
1886: set
1887: (sf.file_version_id, sf.update_source_id,
1888: sf.dest_file_id, sf.file_type_flag, sf.irep_gathered_flag) =
1889: (select t.file_version_id, t.patch_run_id,

Line 2050: ad_snapshot_files sf

2046:
2047: if file_id_list.count > 0 then
2048: forall j in file_id_list.first.. file_id_list.last
2049: update /*+ INDEX(SF AD_SNAPSHOT_FILES_U2) */
2050: ad_snapshot_files sf
2051: set sf.last_update_date = sysdate,
2052: sf.last_updated_by = 5,
2053: sf.file_version_id = file_version_id_list(j),
2054: sf.update_source_id = -1,

Line 2094: delete from ad_snapshot_files sf

2090:
2091: if nvl(l_deleted_ru_file_ids.last, 0) > 0 then
2092:
2093: forall i in l_deleted_ru_file_ids.first..l_deleted_ru_file_ids.last
2094: delete from ad_snapshot_files sf
2095: where sf.snapshot_id = l_global_snapshot_id and
2096: sf.file_id = l_deleted_ru_file_ids(i)
2097: and not exists
2098: (

Line 2100: from ad_snapshot_files sf1

2096: sf.file_id = l_deleted_ru_file_ids(i)
2097: and not exists
2098: (
2099: select 'Exists in the curr vw of some appltop'
2100: from ad_snapshot_files sf1
2101: where sf1.file_id = l_deleted_ru_file_ids(i)
2102: and nvl(sf1.containing_file_id, -1) = nvl(sf.containing_file_id, -1)
2103: and sf1.snapshot_id in (
2104: select s.snapshot_id

Line 2381: ad_snapshot_files_s.nextval,

2377: creation_date, last_update_date, last_updated_by, created_by,
2378: dest_file_id, file_type_flag
2379: )
2380: select
2381: ad_snapshot_files_s.nextval,
2382: l_curr_vw_snapshot_id, file_id, containing_file_id,
2383: file_version_id,
2384: update_source_id, update_type,
2385: sysdate, sysdate, 5, 5,

Line 2387: from ad_snapshot_files sf

2383: file_version_id,
2384: update_source_id, update_type,
2385: sysdate, sysdate, 5, 5,
2386: dest_file_id, file_type_flag
2387: from ad_snapshot_files sf
2388: where sf.snapshot_id = l_preseeded_snapshot_id
2389:
2390: -- Added for bug 3947949
2391: -- and ((sf.server_type_admin_flag = l_server_type_admin_flag

Line 2402: 'Already exists' from ad_snapshot_files sf2

2398: -- and l_server_type_web_flag = 'Y')
2399: -- )
2400:
2401: and not exists (select /*+ INDEX(SF2 AD_SNAPSHOT_FILES_U2) */
2402: 'Already exists' from ad_snapshot_files sf2
2403: where sf2.snapshot_id = l_curr_vw_snapshot_id
2404: and sf2.file_id = sf.file_id
2405: and nvl(sf2.containing_file_id, -1) =
2406: nvl(sf.containing_file_id, -1));