APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on BOM_RESOURCE_EQUIPMENTS

Line 171: from bom_resource_equipments

167: CURSOR c_equip_cur(l_temp_res_id3 NUMBER) IS --for rhshriva
168: select distinct serial_number
169: from bom_dept_res_instances
170: where instance_id in (select instance_id
171: from bom_resource_equipments
172: where organization_id =p_organization_id
173: and resource_id =l_temp_res_id3 );
174:
175: /* Changed query for cursor to take care of the shared resources too - Bug 3873717 */