APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on MTL_UNITS_OF_MEASURE

Line 142: from mtl_uom_conversions muc,mtl_units_of_measure muom

138:
139:
140: CURSOR c_uom_cur(l_temp_res_id1 NUMBER) IS --rhshriva
141: select distinct muc.uom_code
142: from mtl_uom_conversions muc,mtl_units_of_measure muom
143: where muom.uom_code = muc.uom_code
144: and muc.inventory_item_id = 0
145: and nvl(muc.disable_date,sysdate+1) >sysdate
146: and muc.uom_class in (select muc2.uom_class

Line 1764: FROM po_line_types plt, mtl_units_of_measure uom, po_lines_all pla, po_distributions_all pda

1760: select sum(round(inv_convert.inv_um_convert(0,38,quantity_received,
1761: uom_code,l_uom, NULL,NULL),3))
1762: into l_quantity_received
1763: from (SELECT uom.uom_code, sum(pda.quantity_delivered) quantity_received
1764: FROM po_line_types plt, mtl_units_of_measure uom, po_lines_all pla, po_distributions_all pda
1765: WHERE pda.destination_type_code = 'SHOP FLOOR' AND (pda.PO_RELEASE_ID IS NOT NULL OR pda.DISTRIBUTION_TYPE = 'STANDARD')
1766: AND pla.line_type_id = plt.line_type_id
1767: AND upper(nvl(plt.outside_operation_flag, 'N')) = 'N' AND pla.po_line_id = pda.po_line_id
1768: AND pla.unit_meas_lookup_code = uom.unit_of_measure (+)