DBA Data[Home] [Help]

APPS.AD_FILE_SYS_SNAPSHOTS_PKG dependencies on AD_PATCH_COMMON_ACTIONS

Line 1401: ad_patch_common_actions pca, ad_file_versions afv, ad_files f

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

Line 1475: ad_patch_common_actions pca, ad_file_versions afv, ad_files f

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

Line 1501: ad_patch_common_actions pca

1497: and not exists (select
1498: 'libin action exists for this .o (ie. its archived)'
1499: from ad_patch_run_bug_actions prba,
1500: ad_patch_run_bugs prb,
1501: ad_patch_common_actions pca
1502: where prba.file_id = t.file_id
1503: and prba.patch_run_bug_id = prb.patch_run_bug_id
1504: and prb.patch_run_id = t.patch_run_id
1505: and pca.common_action_id = prba.common_action_id

Line 1527: 'ad_patch_common_actions pca, ad_file_versions afv, ad_files f '||

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 '||

Line 1678: ad_patch_common_actions pca

1674: and not exists (select
1675: 'libin action exists for this .o (ie. its archived)'
1676: from ad_patch_run_bug_actions prba,
1677: ad_patch_run_bugs prb,
1678: ad_patch_common_actions pca
1679: where prba.file_id = t.file_id
1680: and prba.patch_run_bug_id = prb.patch_run_bug_id
1681: and prb.patch_run_id = t.patch_run_id
1682: and pca.common_action_id = prba.common_action_id

Line 1972: index(pca ad_patch_common_actions_n1) */

1968: - Issue a bulk-bind DELETE using the collection type
1969: */
1970:
1971: select /*+ ordered use_nl(prba, prb, pr, t)
1972: index(pca ad_patch_common_actions_n1) */
1973: distinct prba.file_id
1974: bulk collect into l_deleted_ru_file_ids
1975: from ad_patch_common_actions pca,
1976: ad_patch_run_bug_actions prba,

Line 1975: from ad_patch_common_actions pca,

1971: select /*+ ordered use_nl(prba, prb, pr, t)
1972: index(pca ad_patch_common_actions_n1) */
1973: distinct prba.file_id
1974: bulk collect into l_deleted_ru_file_ids
1975: from ad_patch_common_actions pca,
1976: ad_patch_run_bug_actions prba,
1977: ad_patch_run_bugs prb,
1978: ad_patch_runs pr,
1979: ad_patch_hist_snaps_temp t