[Home] [Help]
447: AND mtl.organization_id = nvl(g_organization_id,organization_id) ;
448:
449: cursor mic(j number) is
450: select inventory_item_id ,organization_id,category_set_id, mic.category_id PO_CATEGORY, nvl(i.category_key ,-2) category_key,'Validate'
451: FROM mtl_item_categories mic , icx_por_category_data_sources i
452: WHERE mic.inventory_item_id = g_source_ids(j)
453: AND mic.organization_id = nvl(g_organization_id,mic.organization_id)
454: AND mic.category_set_id = g_category_set_id
455: and i.external_source(+) = 'Oracle'
619: p_col_num :=7;
620: p_row_num:=p_row_num-1;
621: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
622:
623: elsif p_table_name = 'MTL_ITEM_CATEGORIES' then
624: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'3');
625: p_col_val(1):= 'INVENTORY_ITEM_ID';
626: p_col_val(2):= 'ORGANIZATION_ID';
627: p_col_val(3):= 'CATEGORY_SET_ID';
1131: mparams.master_organization_id
1132: FROM mtl_system_items_b mi,
1133: mtl_parameters mparams,
1134: mtl_system_items_tl mitl,
1135: mtl_item_categories mic,
1136: mtl_units_of_measure muom,
1137: financials_system_params_all fsp,
1138: icx_por_category_data_sources catMap
1139: WHERE mi.inventory_item_id = g_source_ids(j)
1800: mparams.master_organization_id
1801: FROM mtl_system_items_b mi,
1802: mtl_parameters mparams,
1803: mtl_system_items_tl mitl,
1804: mtl_item_categories mic,
1805: mtl_units_of_measure muom,
1806: financials_system_params_all fsp,
1807: icx_por_category_data_sources catMap
1808: WHERE