APPS.INV_ROI_INTEGRATION_GRP dependencies on MTL_UNITS_OF_MEASURE

Line 1936: FROM MTL_UNITS_OF_MEASURE

1932:
1933: --fetch the uom classes for primary and secondary unit_of_measures
1934: SELECT distinct(uom_class)
1935: INTO l_primary_uom_class
1936: FROM MTL_UNITS_OF_MEASURE
1937: WHERE unit_of_measure = P_PRIMARY_UNIT_OF_MEASURE;
1938:
1939: SELECT distinct(uom_class)
1940: INTO l_secondary_uom_class

Line 1941: FROM MTL_UNITS_OF_MEASURE

1937: WHERE unit_of_measure = P_PRIMARY_UNIT_OF_MEASURE;
1938:
1939: SELECT distinct(uom_class)
1940: INTO l_secondary_uom_class
1941: FROM MTL_UNITS_OF_MEASURE
1942: WHERE unit_of_measure = p_secondary_unit_of_measure;
1943:
1944: /*Check whether the unit of measure conversion is not fixed in the destination org.
1945: Fetch the SECONDARY_DEFAULT_IND from mtl_system_items_b. */

Line 2321: FROM MTL_UNITS_OF_MEASURE

2317: /*Updating source doc quantity*/
2318:
2319: SELECT distinct(uom_class)
2320: INTO l_recv_uom_class
2321: FROM MTL_UNITS_OF_MEASURE
2322: WHERE UNIT_OF_MEASURE = p_transaction_unit_of_measure;
2323:
2324: SELECT distinct(uom_class)
2325: INTO l_sourcedoc_uom_class

Line 2326: FROM MTL_UNITS_OF_MEASURE

2322: WHERE UNIT_OF_MEASURE = p_transaction_unit_of_measure;
2323:
2324: SELECT distinct(uom_class)
2325: INTO l_sourcedoc_uom_class
2326: FROM MTL_UNITS_OF_MEASURE
2327: WHERE UNIT_OF_MEASURE = p_sourcedoc_unit_of_meaure;
2328:
2329: IF g_debug = 1 THEN
2330: print_debug('Inside inv_synch_quantities :' ||l_progress , 1);

Line 2792: FROM oe_order_lines_all ,mtl_units_of_measure

2788: ----------Fetch RMA UNIT_OF_MEASURE
2789:
2790: SELECT unit_of_measure
2791: INTO l_rma_lot_unit_of_measure
2792: FROM oe_order_lines_all ,mtl_units_of_measure
2793: WHERE header_id = p_oe_order_header_id
2794: AND line_id = p_oe_order_line_id
2795: AND uom_code = order_quantity_uom;
2796: