APPS.AD_PATCH_HIST_REPS dependencies on AD_PATCH_DRIVERS

Line 360: from ad_patch_drivers

356: l_count number;
357: begin
358: select patch_driver_id
359: into l_patch_driver_id
360: from ad_patch_drivers
361: where applied_patch_id = p_app_ptch_id
362: and driver_type_d_flag = 'Y';
363: l_level := null;
364: l_count := 0;

Line 689: -- ad_patch_drivers pd, ad_appl_tops at, ad_patch_runs pr

685: -- decode(pd.driver_type_c_flag, ''Y'', ',Generate',
686: -- decode(pd.driver_type_d_flag, 'Y',
687: -- ,Generate', 'Generate')), null) driver_type,
688: -- from ad_applied_patches aap, ad_patch_driver_langs l,
689: -- ad_patch_drivers pd, ad_appl_tops at, ad_patch_runs pr
690: -- where pr.appl_top_id = at.appl_top_id
691: -- and pr.patch_driver_id = pd.patch_driver_id
692: -- and pd.applied_patch_id = aap.applied_patch_id
693: -- and pd.patch_driver_id = l.patch_driver_id

Line 742: 'ad_patch_drivers pd,ad_appl_tops at,ad_patch_runs pr ';

738: ' decode (pr.server_type_web_flag,''Y'',''Web'',null) '||
739: 'servertype';
740:
741: l_from1 := ' FROM ad_applied_patches aap,ad_patch_driver_langs l,'||
742: 'ad_patch_drivers pd,ad_appl_tops at,ad_patch_runs pr ';
743:
744: l_where1 := ' WHERE pr.appl_top_id = at.appl_top_id '||
745: 'and pr.patch_driver_id = pd.patch_driver_id '||
746: 'and pd.applied_patch_id = aap.applied_patch_id '||

Line 811: 'from ad_patch_drivers pd2 '||

807: then
808: --Given the PatchLevel and PatchType is 'PATCH-SET'
809: l_where3 := l_where3||' and aap.applied_patch_id in ('||
810: 'select pd2.applied_patch_id '||
811: 'from ad_patch_drivers pd2 '||
812: 'where pd2.patch_driver_id in ('||
813: 'select mi.patch_driver_id '||
814: 'from ad_patch_driver_minipks mi '||
815: 'where mi.patch_level = '''||p_level||'''';