APPS.ICX_ITEM_DIAG_PVT dependencies on ICX_CAT_CATEGORIES_TL

Line 469: FROM icx_cat_categories_tl i

465:
466: cursor ip_cat(j number) is
467: SELECT mtl.inventory_item_id ,mtl.organization_id, i.language,
468: nvl (i.rt_category_id,- 2) ip_category_id,i.category_name ip_category_name
469: FROM icx_cat_categories_tl i
470: ,mtl_system_items_tl mtl
471: WHERE mtl.inventory_item_id = g_source_ids(j)
472: AND mtl.organization_id = nvl(g_organization_id,mtl.organization_id)
473: AND i.key = g_category_key(j)

Line 760: elsif p_table_name = 'ICX_CAT_CATEGORIES_TL' then

756: p_col_num :=4;
757: p_row_num:=p_row_num-1;
758: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
759:
760: elsif p_table_name = 'ICX_CAT_CATEGORIES_TL' then
761: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'5');
762: p_col_val(1):= 'INVENTORY_ITEM_ID';
763: p_col_val(2):= 'ORGANIZATION_ID';
764: p_col_val(3):= 'Language';

Line 1157: icx_cat_categories_tl ic1,

1153: AND mi.organization_id = fsp.inventory_organization_id
1154: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
1155: AND catMap.external_source (+) = 'Oracle'
1156: ) doc,
1157: icx_cat_categories_tl ic1,
1158: icx_cat_items_ctx_hdrs_tlp ctx
1159: WHERE ic1.key (+) = doc.category_key
1160: AND ic1.type (+) = 2
1161: AND ic1.language (+) = doc.language

Line 1826: icx_cat_categories_tl ic1,

1822: AND mi.organization_id = fsp.inventory_organization_id
1823: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
1824: AND catMap.external_source (+) = 'Oracle'
1825: ) doc,
1826: icx_cat_categories_tl ic1,
1827: icx_cat_items_ctx_hdrs_tlp ctx
1828: WHERE ic1.key (+) = doc.category_key
1829: AND ic1.type (+) = 2
1830: AND ic1.language (+) = doc.language