[Home] [Help]
585: 'afv.version_segment5 desc, afv.version_segment6 desc, '||
586: 'afv.version_segment7 desc, afv.version_segment8 desc, '||
587: 'afv.version_segment9 desc, afv.version_segment10 desc, '||
588: 'afv.translation_level desc nulls last) as r '||
589: 'from ad_snapshot_files sf, ad_file_versions afv ';
590:
591: if p_limit_to_candidate_files then
592: l_str2 :=
593: ', ad_patch_hist_snaps_temp t ' ||
1474: max(afv.translation_level), max(prba.dest_file_id),
1475: max(prba.file_type_flag)
1476: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,
1477: ad_patch_run_bugs prb, ad_patch_run_bug_actions prba,
1478: ad_patch_common_actions pca, ad_file_versions afv, ad_files f
1479: where pr.patch_run_id = t.patch_run_id
1480: and pr.appl_top_id = :at_id
1481: and t.action_code = :pr_id_act_cd
1482: and pr.patch_run_id = prb.patch_run_id
1548: afv.version_segment9 desc, afv.version_segment10 desc,
1549: afv.translation_level desc nulls last) as r1
1550: from ad_patch_hist_snaps_temp t, ad_patch_runs pr,
1551: ad_patch_run_bugs prb, ad_patch_run_bug_actions prba,
1552: ad_patch_common_actions pca, ad_file_versions afv, ad_files f
1553: where pr.patch_run_id = t.patch_run_id
1554: and pr.appl_top_id = :at_id
1555: and t.action_code = :pr_id_act_cd
1556: and pr.patch_run_id = prb.patch_run_id
1600:
1601: l_from_where :=
1602: 'from ad_patch_hist_snaps_temp t, ad_patch_runs pr, '||
1603: 'ad_patch_run_bugs prb, ad_patch_run_bug_actions prba, '||
1604: 'ad_patch_common_actions pca, ad_file_versions afv, ad_files f '||
1605: 'where pr.patch_run_id = t.patch_run_id '||
1606: 'and pr.appl_top_id = :at_id '||
1607: 'and t.action_code = :pr_id_act_cd '||
1608: 'and pr.patch_run_id = prb.patch_run_id '||
1978: L_ARCH_CLIB_ACT_CD, L_ARCH_AZIP_ACT_CD))
1979: and exists
1980: (
1981: select 'File exists in curr-vw with lower version'
1982: from ad_patch_hist_snaps_temp t, ad_file_versions fv_old
1983: where sf.file_id = t.file_id
1984: and t.file_version_id = fv_old.file_version_id (+)
1985: and sf.file_version_id = fv_old.file_version_id (+)
1986: -- Update only if patch version is higher (code copied from adfilutb.pls)