DBA Data[Home] [Help]

APPS.OPI_EDW_UOM_CONV_F_SZ dependencies on MTL_SYSTEM_ITEMS_KFV

Line 12: mtl_system_items_kfv msik

8: select sum(cnt)
9: from (select count(*) cnt
10: FROM EDW_LOCAL_INSTANCE ELI, MTL_UOM_CONVERSIONS MUC,
11: MTL_UNITS_OF_MEASURE MUOM, MTL_UNITS_OF_MEASURE BUOM,
12: mtl_system_items_kfv msik
13: WHERE
14: muom.uom_code = muc.uom_code and
15: muom.uom_class = muc.uom_class and
16: muom.uom_class = buom.uom_class and

Line 25: mtl_system_items_kfv msik

21: select count(*) cnt
22: FROM
23: edw_local_instance eli,
24: mtl_uom_class_conversions mucc ,
25: mtl_system_items_kfv msik
26: where
27: mucc.from_uom_code <> mucc.to_uom_code and
28: msik.inventory_item_id = MUCC.INVENTORY_ITEM_ID and
29: mucc.last_update_date between p_from_date and p_to_date

Line 95: mtl_system_items_kfv msik

91: EDW_LOCAL_INSTANCE ELI,
92: MTL_UOM_CONVERSIONS MUC,
93: MTL_UNITS_OF_MEASURE MUOM,
94: MTL_UNITS_OF_MEASURE BUOM,
95: mtl_system_items_kfv msik
96: WHERE
97: muom.uom_code = muc.uom_code and
98: muom.uom_class = muc.uom_class and
99: muom.uom_class = buom.uom_class and