DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on MTL_UOM_CONVERSIONS

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 147: from mtl_uom_conversions muc2,bom_resources br

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
147: from mtl_uom_conversions muc2,bom_resources br
148: where muc2.inventory_item_id = 0
149: and muc2.uom_code = br.unit_of_measure
150: and br.resource_id = l_temp_res_id1);
151: