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.JA_CN_EAB_EXPORT_PKG dependencies on AD_RELEASES

Line 353: FROM ad_releases

349:
350: --the newest version, which should be the max of the 3 sub versions
351: SELECT major_version || '.' || minor_version || '.' || tape_version
352: INTO g_software_version
353: FROM ad_releases
354: WHERE tape_version IN
355: (SELECT MAX(tape_version)
356: FROM ad_releases
357: WHERE minor_version IN

Line 356: FROM ad_releases

352: INTO g_software_version
353: FROM ad_releases
354: WHERE tape_version IN
355: (SELECT MAX(tape_version)
356: FROM ad_releases
357: WHERE minor_version IN
358: (SELECT MAX(minor_version)
359: FROM ad_releases
360: WHERE major_version IN (SELECT MAX(major_version) FROM ad_releases)

Line 359: FROM ad_releases

355: (SELECT MAX(tape_version)
356: FROM ad_releases
357: WHERE minor_version IN
358: (SELECT MAX(minor_version)
359: FROM ad_releases
360: WHERE major_version IN (SELECT MAX(major_version) FROM ad_releases)
361: )
362: AND major_version IN (SELECT MAX(major_version) FROM ad_releases)
363: )

Line 360: WHERE major_version IN (SELECT MAX(major_version) FROM ad_releases)

356: FROM ad_releases
357: WHERE minor_version IN
358: (SELECT MAX(minor_version)
359: FROM ad_releases
360: WHERE major_version IN (SELECT MAX(major_version) FROM ad_releases)
361: )
362: AND major_version IN (SELECT MAX(major_version) FROM ad_releases)
363: )
364: AND minor_version IN

Line 362: AND major_version IN (SELECT MAX(major_version) FROM ad_releases)

358: (SELECT MAX(minor_version)
359: FROM ad_releases
360: WHERE major_version IN (SELECT MAX(major_version) FROM ad_releases)
361: )
362: AND major_version IN (SELECT MAX(major_version) FROM ad_releases)
363: )
364: AND minor_version IN
365: (SELECT MAX(minor_version)
366: FROM ad_releases

Line 366: FROM ad_releases

362: AND major_version IN (SELECT MAX(major_version) FROM ad_releases)
363: )
364: AND minor_version IN
365: (SELECT MAX(minor_version)
366: FROM ad_releases
367: WHERE major_version IN (SELECT MAX(major_version) FROM ad_releases)
368: )
369: AND major_version IN (SELECT MAX(major_version) FROM ad_releases);
370:

Line 367: WHERE major_version IN (SELECT MAX(major_version) FROM ad_releases)

363: )
364: AND minor_version IN
365: (SELECT MAX(minor_version)
366: FROM ad_releases
367: WHERE major_version IN (SELECT MAX(major_version) FROM ad_releases)
368: )
369: AND major_version IN (SELECT MAX(major_version) FROM ad_releases);
370:
371: --log for debug

Line 369: AND major_version IN (SELECT MAX(major_version) FROM ad_releases);

365: (SELECT MAX(minor_version)
366: FROM ad_releases
367: WHERE major_version IN (SELECT MAX(major_version) FROM ad_releases)
368: )
369: AND major_version IN (SELECT MAX(major_version) FROM ad_releases);
370:
371: --log for debug
372: IF (g_proc_level >= g_dbg_level) THEN
373: FND_LOG.STRING(g_proc_level,