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_PATCH_COMMON_ACTIONS

Line 1478: ad_patch_common_actions pca, ad_file_versions afv, ad_files f

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

Line 1552: ad_patch_common_actions pca, ad_file_versions afv, ad_files f

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

Line 1578: ad_patch_common_actions pca

1574: and not exists (select
1575: 'libin action exists for this .o (ie. its archived)'
1576: from ad_patch_run_bug_actions prba,
1577: ad_patch_run_bugs prb,
1578: ad_patch_common_actions pca
1579: where prba.file_id = t.file_id
1580: and prba.patch_run_bug_id = prb.patch_run_bug_id
1581: and prb.patch_run_id = t.patch_run_id
1582: and pca.common_action_id = prba.common_action_id

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

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

Line 1755: ad_patch_common_actions pca

1751: and not exists (select
1752: 'libin action exists for this .o (ie. its archived)'
1753: from ad_patch_run_bug_actions prba,
1754: ad_patch_run_bugs prb,
1755: ad_patch_common_actions pca
1756: where prba.file_id = t.file_id
1757: and prba.patch_run_bug_id = prb.patch_run_bug_id
1758: and prb.patch_run_id = t.patch_run_id
1759: and pca.common_action_id = prba.common_action_id

Line 2049: index(pca ad_patch_common_actions_n1) */

2045: - Issue a bulk-bind DELETE using the collection type
2046: */
2047:
2048: select /*+ ordered use_nl(prba, prb, pr, t)
2049: index(pca ad_patch_common_actions_n1) */
2050: distinct prba.file_id
2051: bulk collect into l_deleted_ru_file_ids
2052: from ad_patch_common_actions pca,
2053: ad_patch_run_bug_actions prba,

Line 2052: from ad_patch_common_actions pca,

2048: select /*+ ordered use_nl(prba, prb, pr, t)
2049: index(pca ad_patch_common_actions_n1) */
2050: distinct prba.file_id
2051: bulk collect into l_deleted_ru_file_ids
2052: from ad_patch_common_actions pca,
2053: ad_patch_run_bug_actions prba,
2054: ad_patch_run_bugs prb,
2055: ad_patch_runs pr,
2056: ad_patch_hist_snaps_temp t