[Home] [Help]
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 ' ||
1397: max(afv.translation_level), max(prba.dest_file_id),
1398: max(prba.file_type_flag)
1399: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,
1400: ad_patch_run_bugs prb, ad_patch_run_bug_actions prba,
1401: ad_patch_common_actions pca, ad_file_versions afv, ad_files f
1402: where pr.patch_run_id = t.patch_run_id
1403: and pr.appl_top_id = :at_id
1404: and t.action_code = :pr_id_act_cd
1405: and pr.patch_run_id = prb.patch_run_id
1471: afv.version_segment9 desc, afv.version_segment10 desc,
1472: afv.translation_level desc nulls last) as r1
1473: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,
1474: ad_patch_run_bugs prb, ad_patch_run_bug_actions prba,
1475: ad_patch_common_actions pca, ad_file_versions afv, ad_files f
1476: where pr.patch_run_id = t.patch_run_id
1477: and pr.appl_top_id = :at_id
1478: and t.action_code = :pr_id_act_cd
1479: and pr.patch_run_id = prb.patch_run_id
1523:
1524: l_from_where :=
1525: 'from ad_patch_hist_snaps_temp t, ad_patch_runs pr, '||
1526: 'ad_patch_run_bugs prb, ad_patch_run_bug_actions prba, '||
1527: 'ad_patch_common_actions pca, ad_file_versions afv, ad_files f '||
1528: 'where pr.patch_run_id = t.patch_run_id '||
1529: 'and pr.appl_top_id = :at_id '||
1530: 'and t.action_code = :pr_id_act_cd '||
1531: 'and pr.patch_run_id = prb.patch_run_id '||
1901: L_ARCH_CLIB_ACT_CD, L_ARCH_AZIP_ACT_CD))
1902: and exists
1903: (
1904: select 'File exists in curr-vw with lower version'
1905: from ad_patch_hist_snaps_temp t, ad_file_versions fv_old
1906: where sf.file_id = t.file_id
1907: and t.file_version_id = fv_old.file_version_id (+)
1908: and sf.file_version_id = fv_old.file_version_id (+)
1909: -- Update only if patch version is higher (code copied from adfilutb.pls)