DBA Data[Home] [Help]

APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on MTL_UOM_CONVERSIONS

Line 141: from mtl_uom_conversions muc,mtl_units_of_measure muom

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

Line 146: from mtl_uom_conversions muc2

142: where muom.uom_code = muc.uom_code
143: and muc.inventory_item_id = 0
144: and nvl(muc.disable_date,sysdate+1) >sysdate
145: and muc.uom_class in (select muc2.uom_class
146: from mtl_uom_conversions muc2
147: where muc2.inventory_item_id = 0
148: and muc2.uom_code in (select unit_of_measure
149: from bom_resources
150: where resource_id in (select distinct resource_id