APPS.ICX_ITEM_DIAG_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 461: FROM mtl_units_of_measure muom,mtl_system_items_b mi

457: order by mic.inventory_item_id,mic.organization_id;
458:
459: cursor muom(j number) is
460: SELECT mi.inventory_item_id ,mi.organization_id , muom.unit_of_measure,muom.uom_code
461: FROM mtl_units_of_measure muom,mtl_system_items_b mi
462: WHERE mi.inventory_item_id = g_source_ids(j)
463: AND mi.organization_id = nvl(g_organization_id,mi.organization_id)
464: AND muom.uom_code = mi.primary_uom_code ;
465:

Line 736: elsif p_table_name = 'MTL_UNITS_OF_MEASURE' then

732: p_col_num :=6;
733: p_row_num:=p_row_num-1;
734: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
735:
736: elsif p_table_name = 'MTL_UNITS_OF_MEASURE' then
737: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'4');
738: p_col_val(1):= 'INVENTORY_ITEM_ID';
739: p_col_val(2):= 'ORGANIZATION_ID';
740: p_col_val(3):= 'Unit of Measure';

Line 1136: mtl_units_of_measure muom,

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)
1140: AND mi.organization_id = mparams.organization_id

Line 1805: mtl_units_of_measure muom,

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
1809: mi.organization_id = mparams.organization_id