APPS.INV_ROI_INTEGRATION_GRP dependencies on MTL_UNITS_OF_MEASURE

Line 384: FROM oe_order_lines_all ,mtl_units_of_measure

380: in INV_ROI_INTEGRATION_GRP.Inv_Validate_rma_quantity,
381: we should convert the l_rma_quantity into RMA UNIT_OF_MEASURE.*/
382: SELECT unit_of_measure
383: INTO l_rma_unit_of_measure
384: FROM oe_order_lines_all ,mtl_units_of_measure
385: WHERE header_id = p_oe_order_header_id
386: AND line_id = p_oe_order_line_id
387: AND uom_code = order_quantity_uom;
388:

Line 2041: FROM MTL_UNITS_OF_MEASURE

2037:
2038: --fetch the uom classes for primary and secondary unit_of_measures
2039: SELECT distinct(uom_class)
2040: INTO l_primary_uom_class
2041: FROM MTL_UNITS_OF_MEASURE
2042: WHERE unit_of_measure = P_PRIMARY_UNIT_OF_MEASURE;
2043:
2044: SELECT distinct(uom_class)
2045: INTO l_secondary_uom_class

Line 2046: FROM MTL_UNITS_OF_MEASURE

2042: WHERE unit_of_measure = P_PRIMARY_UNIT_OF_MEASURE;
2043:
2044: SELECT distinct(uom_class)
2045: INTO l_secondary_uom_class
2046: FROM MTL_UNITS_OF_MEASURE
2047: WHERE unit_of_measure = p_secondary_unit_of_measure;
2048:
2049: /*Check whether the unit of measure conversion is not fixed in the destination org.
2050: Fetch the SECONDARY_DEFAULT_IND from mtl_system_items_b. */

Line 2426: FROM MTL_UNITS_OF_MEASURE

2422: /*Updating source doc quantity*/
2423:
2424: SELECT distinct(uom_class)
2425: INTO l_recv_uom_class
2426: FROM MTL_UNITS_OF_MEASURE
2427: WHERE UNIT_OF_MEASURE = p_transaction_unit_of_measure;
2428:
2429: SELECT distinct(uom_class)
2430: INTO l_sourcedoc_uom_class

Line 2431: FROM MTL_UNITS_OF_MEASURE

2427: WHERE UNIT_OF_MEASURE = p_transaction_unit_of_measure;
2428:
2429: SELECT distinct(uom_class)
2430: INTO l_sourcedoc_uom_class
2431: FROM MTL_UNITS_OF_MEASURE
2432: WHERE UNIT_OF_MEASURE = p_sourcedoc_unit_of_meaure;
2433:
2434: IF g_debug = 1 THEN
2435: print_debug('Inside inv_synch_quantities :' ||l_progress , 1);

Line 2901: FROM oe_order_lines_all ,mtl_units_of_measure

2897: ----------Fetch RMA UNIT_OF_MEASURE
2898:
2899: SELECT unit_of_measure
2900: INTO l_rma_lot_unit_of_measure
2901: FROM oe_order_lines_all ,mtl_units_of_measure
2902: WHERE header_id = p_oe_order_header_id
2903: AND line_id = p_oe_order_line_id
2904: AND uom_code = order_quantity_uom;
2905: