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_FILES

Line 1293: from ad_files f

1289: -- *suspicion* is true. %% Need NT testing to really verify)
1290: begin
1291: select f.file_id
1292: into l_apps_zip_f_id
1293: from ad_files f
1294: where f.filename = 'apps.zip'
1295: and f.app_short_name = 'AU'
1296: and f.subdir = 'java';
1297: exception when no_data_found then

Line 1298: insert into ad_files

1294: where f.filename = 'apps.zip'
1295: and f.app_short_name = 'AU'
1296: and f.subdir = 'java';
1297: exception when no_data_found then
1298: insert into ad_files
1299: (
1300: file_id,
1301: app_short_name, subdir, filename,
1302: creation_date, last_update_date, last_updated_by, created_by

Line 1306: ad_files_s.nextval,

1302: creation_date, last_update_date, last_updated_by, created_by
1303: )
1304: values
1305: (
1306: ad_files_s.nextval,
1307: 'AU', 'java', 'apps.zip',
1308: sysdate, sysdate, 5, 5
1309: ) returning file_id into l_apps_zip_f_id;
1310: end;

Line 1314: put_line('Ensuring that lib.a files exist in AD_FILES...');

1310: end;
1311:
1312: if G_DEBUG then
1313: put_line('apps.zip file-id is '||to_char(l_apps_zip_f_id));
1314: put_line('Ensuring that lib.a files exist in AD_FILES...');
1315: end if;
1316:
1317: -- Note: assumes that app-short-names are indeed APP-SHORT-NAMES, and not
1318: -- prod-abbrs, as they used to be some time back.

Line 1321: insert into ad_files

1317: -- Note: assumes that app-short-names are indeed APP-SHORT-NAMES, and not
1318: -- prod-abbrs, as they used to be some time back.
1319:
1320: -- for all the various Unix's
1321: insert into ad_files
1322: (
1323: file_id,
1324: app_short_name,
1325: subdir,

Line 1330: ad_files_s.nextval,

1326: filename,
1327: creation_date, last_update_date, last_updated_by, created_by
1328: )
1329: select -- for all the various Unix's
1330: ad_files_s.nextval,
1331: a.application_short_name,
1332: 'lib',
1333: 'lib'||decode(a.application_short_name, 'SQLGL', 'gl',
1334: 'SQLAP', 'ap',

Line 1343: from ad_files f2

1339: sysdate, sysdate, 5, 5
1340: from fnd_application a
1341: where not exists (select
1342: 'lib.a already exists'
1343: from ad_files f2
1344: where f2.filename = 'lib'||
1345: decode(a.application_short_name,
1346: 'SQLGL', 'gl',
1347: 'SQLAP', 'ap',

Line 1356: put_line('Done ensuring that lib.a files exist in AD_FILES...');

1352: and f2.subdir = 'lib'
1353: and f2.app_short_name = a.application_short_name);
1354:
1355: if G_DEBUG then
1356: put_line('Done ensuring that lib.a files exist in AD_FILES...');
1357: put_line('>>(had to insert '||to_char(sql%rowcount)||' rows)');
1358: put_line('Ensuring that st.lib files exist in AD_FILES...');
1359: end if;
1360:

Line 1358: put_line('Ensuring that st.lib files exist in AD_FILES...');

1354:
1355: if G_DEBUG then
1356: put_line('Done ensuring that lib.a files exist in AD_FILES...');
1357: put_line('>>(had to insert '||to_char(sql%rowcount)||' rows)');
1358: put_line('Ensuring that st.lib files exist in AD_FILES...');
1359: end if;
1360:
1361: -- for NT
1362: insert into ad_files

Line 1362: insert into ad_files

1358: put_line('Ensuring that st.lib files exist in AD_FILES...');
1359: end if;
1360:
1361: -- for NT
1362: insert into ad_files
1363: (
1364: file_id,
1365: app_short_name,
1366: subdir,

Line 1371: ad_files_s.nextval,

1367: filename,
1368: creation_date, last_update_date, last_updated_by, created_by
1369: )
1370: select
1371: ad_files_s.nextval,
1372: a.application_short_name,
1373: 'lib',
1374: decode(a.application_short_name, 'SQLGL', 'gl',
1375: 'SQLAP', 'ap',

Line 1384: from ad_files f2

1380: sysdate, sysdate, 5, 5
1381: from fnd_application a
1382: where not exists (select
1383: 'st.lib already exists'
1384: from ad_files f2
1385: where f2.filename = decode(a.application_short_name,
1386: 'SQLGL', 'gl',
1387: 'SQLAP', 'ap',
1388: 'OFA', 'fa',

Line 1396: put_line('Done ensuring that st.lib files exist in AD_FILES...');

1392: and f2.subdir = 'lib'
1393: and f2.app_short_name = a.application_short_name);
1394:
1395: if G_DEBUG then
1396: put_line('Done ensuring that st.lib files exist in AD_FILES...');
1397: put_line('>>(had to insert '||to_char(sql%rowcount)||' rows)');
1398: end if;
1399:
1400:

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 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 1770: from ad_files f

1766: ad_patch_hist_snaps_temp t
1767: set t.clib_arch_file_id =
1768: (
1769: select f.file_id
1770: from ad_files f
1771: where f.app_short_name = translate(t.app_short_name, 'A#', 'A')
1772: and f.subdir = 'lib'
1773: and f.filename = decode(
1774: lower(substr(t.filename, instr(t.filename,'.',-1),