APPS.WIP_EAM_RESOURCE_TRANSACTION dependencies on BOM_RESOURCE_EQUIPMENTS

Line 167: from bom_resource_equipments

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