APPS.EAM_MATERIAL_REQUEST_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 166: where header_id = (select header_id from mtl_txn_request_headers

162:
163: if (l_return_status = 'P') then
164: select sum(quantity_detailed) into l_partial_qty
165: from mtl_txn_request_lines
166: where header_id = (select header_id from mtl_txn_request_headers
167: where request_number = x_request_number
168: and organization_id = p_organization_id);
169: if (l_partial_qty = 0) then
170: fnd_message.set_name('EAM','EAM_MR_NO_MATERIAL_AVAILABLE');