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_PATCH_ANALYSIS_ENGINE dependencies on AD_TRACKABLE_ENTITIES

Line 119: FROM ad_trackable_entities)

115: abbreviation abbr,
116: NVL(used_flag, 'Y') used_flag,
117: NVL(load_flag, 'N') load_flag,
118: codelevel te_level
119: FROM ad_trackable_entities)
120: LOOP
121: ghashLevel(rec.abbr) := rec.te_level;
122: ghashIfUsed(rec.abbr) := rec.used_flag;
123: ghashIfLoad(rec.abbr) := rec.load_flag;

Line 581: FROM ad_trackable_entities

577: BEGIN
578:
579: SELECT baseline
580: INTO l_te_baseline
581: FROM ad_trackable_entities
582: WHERE abbreviation = l_te_abbr;
583:
584: -- if the patch is not generic and doesn't match with the baseline
585: -- on customer instance then error out

Line 610: ad_trackable_entities ate

606: nvl(appei.baseline,0) intr_baseline,
607: nvl(ate.codelevel,0) curr_level,
608: nvl(appei.te_level,0) intr_level
609: FROM ad_pa_patch_entity_info appei,
610: ad_trackable_entities ate
611: WHERE appei.te_abbr = ate.abbreviation(+)
612: AND appei.patch_id = l_patch_id)
613: LOOP
614: debugPrint (rec.te_abbr ||' BASELINE (current,intr) ('|| rec.curr_baseline||', '||rec.intr_baseline