APPS.ICX_CAT_CNTNT_SCRTY_UPG_PVT dependencies on ICX_CAT_ITEM_SRC_DETAILS

Line 2476: FROM icx_por_item_sources sources, icx_cat_item_src_details details

2472: nvl2(details.supplier_id, 'INCLUDE',
2473: DECODE(sources.protocol_supported,
2474: 'LOCAL_BASE', 'INCLUDE_ALL', 'EXCLUDE_ALL'))
2475: BULK COLLECT INTO l_sources_ids, l_supplier_flags
2476: FROM icx_por_item_sources sources, icx_cat_item_src_details details
2477: WHERE sources.type = 'LOCAL'
2478: AND sources.item_source_id = details.item_source_id(+);
2479:
2480: l_err_loc := 100;

Line 3266: FROM icx_cat_item_src_details

3262: (zone_id, securing_attribute, supplier_id, created_by, creation_date,
3263: last_updated_by, last_update_date, last_update_login)
3264: SELECT p_new_zone_ids(i), 'SUPPLIER', supplier_id, fnd_global.user_id,
3265: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3266: FROM icx_cat_item_src_details
3267: WHERE item_source_id = p_catalog_ids(i);
3268:
3269: l_err_loc := 300;
3270:

Line 3673: FROM icx_por_item_sources s, icx_cat_item_src_details d

3669: (zone_id, attribute_name, attribute_value, created_by, creation_date,
3670: last_updated_by, last_update_date, last_update_login)
3671: SELECT p_new_zone_ids(i), d.name, d.value, fnd_global.user_id,
3672: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
3673: FROM icx_por_item_sources s, icx_cat_item_src_details d
3674: WHERE s.item_source_id = p_item_source_ids(i)
3675: AND s.type = 'DISTSRCH'
3676: AND s.item_source_id = d.item_source_id;
3677: