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.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on FND_PROFILE_OPTIONS

Line 433: FROM fnd_profile_options p, fnd_profile_option_values v

429:
430: -- get the MO:Operating Unit profile ID and value at site level
431: SELECT p.profile_option_id, v.profile_option_value
432: INTO g_ou_profile_id, g_site_ou_profile_value
433: FROM fnd_profile_options p, fnd_profile_option_values v
434: WHERE p.profile_option_name = 'ORG_ID'
435: AND p.profile_option_id = v.profile_option_id(+)
436: AND p.application_id = v.application_id
437: AND v.level_id(+) = 10001;

Line 443: FROM fnd_profile_options p, fnd_profile_option_values v

439:
440: -- get the POR:Approved Pricing Only profile value at site level
441: SELECT nvl(v.profile_option_value, 'N')
442: INTO g_site_approved_pricing
443: FROM fnd_profile_options p, fnd_profile_option_values v
444: WHERE p.application_id = 178
445: AND p.profile_option_name = 'POR_APPROVED_PRICING_ONLY'
446: AND p.profile_option_id = v.profile_option_id
447: AND p.application_id = v.application_id