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_UTIL dependencies on AD_PATCH_HIST_TEMP

Line 1739: from ad_patch_hist_temp

1735: -- for deleting duplicate actions
1736: --
1737: cursor del_cursor is
1738: select patch_run_bug_id, common_action_id, file_id, rowid row_id
1739: from ad_patch_hist_temp
1740: where (patch_run_bug_id, common_action_id, file_id) in
1741: (select patch_run_bug_id, common_action_id, file_id
1742: from AD_PATCH_HIST_TEMP
1743: group by patch_run_bug_id, common_action_id, file_id

Line 1742: from AD_PATCH_HIST_TEMP

1738: select patch_run_bug_id, common_action_id, file_id, rowid row_id
1739: from ad_patch_hist_temp
1740: where (patch_run_bug_id, common_action_id, file_id) in
1741: (select patch_run_bug_id, common_action_id, file_id
1742: from AD_PATCH_HIST_TEMP
1743: group by patch_run_bug_id, common_action_id, file_id
1744: having count(*) > 1)
1745: order by 1, 2, 3;
1746: prb_id number;

Line 1757: -- update AD_PATCH_HIST_TEMP.TRACKABLE_ENTITY_ABBR with

1753: begin
1754:
1755: -- bug 6343734 diverma 16 August 2007
1756: --
1757: -- update AD_PATCH_HIST_TEMP.TRACKABLE_ENTITY_ABBR with
1758: -- AD_PATCH_HIST_TEMP.BUG_APP_SHORT_NAME if it is null.
1759: --
1760:
1761: update AD_PATCH_HIST_TEMP

Line 1758: -- AD_PATCH_HIST_TEMP.BUG_APP_SHORT_NAME if it is null.

1754:
1755: -- bug 6343734 diverma 16 August 2007
1756: --
1757: -- update AD_PATCH_HIST_TEMP.TRACKABLE_ENTITY_ABBR with
1758: -- AD_PATCH_HIST_TEMP.BUG_APP_SHORT_NAME if it is null.
1759: --
1760:
1761: update AD_PATCH_HIST_TEMP
1762: set TRACKABLE_ENTITY_NAME = BUG_APP_SHORT_NAME

Line 1761: update AD_PATCH_HIST_TEMP

1757: -- update AD_PATCH_HIST_TEMP.TRACKABLE_ENTITY_ABBR with
1758: -- AD_PATCH_HIST_TEMP.BUG_APP_SHORT_NAME if it is null.
1759: --
1760:
1761: update AD_PATCH_HIST_TEMP
1762: set TRACKABLE_ENTITY_NAME = BUG_APP_SHORT_NAME
1763: where TRACKABLE_ENTITY_NAME is null;
1764:
1765: update AD_PATCH_HIST_TEMP

Line 1765: update AD_PATCH_HIST_TEMP

1761: update AD_PATCH_HIST_TEMP
1762: set TRACKABLE_ENTITY_NAME = BUG_APP_SHORT_NAME
1763: where TRACKABLE_ENTITY_NAME is null;
1764:
1765: update AD_PATCH_HIST_TEMP
1766: set LANGUAGE = 'US'
1767: where LANGUAGE is null;
1768:
1769: --

Line 1792: AD_PATCH_HIST_TEMP where BUG_NUMBER is not null) tmp

1788: -- bug 6332450 diverma Thu Aug 9 06:25:06 PDT 2007
1789: -- bug 5615204 diverma Tuesday, August 07, 2007
1790: TRACKABLE_ENTITY_NAME, BASELINE_NAME, GENERIC_PATCH, LANGUAGE
1791: from
1792: AD_PATCH_HIST_TEMP where BUG_NUMBER is not null) tmp
1793: where
1794: not exists (
1795: select
1796: 'x'

Line 1813: -- Using the generic_patch column present in the ad_patch_hist_temp

1809: -- ----------------------------------------------------------
1810: -- Changed the condition in the subquery .
1811: -- Earlier condition " b.generic_patch=y " was returning multiple
1812: -- rows for a single row return subquery.
1813: -- Using the generic_patch column present in the ad_patch_hist_temp
1814: -- for refining the search condition in subquery
1815: -- and to return a single row
1816: -- -----------------------------------------------------------
1817: --

Line 1820: update AD_PATCH_HIST_TEMP t

1816: -- -----------------------------------------------------------
1817: --
1818: -- Get the Bug_id into the Staging Table
1819: --
1820: update AD_PATCH_HIST_TEMP t
1821: set t.bug_id = (
1822: select
1823: b.bug_id from ad_bugs b
1824: where

Line 1857: AD_PATCH_HIST_TEMP ) t

1853: distinct patch_run_id,bug_id,
1854: orig_bug_number, bug_app_short_name,
1855: success_flag, applied_flag, reason_not_applied
1856: from
1857: AD_PATCH_HIST_TEMP ) t
1858: where
1859: not exists (
1860: select
1861: 'x'

Line 1874: update AD_PATCH_HIST_TEMP t

1870: bugs_processed := l_bugs_processed;
1871: --
1872: -- Get the patch_run_bug_id into staging table
1873: --
1874: update AD_PATCH_HIST_TEMP t
1875: set PATCH_RUN_BUG_ID
1876: =(select
1877: b.PATCH_RUN_BUG_ID
1878: from

Line 1906: AD_PATCH_HIST_TEMP t

1902: t.file_apps_short_name ,
1903: t.file_subdir ,
1904: t.filename
1905: from
1906: AD_PATCH_HIST_TEMP t
1907: ) temp
1908: where not exists (
1909: select
1910: 'x' from ad_files fl

Line 1920: update AD_PATCH_HIST_TEMP t

1916: and temp.filename is not null;
1917: --
1918: -- Get the file_id into the staging table
1919: --
1920: update AD_PATCH_HIST_TEMP t
1921: set t.file_id =
1922: (select f.file_id
1923: from ad_files f
1924: where

Line 1947: AD_PATCH_HIST_TEMP t

1943: t.ldr_app_short_name ,
1944: t.ldr_subdir ,
1945: t.ldr_filename
1946: from
1947: AD_PATCH_HIST_TEMP t
1948: ) temp
1949: where not exists (
1950: select
1951: 'x' from ad_files fl

Line 1961: update AD_PATCH_HIST_TEMP t

1957: and temp.ldr_filename is not null;
1958: --
1959: -- Get the Loader file_id into the staging table
1960: --
1961: update AD_PATCH_HIST_TEMP t
1962: set t.loader_data_file_id =
1963: (select f.file_id
1964: from ad_files f
1965: where

Line 1997: AD_PATCH_HIST_TEMP t

1993: t.dest_apps_short_name ,
1994: t.dest_subdir ,
1995: t.dest_filename
1996: from
1997: AD_PATCH_HIST_TEMP t
1998: where t.dest_apps_short_name is not null
1999: and t.dest_subdir is not null
2000: and t.dest_filename is not null
2001: ) temp

Line 2013: update AD_PATCH_HIST_TEMP t

2009:
2010: --
2011: -- Get the Destination file_id into the staging table
2012: --
2013: update AD_PATCH_HIST_TEMP t
2014: set t.dest_file_id =
2015: (select /*+ INDEX(F AD_FILES_U2) */ f.file_id
2016: from ad_files f
2017: where f.app_short_name = t.dest_apps_short_name

Line 2058: AD_PATCH_HIST_TEMP t

2054: t.PATCH_VERSION_SEGMENT8 vs8,
2055: t.PATCH_VERSION_SEGMENT9 vs9,
2056: t.PATCH_VERSION_SEGMENT10 vs10
2057: from
2058: AD_PATCH_HIST_TEMP t
2059: where
2060: t.PATCH_FILE_VERS is not null
2061: ) temp
2062: where not exists (

Line 2104: AD_PATCH_HIST_TEMP t

2100: t.ONSITE_VERSION_SEGMENT8 vs8,
2101: t.ONSITE_VERSION_SEGMENT9 vs9,
2102: t.ONSITE_VERSION_SEGMENT10 vs10
2103: from
2104: AD_PATCH_HIST_TEMP t
2105: where
2106: t.ONSITE_FILE_VERS is not NULL
2107: ) temp
2108: where not exists (

Line 2151: AD_PATCH_HIST_TEMP t

2147: t.DB_VERSION_SEGMENT8 vs8 ,
2148: t.DB_VERSION_SEGMENT9 vs9 ,
2149: t.DB_VERSION_SEGMENT10 vs10
2150: from
2151: AD_PATCH_HIST_TEMP t
2152: where
2153: t.DB_FILE_VERS is not null
2154: ) tmp
2155: where not exists (

Line 2173: update AD_PATCH_HIST_TEMP t

2169: -- Process the PatchFile Versions
2170: --
2171: -- Get the file_version_id into the staging table
2172: --
2173: update AD_PATCH_HIST_TEMP t
2174: set t.PATCH_FILE_VERS_ID =
2175: (select
2176: fv.file_version_id
2177: from

Line 2193: update AD_PATCH_HIST_TEMP t

2189: --
2190: -- Get the file_version_id into the staging table
2191: --
2192: --
2193: update AD_PATCH_HIST_TEMP t
2194: set t.ONSITE_FILE_VERS_ID =
2195: (select
2196: fv.file_version_id
2197: from

Line 2212: update AD_PATCH_HIST_TEMP t

2208: -- Process the Db FileVersions
2209: --
2210: -- Get the file_version_id into the staging table
2211: --
2212: update AD_PATCH_HIST_TEMP t
2213: set t.DB_FILE_VERS_ID =
2214: (select
2215: fv.file_version_id
2216: from

Line 2253: AD_PATCH_HIST_TEMP )t

2249: action_arguments, checkfile_args, checkobj , checkobj_un ,
2250: checkobj_pw, action_modifier, action_tierlist ,
2251: action_lang_code, concat_attribs, loader_data_file_id
2252: from
2253: AD_PATCH_HIST_TEMP )t
2254: where not exists (
2255: select
2256: 'x'
2257: FROM

Line 2265: update AD_PATCH_HIST_TEMP t

2261: and t.concat_attribs is not null;
2262: --
2263: -- Get the COMMON_ACTION_ID into the staging table
2264: --
2265: update AD_PATCH_HIST_TEMP t
2266: set t.COMMON_ACTION_ID =
2267: (select
2268: PCA.COMMON_ACTION_ID
2269: from

Line 2306: statement := 'delete from ad_patch_hist_temp'||

2302: prb_id := c1.patch_run_bug_id;
2303: ca_id := c1.common_action_id;
2304: f_id := c1.file_id;
2305:
2306: statement := 'delete from ad_patch_hist_temp'||
2307: ' where patch_run_bug_id = '||c1.patch_run_bug_id||
2308: ' and common_action_id = '||c1.common_action_id||
2309: ' and file_id = '||c1.file_id||
2310: ' and rowid <> '''||c1.row_id||'''';

Line 2345: SYSDATE, SYSDATE, 5, 5 from AD_PATCH_HIST_TEMP t

2341: t.onsite_file_vers_id,
2342: t.db_file_vers_id,
2343: t.action_executed_flag,
2344: t.dest_file_id, t.file_type_flag,
2345: SYSDATE, SYSDATE, 5, 5 from AD_PATCH_HIST_TEMP t
2346: where not exists
2347: (select
2348: 'x'
2349: from

Line 2390: SYSDATE, SYSDATE, 5, 5 from AD_PATCH_HIST_TEMP t

2386: t.onsite_file_vers_id,
2387: t.db_file_vers_id,
2388: t.action_executed_flag,
2389: t.dest_file_id, t.file_type_flag,
2390: SYSDATE, SYSDATE, 5, 5 from AD_PATCH_HIST_TEMP t
2391: where not exists
2392: (select
2393: 'x'
2394: from

Line 2583: execute immediate 'truncate table '|| p_un_fnd ||'.ad_patch_hist_temp';

2579: begin
2580: --
2581: --
2582: execute immediate 'truncate table '|| p_un_fnd ||'.ad_snapshot_files_temp';
2583: execute immediate 'truncate table '|| p_un_fnd ||'.ad_patch_hist_temp';
2584: --
2585: --
2586: if (p_is_run_flow = TRUE)
2587: then

Line 2677: insert into ad_patch_hist_temp

2673: --
2674: commit;
2675: --
2676: --
2677: insert into ad_patch_hist_temp
2678: (
2679: file_id, patch_file_vers_id , onsite_file_vers_id,
2680: bug_id, patch_run_bug_id ,
2681: db_file_vers_id, applied_flag,common_action_id,

Line 2719: update ad_patch_hist_temp tmp set

2715: --
2716: commit;
2717: --
2718: --
2719: update ad_patch_hist_temp tmp set
2720: (tmp.PATCH_VERSION_SEGMENT1, tmp.PATCH_VERSION_SEGMENT2,
2721: tmp.PATCH_VERSION_SEGMENT3, tmp.PATCH_VERSION_SEGMENT4,
2722: tmp.PATCH_VERSION_SEGMENT5, tmp.PATCH_VERSION_SEGMENT6,
2723: tmp.PATCH_VERSION_SEGMENT7, tmp.PATCH_VERSION_SEGMENT8,

Line 2740: update ad_patch_hist_temp tmp set

2736: v.file_version_id = tmp.PATCH_FILE_VERS_ID),
2737: tmp.concat_attribs=null;
2738: --
2739: --
2740: update ad_patch_hist_temp tmp set
2741: tmp.PATCH_VERSION_SEGMENT1=0, tmp.PATCH_VERSION_SEGMENT2=0,
2742: tmp.PATCH_VERSION_SEGMENT3=0, tmp.PATCH_VERSION_SEGMENT4=0,
2743: tmp.PATCH_VERSION_SEGMENT5=0, tmp.PATCH_VERSION_SEGMENT6=0,
2744: tmp.PATCH_VERSION_SEGMENT7=0, tmp.PATCH_VERSION_SEGMENT8=0,

Line 2781: ad_patch_hist_temp) where rnk=1' using v_global_snapshot_id;

2777: PATCH_VERSION_SEGMENT9 desc, PATCH_VERSION_SEGMENT10 desc,
2778: PATCH_TRANS_LEVEL desc NULLS LAST
2779: ) rnk
2780: from
2781: ad_patch_hist_temp) where rnk=1' using v_global_snapshot_id;
2782: --
2783: --
2784: commit;
2785: --

Line 2790: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_PATCH_HIST_TEMP');

2786: --
2787: if (p_iteration = 1) then
2788: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_SNAPSHOT_FILES_TEMP');
2789: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_CHECK_FILE_TEMP');
2790: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_PATCH_HIST_TEMP');
2791: end if;
2792: --
2793: --
2794: end populate_snapshot_files_temp;

Line 2840: execute immediate 'truncate table '||p_un_fnd||'.ad_patch_hist_temp';

2836:
2837: if (p_iteration = 1) then
2838: --
2839: --
2840: execute immediate 'truncate table '||p_un_fnd||'.ad_patch_hist_temp';
2841: --
2842: --
2843: insert into ad_patch_hist_temp
2844: (patch_run_id)

Line 2843: insert into ad_patch_hist_temp

2839: --
2840: execute immediate 'truncate table '||p_un_fnd||'.ad_patch_hist_temp';
2841: --
2842: --
2843: insert into ad_patch_hist_temp
2844: (patch_run_id)
2845: select
2846: snapshot_id
2847: from

Line 2897: snapshot_id in (select patch_run_id from ad_patch_hist_temp)

2893: ad_snapshot_bugfixes
2894: where
2895: bugfix_id >= p_min_bug_id and
2896: bugfix_id < p_max_bug_id and
2897: snapshot_id in (select patch_run_id from ad_patch_hist_temp)
2898: group by
2899: bugfix_id
2900: having
2901: count(distinct decode(success_flag, 'Y', 2, 1)) = 1);

Line 2928: snapshot_id in (select patch_run_id from ad_patch_hist_temp)

2924: ad_snapshot_bugfixes
2925: where
2926: bugfix_id >= p_min_bug_id and
2927: bugfix_id < p_max_bug_id and
2928: snapshot_id in (select patch_run_id from ad_patch_hist_temp)
2929: group by bugfix_id
2930: having count(distinct decode(success_flag, 'Y', 2, 1)) >1);
2931: --
2932: --

Line 2975: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_PATCH_HIST_TEMP');

2971: --
2972: if (p_iteration = 1) then
2973: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_SNAPSHOT_FILES_TEMP');
2974: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_CHECK_FILE_TEMP');
2975: FND_STATS.Gather_Table_Stats(p_un_fnd, 'AD_PATCH_HIST_TEMP');
2976: end if;
2977: --
2978: --
2979: end populate_snapshot_bugs_temp;