DBA Data[Home] [Help]

APPS.GMI_SHIPPING_UTIL dependencies on MTL_UNITS_OF_MEASURE

Line 2575: /*bug 2316449 - Fetch the 25 char Unit of Measure from mtl_units_of_measure for both the UOMs*/

2571: l_group_id := p_group_id;
2572:
2573: l_secondary_unit_of_measure := null;
2574:
2575: /*bug 2316449 - Fetch the 25 char Unit of Measure from mtl_units_of_measure for both the UOMs*/
2576: If l_detail_rec.requested_quantity_uom is not null then
2577: select UNIT_OF_MEASURE
2578: into l_unit_of_measure
2579: from mtl_units_of_measure

Line 2579: from mtl_units_of_measure

2575: /*bug 2316449 - Fetch the 25 char Unit of Measure from mtl_units_of_measure for both the UOMs*/
2576: If l_detail_rec.requested_quantity_uom is not null then
2577: select UNIT_OF_MEASURE
2578: into l_unit_of_measure
2579: from mtl_units_of_measure
2580: where uom_code =l_detail_rec.requested_quantity_uom;
2581: End if;
2582:
2583: If l_detail_rec.requested_quantity_uom2 is not null then

Line 2586: from mtl_units_of_measure

2582:
2583: If l_detail_rec.requested_quantity_uom2 is not null then
2584: select UNIT_OF_MEASURE
2585: into l_secondary_unit_of_measure
2586: from mtl_units_of_measure
2587: where uom_code =l_detail_rec.requested_quantity_uom2 ;
2588: End if;
2589:
2590: -- PK Begin Bug 3925583