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 ICX_CAT_STORE_ORG_ASSIGNMENTS

Line 2236: icx_cat_store_org_assignments orgs

2232:
2233: SELECT templates.template_id, sc.store_id
2234: BULK COLLECT INTO l_template_ids, l_old_store_ids
2235: FROM icx_cat_store_catalogs sc, por_noncat_templates_all_b templates,
2236: icx_cat_store_org_assignments orgs
2237: WHERE templates.template_id = sc.item_source_id
2238: AND sc.store_id = orgs.store_id
2239: AND orgs.org_id IN (templates.org_id, -2)
2240: AND templates.template_id <> 10000000;

Line 2414: FROM icx_cat_stores_b stores, icx_cat_store_org_assignments orgs

2410:
2411: SELECT distinct(stores.store_id),
2412: decode(orgs.org_id, -2, 'ALL_USERS', 'OU_SECURED')
2413: BULK COLLECT INTO l_store_ids, l_security_flags
2414: FROM icx_cat_stores_b stores, icx_cat_store_org_assignments orgs
2415: WHERE stores.store_id = orgs.store_id;
2416:
2417: l_err_loc := 100;
2418:

Line 3884: FROM icx_cat_store_org_assignments oa

3880: (content_id, org_id, secure_by, created_by, creation_date, last_updated_by,
3881: last_update_date, last_update_login)
3882: SELECT p_new_zone_ids(i), oa.org_id, 'OPERATING_UNIT', fnd_global.user_id,
3883: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3884: FROM icx_cat_store_org_assignments oa
3885: WHERE p_old_store_ids(i) IS NOT NULL
3886: AND oa.store_id = p_old_store_ids(i)
3887: AND p_security_flags(i) = 'OU_SECURED';
3888:

Line 4607: icx_cat_store_org_assignments orgs,

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
4611: AND app_profile.level_id(+) = 10002

Line 4737: icx_cat_store_org_assignments orgs

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
4741: AND app_profile.level_value(+) = resp.application_id