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_OPTION_VALUES

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

Line 4605: fnd_profile_option_values resp_profile,

4601: -- get all the responsibilties with realms that can access this store
4602: SELECT distinct resp.responsibility_id
4603: BULK COLLECT INTO l_resp_with_realms_ids
4604: FROM fnd_responsibility resp,
4605: fnd_profile_option_values resp_profile,
4606: fnd_profile_option_values app_profile,
4607: icx_cat_store_org_assignments orgs,
4608: ak_resp_security_attributes arsa
4609: WHERE resp.application_id in (177, 178, 201, 396, 426)

Line 4606: fnd_profile_option_values app_profile,

4602: SELECT distinct resp.responsibility_id
4603: BULK COLLECT INTO l_resp_with_realms_ids
4604: FROM fnd_responsibility resp,
4605: fnd_profile_option_values resp_profile,
4606: fnd_profile_option_values app_profile,
4607: icx_cat_store_org_assignments orgs,
4608: ak_resp_security_attributes arsa
4609: WHERE resp.application_id in (177, 178, 201, 396, 426)
4610: AND app_profile.profile_option_id(+) = g_ou_profile_id

Line 4735: fnd_profile_option_values resp_profile,

4731: -- get all the responsibilties without realms that can access this store
4732: SELECT distinct resp.responsibility_id
4733: BULK COLLECT INTO l_resp_without_realms_ids
4734: FROM fnd_responsibility resp,
4735: fnd_profile_option_values resp_profile,
4736: fnd_profile_option_values app_profile,
4737: icx_cat_store_org_assignments orgs
4738: WHERE resp.application_id in (177, 178, 201, 396, 426)
4739: AND app_profile.profile_option_id(+) = g_ou_profile_id

Line 4736: fnd_profile_option_values app_profile,

4732: SELECT distinct resp.responsibility_id
4733: BULK COLLECT INTO l_resp_without_realms_ids
4734: FROM fnd_responsibility resp,
4735: fnd_profile_option_values resp_profile,
4736: fnd_profile_option_values app_profile,
4737: icx_cat_store_org_assignments orgs
4738: WHERE resp.application_id in (177, 178, 201, 396, 426)
4739: AND app_profile.profile_option_id(+) = g_ou_profile_id
4740: AND app_profile.level_id(+) = 10002